Skip to content

Registered aircraft · 465

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

N1014TInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N R18201650 N1018HGulf Air Group Inc · Crestview, FLBuilt 1980 · S/N R18201649 N103ASHill Bryan Thomas · Page, AZBuilt 1979 · S/N R18200923 N106RMAdvanced Aviation Solutions LLC · Jasper, INBuilt 1983 · S/N R18201932 N10CRCarlile Aviation LLC · Peculiar, MOBuilt 1981 · S/N R18201808 N10GRamsey Wayne · Abilene, TXBuilt 1979 · S/N R18201161 N111FFGutierrez Isaias · Fontana, CAS/N R18200807 N113CJMarshall Joshua · Chuckey, TNBuilt 1979 · S/N R18201076 N124MARobison Ronald D · Idaho Falls, IDBuilt 1978 · S/N R18200627 N1255SSmith David J · Broken Arrow, OKBuilt 1979 · S/N R18201279 N125LARussell Aviation LLC · San Diego, CAS/N R18201012 N1333PJones Robert Conrad · Seeley Lake, MTBuilt 1979 · S/N R18200875 N14MTSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N R18201227 N155CTOutsideloop LLC · Denver, COBuilt 1979 · S/N R18201277 N15BEAvalon Aviation USA Corp · Murfreesboro, TNBuilt 1981 · S/N R18201806 N182BESimmons Charles · Cora, WYBuilt 1979 · S/N R18200909 N182BLMccaan Jerome · Bethel, MES/N R18201200 N182DKTonso Antonio · Roseville, CABuilt 1980 · S/N R18201665 N182ESwanson Jorge A · Douglas, AZBuilt 1979 · S/N R18201114 N182EGBurnette Ric · Sebastian, FLBuilt 1979 · S/N R18200787 N182FBDownwind Abeam Inc · Pasadena, CABuilt 1979 · S/N R18201422 N182HCDrake Craig C · Brandon, MSBuilt 1978 · S/N R18200734 N182JFLeah LLC · Center Conway, NHBuilt 1979 · S/N R18201193 N182KCBas Part Sales LLC · Greeley, COBuilt 1979 · S/N R18201139 N182SHColes Robert John Jr · Santa Barbara, CABuilt 1980 · S/N R182-01348 N182SPT Mark Fay Consulting Inc · Naperville, ILBuilt 1979 · S/N R18201003 N182WDLewis W D III · San Carlos, CABuilt 1979 · S/N R18200848 N182ZSGil Ricardo G · New Braunfels, TXBuilt 1997 · S/N R18200977 N1898XScott Ayer Interests LLC · Phoenix, AZBuilt 1982 · S/N R18201898 N1911HAdair Aviation LLC · Mountain Home, ARBuilt 1980 · S/N R18201550 N2068SN2068s LLC · Solana Beach, CABuilt 1979 · S/N R18201295 N2072SKelty Joel P · Portland, ORBuilt 1979 · S/N R18201298 N210BBCherry Hill Aviation C182 LLC · Freetown, INBuilt 1979 · S/N R18201430 N212BCRoberts Randall K · Clayton, NMBuilt 1979 · S/N R18201098 N215DBHurst Jeffrey A Trustee · Tahoe City, CABuilt 1980 · S/N R18201641 N2182SCimprich Michael J · Kirkland, WABuilt 1979 · S/N R18201311 N2194SUziel Yehoram · Northridge, CAS/N R18201312 N2198SPeavey Brian H · Houston, TXBuilt 1979 · S/N R18201314 N2225TBunger Richard E · Spring Branch, TXBuilt 1977 · S/N R18200001 N222PFStokes Brian L · Boulder City, NVBuilt 1979 · S/N R18201308 N222WAWiseman Aviation Inc · Flagstaff, AZS/N R18201443 N223BDN223bd LLC · Fresno, CABuilt 1980 · S/N R18201454 N2256SGuttzeit Aviation LLC · Baton Rouge, LAS/N R18201316 N226WTFegert Jeffery · Las Vegas, NVS/N R18201735 N2276SBogaudo Robert J · Vulcan, MIBuilt 1979 · S/N R18201318 N2277SSimmons Matthew Steven · Port Orange, FLBuilt 1979 · S/N R18201319 N2283SForbess Tod A · Lubbock, TXS/N R18201323 N228CABowles Thomas J · Prairie Village, KSBuilt 1981 · S/N R18201686 N2294RSeeliger Jeremy E · Pasco, WABuilt 1978 · S/N R18200584 N2297SRocketjet LLC · Incline Village, NVS/N R18201328

Back to Cessna TR182