Skip to content

Registered aircraft · 1,565

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 ('2072732')
  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 ('2072732')
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.

N759JFCrc Aviation LLC · Woodville, MSS/N 18266025 N759JGMgvw Capital Holdings LLC · Saint Petersburg, FLS/N 18266026 N759JH3d Capture LLC · Lumberton, TXBuilt 1977 · S/N 18266027 N759JMAas LLC · Ovid, MIBuilt 1977 · S/N 18266031 N759JNMike Rinker Aircraft LLC · Union City, TNBuilt 1977 · S/N 18266032 N759JRSeks Ventures Inc · Middletown, DEBuilt 1977 · S/N 18266035 N759JXOptic Air LLC · Maurice, IABuilt 1977 · S/N 18266041 N759KAAtmore Places LLC · Fernandina Beach, FLBuilt 1977 · S/N 18266044 N759KBBoschma Henry F · Terrebonne, ORBuilt 1977 · S/N 18266045 N759KCMccrea Daniel B · Waldport, ORS/N 18266046 N759KDRegistered aircraftS/N 18266047 N759KGWhite Thomas G II · Knoxville, PAS/N 18266050 N759KJJohnson Thomas N · Greensboro, GAS/N 18266052 N759KKWesterlin Harrington Flying Service Inc · Holdrege, NEBuilt 1977 · S/N 18266053 N759KMDahlen Donald · Isle, MNBuilt 1977 · S/N 18266055 N759KPSc-Dsc LLC · Rocklin, CABuilt 1977 · S/N 18266057 N759KQKudrna Kenneth D · Poplar Grove, ILBuilt 1977 · S/N 18266058 N759KSAlessio Pretto G · Pawling, NYBuilt 1977 · S/N 18266060 N759KTFrancis Larry Lee Dds Pc · Evanston, WYBuilt 1977 · S/N 18266061 N759KVGorman Peter J · Valley Center, CABuilt 1977 · S/N 18266063 N759KWRodgers Robert W · Louisville, KYS/N 18266064 N759LCPegasus Aviation LLC · Moscow, IDS/N 18266070 N759LDKnutson Wayne R · Thompson, NDS/N 18266071 N759LEFridell Terrell · Charlotte, NCBuilt 1977 · S/N 18266072 N759LFMurphy Carl Lee · Gastonia, NCBuilt 1977 · S/N 18266073 N759LGTilton Glenn E · Cheyenne, WYBuilt 1977 · S/N 18266074 N759LHKent William C Jr · Memphis, TNBuilt 1977 · S/N 18266075 N759LKCs III Aviation LLC · New Orleans, LABuilt 1977 · S/N 18266077 N759LPAzar Suzanne S · El Paso, TXBuilt 1977 · S/N 18266081 N759LUMike-Upd LLC · Roseburg, ORBuilt 1977 · S/N 18266086 N759LVJav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 18266087 N759LWOlson Dave · Richardton, NDBuilt 1977 · S/N 18266088 N759LXLexiair LLC · Little Mountain, SCBuilt 1977 · S/N 18266089 N759MAValley Fliers Inc · Auburn, WABuilt 1977 · S/N 18266092 N759MBMiller Curtis Vern · Sugar Land, TXBuilt 1977 · S/N 18266093 N759MKFarnsworth Harold · Mesa, AZBuilt 1977 · S/N 18266101 N759MQPretre Alan G · Mitchell, SDBuilt 1977 · S/N 18266106 N759MSMechanical Construction Services Inc · Newark, ARBuilt 1977 · S/N 18266108 N759MUCool Creek Aviation LLC · New Orleans, LAS/N 18266110 N759MVHirneisen Natalie A · Flourtown, PABuilt 1977 · S/N 18266111 N759MWDirect North Inc · Solon, OHBuilt 1977 · S/N 18266112 N759MXSchulz Roger B Trustee · Burlington, IABuilt 1977 · S/N 18266113 N759MYN759 My LLC · Reading, MABuilt 1977 · S/N 18266114 N759MZRochholz Edward · Medford, ORFirst renewal noticeBuilt 1977 · S/N 18266115 N759NASteffora Philip T · Hollister, CABuilt 1977 · S/N 18266116 N759NBClerget Joseph B · Bonney Lake, WABuilt 1977 · S/N 18266117 N759NCRegistered aircraftBuilt 1977 · S/N 18266118 N759NDNelson Donald O · Eureka, CABuilt 1977 · S/N 18266119 N759NFN759nf LLC · Wilmington, DEBuilt 1977 · S/N 18266121 N759NGWackman Ranch · Elk Grove, CABuilt 1977 · S/N 18266122

Back to Cessna 182Q