Skip to content

Registered aircraft · 487

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

N101SPHawkes Clark · Gillsville, GABuilt 1986 · S/N 18268562 N105SPDepartment Of Emergency Svcs & Public Protection · Hartford, CTBuilt 1984 · S/N 18268425 N105VBHughes Francis A · Ltl Egg Hbr Twp, NJBuilt 1981 · S/N 18268138 N107SPDepartment Of Emergency Svc & Public Protection · Hartford, CTBuilt 1984 · S/N 18268427 N111SRPayne John A · Bloomington, ILBuilt 1981 · S/N 18268005 N113HBSnyder Shad J · Quincy, WABuilt 1983 · S/N 18268318 N114CZMinnesota Department Of Public Safety · Saint Paul, MNBuilt 1981 · S/N 18267892 N116AHRegistered aircraftBuilt 1981 · S/N 18267966 N116HRRedpaw Aviation Ltd · Upper Arlington, OHBuilt 1986 · S/N 18268579 N118HRDieschbourg Thomas Arthur · Glenview, ILBuilt 1983 · S/N 18268332 N118SCLeathers Charles M · Silverthorne, COBuilt 1981 · S/N 18268069 N127ETThomas Eric C · Boise, IDBuilt 1982 · S/N 18268234 N1319EEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268173 N1323EHu Zhehua · Sunnyvale, CAS/N 18268174 N1354ESandra And Mose Rucker III LLC · Perrineville, NJBuilt 1982 · S/N 18268175 N1386EWitsoe Kathleen · Knoxville, TNBuilt 1982 · S/N 18268176 N13DSR & M Adventures LLC · Wichita, KSBuilt 1980 · S/N 18267798 N1420EEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268177 N1432ENorrisky Consulting LLC · Bozeman, MTBuilt 1982 · S/N 18268178 N1440ECreighton Mark · Port Aransas, TXBuilt 1982 · S/N 18268179 N146EN146e LLC · Thomasville, GABuilt 1982 · S/N 18268292 N149TBonilla Jose · Pembroke Pines, FLBuilt 1981 · S/N 18267896 N151CTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1984 · S/N 18268410 N161CTEddy Company Inc · Apple Valley, CABuilt 1984 · S/N 18268414 N1622Susanville Aviation LLC · Susanville, CAS/N 18268181 N165NHExpert Aircraft Thinking & Restoration LLC · Wilmington, DEBuilt 1984 · S/N 18268382 N166DGDg Air LLC · Oakland, TNS/N 18267796 N169PPOrtiz Peter · El Paso, TXBuilt 1985 · S/N 18268444 N171UNancy Unicorn LLC · Seattle, WABuilt 1982 · S/N 18268147 N179WZCatterton Jane S · Signal Mountain, TNBuilt 1981 · S/N 18268036 N1816JWakefield Aircraft LLC · Cooperstown, NDS/N 182-68574 N181UKauffman Daniel C · Spring Grove, PABuilt 1981 · S/N 18268135 N182BPRegistered aircraftBuilt 1980 · S/N 18267737 N182CMMccleary Thomas R · Ione, CABuilt 1982 · S/N 18268152 N182DEVelez Harry · Rio Vista, CAS/N 18268540 N182ETEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268180 N182GLMcdonough Eugene A · Glen Allen, VAS/N 18268407 N182GRSenestraro Daniel E Trustee · Johnson, KSBuilt 1981 · S/N 18268120 N182KU182 Aviation LLC · Waco, TXBuilt 1981 · S/N 18267906 N182LTAcme 182 Tx LLC · Round Rock, TXBuilt 1981 · S/N 18267986 N182RTSlow Vso LLC · Helena, MTS/N 18267719 N182SQMiller David H · Shamokin, PABuilt 1981 · S/N 18267840 N182XLMid Valley Flying LLC · Progreso, TXBuilt 1981 · S/N 18268043 N18TBCarlson Herb Trustee · Dana Point, CABuilt 1981 · S/N 18267978 N199NLees Larry J · Pryor, OKBuilt 1986 · S/N 18268548 N2131ZAllen Travis · Newport, MEBuilt 1982 · S/N 18268165 N214HPKilleen Sean B · Allentown, PABuilt 1980 · S/N 18267732 N2181EDbk Aviation LLC · Wilmington, DEBuilt 1982 · S/N 18268188 N21SJPointcloud Aviation LLC · Plymouth, MNBuilt 1981 · S/N 18267869 N2366EWerner Service & Trucking Inc · Saint Edward, NEBuilt 1982 · S/N 18268197

Back to Cessna 182R