Skip to content

Registered aircraft · 706

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

N4423RAviation Specialists Inc · Gonzales, LABuilt 1978 · S/N R18200597 N4447RManos Con Alas Ministries · Sierra Madre, CABuilt 1978 · S/N R18200601 N4449RMorrow David · Maynardville, TNBuilt 1978 · S/N R18200602 N44CAWiley Commercial Property Consulting Inc · Aitkin, MNBuilt 1980 · S/N R18201556 N452RAMelvin Mark · Berkeley, CABuilt 1979 · S/N R18200634 N4594SBlock Taylor · Sibley, IAS/N R18201351 N4617SDelange Burke G · Scottsdale, AZBuilt 1979 · S/N R18201356 N4649TNew York Aircam Corp · Woodbury, NYBuilt 1981 · S/N R18201724 N4652TSilver Wings Aviation LLC · Kalispell, MTS/N R18201725 N4656SEtheridge Caleb · Cedartown, GAS/N R18201368 N4661TPowell Christopher T · Moosic, PAS/N R18201727 N4678TRothberg Diane Lee · Gainesville, GABuilt 1981 · S/N R18201730 N4685TMalagrifa Richard · Swampscott, MABuilt 1981 · S/N R18201734 N4687SP & V Howard Enterprises LLC · Angleton, TXBuilt 1979 · S/N R18201380 N4688SDiaz Eliu · Charlotte, NCBuilt 1979 · S/N R18201381 N4689SHoffman Joseph A · El Dorado Hills, CABuilt 1979 · S/N R18200591 N468RGMyers Michael J · Vinton, IABuilt 1979 · S/N R18201057 N4696THess Aero Corp Inc · Huntsville, ALBuilt 1981 · S/N R18201737 N469EHClaybrook Douglas E · Little Rock, ARBuilt 1978 · S/N R18200335 N4706SGreat Lakes Aviation LLC · Burtchville, MIBuilt 1979 · S/N R18201392 N4707TVan Ausdall John C · Spring Branch, TXBuilt 1981 · S/N R18201739 N4709SMolinar Antonio L · El Paso, TXBuilt 1979 · S/N R18201395 N4719TOchoa Ricardo · Douglas, AZS/N R18201742 N4728TThree Prop LLC · Dallas, TXBuilt 1981 · S/N R18201746 N4751TAerial Perspective LLC · Mount Holly, NJBuilt 1981 · S/N R18201751 N4752SRion Aviation Corporation · Wilmington, DEBuilt 1979 · S/N R18201414 N4757THagen Brian T · Allen, TXBuilt 1981 · S/N R18201754 N4765TWehrman David Hugh · Queen Creek, AZS/N R18201756 N4769TBowsap LLC · Manson, WABuilt 1981 · S/N R18201757 N4773SSonrex LLC · Auburn, INBuilt 1979 · S/N R18201423 N4773THagerman John · Coxs Creek, KYBuilt 1981 · S/N R18201761 N4776THigh Planes Air Service · Bismarck, NDBuilt 1981 · S/N R18201762 N4779TAmerican Aerial Patrol LLC · Saint Amant, LABuilt 1981 · S/N R18201764 N4786SMultiprop Ventures LLC · Danvers, MABuilt 1979 · S/N R18201427 N4787SClassic Image Auto LLC · Huntsville, ALS/N R18201428 N47UAleco 182 LLC · Vestavia Hills, ALBuilt 1980 · S/N R18201525 N4803TValiair Lc Trustee · Casper, WYBuilt 1981 · S/N R18201770 N480SCZephyr Services LLC · Long Beach, CABuilt 1978 · S/N R18200455 N4820SCalico Construction Inc · Kensington, MDBuilt 1979 · S/N R18201432 N4834SBuell Bay Co · Irvington, VABuilt 1979 · S/N R18201434 N4856THub City Aviation LLC · Spartanburg, SCFirst renewal noticeBuilt 1981 · S/N R18201777 N4861SMidwest Airmotive Inc · Mount Sterling, KYBuilt 1979 · S/N R18201439 N4863TM & M Light Transportation Co Inc · Duluth, MNBuilt 1981 · S/N R18201778 N4871TApex Corporation · Stanley, NDS/N R18201779 N4873RCavu Clearing LLC · Center Harbor, NHBuilt 1978 · S/N R18200616 N4873SBurke Mark S · Kindred, NDBuilt 1979 · S/N R18201440 N4894TBar Aviation LLC · Madison, ALBuilt 1981 · S/N R18201782 N48FHG-Stf LLC · Midland, TXBuilt 1979 · S/N R18201018 N4910SMarden John E · Oakland, MEBuilt 1980 · S/N R18201449 N4927SDaniel L Voiers · Hephzibah, GABuilt 1980 · S/N R18201466

Back to Cessna R182