Skip to content

Registered aircraft · 1,605

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('2071602', '2071603')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2071602', '2071603')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N2380VGyrogeo Aerial Survey LLC · Bangor, MEBuilt 1948 · S/N 14618 N2387VOmstead Jordan · Lamoni, IABuilt 1948 · S/N 14626 N2390NNewsom Kevin J · Bloomington, INBuilt 1947 · S/N 12639 N2391VVanderloop Thomas J · Kaukauna, WIFirst renewal noticeBuilt 1948 · S/N 14631 N2392VRipley Craig D · Willshire, OHBuilt 1948 · S/N 14633 N2394VRed Sky Aviation LLC · Livermore, CABuilt 1948 · S/N 14635 N2397VPerry Robert A · Tucson, AZBuilt 1948 · S/N 14639 N2400VGangwish John P · Shelton, NES/N 14730 N2402VEph Aviation LLC · Phoenix, AZBuilt 1948 · S/N 14645 N2404VMix Timothy R · Hubbard, ORBuilt 1948 · S/N 14647 N2408VRegistered aircraftBuilt 1948 · S/N 14652 N2411NLouisiana Taildraggers LLC · New Orleans, LABuilt 1947 · S/N 12660 N2412VKinzie Hon K · Anchorage, AKBuilt 1948 · S/N 14657 N2414VBible Larry · Sumner, TXBuilt 1948 · S/N 14659 N2415VDouble T LLC · Galesburg, ILBuilt 1948 · S/N 14661 N2417NZanuzoski Alan K · Hillsboro, ORBuilt 1947 · S/N 12666 N2422VKeilman Geary P · Las Vegas, NVBuilt 1948 · S/N 14669 N2423VDtc Flying Club LLC · Sycamore, ILBuilt 1948 · S/N 14670 N2425VHathaway Ben · Corvallis, ORBuilt 1948 · S/N 14673 N2427VN2427v LLC · Southbury, CTS/N 14675 N2429VMoriarty Gerry J · Anchorage, AKS/N 14677 N2430NPace Seth M · Malibu, CABuilt 1947 · S/N 12682 N2430VN4629x LLC · Middletown, DES/N 14679 N2432NMastre Benjamin T · Soldotna, AKBuilt 1947 · S/N 12684 N2432VBell John W · South Haven, MIBuilt 1948 · S/N 14681 N2434NGiovanetti Anthony J · Seymour, CTBuilt 1947 · S/N 12687 N2437VMidtgaard Michael A · Mason City, IABuilt 1948 · S/N 14687 N2438NJerch Richard A · Lake Bluff, ILBuilt 1947 · S/N 12691 N2438VMadsen James E · New Underwood, SDBuilt 1948 · S/N 14688 N2439VLavalley Asset Management Inc · Potsdam, NYS/N 14689 N2443NHayward Jeffrey L · Thomasville, GABuilt 1947 · S/N 12696 N2447VCarpe Diem Atb LLC · Northfield, MNBuilt 1948 · S/N 14699 N2449NHoffman Stephen J · Seabrook, TXBuilt 1947 · S/N 12702 N2449VTenhoff Lee L · Homer, AKS/N 14701 N2450VAbbott Cedric M · Buckfield, MES/N 14703 N2455NMorse David W · Priest Lake, IDS/N 12708 N2458NNafe Robert H · Holly Springs, NCBuilt 1947 · S/N 12711 N2459NLehnert Daniel S · Pekin, ILBuilt 1947 · S/N 12712 N2461VDaughs Robert H · Christmas Valley, ORS/N 14714 N2462VNeal Mark M · Ponte Vedra, FLS/N 14715 N2464NGiber Kristofor D · Manvel, TXBuilt 1947 · S/N 12-717 N2466NParsons John C · Wichita, KSS/N 12719 N2467NSpinell Clintton John · Hollister, CAS/N 12720 N2468VHudson Larry K · Midwest City, OKBuilt 1948 · S/N 14736 N2470VBelany Joseph S · Ashland, WIBuilt 1948 · S/N 14738 N2473VSheehan Dennis P · Addison, ILFirst renewal noticeS/N 14742 N2479NClark Richard A · Warren, MIBuilt 1947 · S/N 12732 N2485VTrayhan Edward J · Schertz, TXBuilt 1948 · S/N 14754 N2486VSale Reported · Billings, MTSale reportedBuilt 1948 · S/N 14755 N2488NByrne Mark T · Owensboro, KYBuilt 1955 · S/N 12741

Back to Cessna 140