Skip to content

Registered aircraft · 270

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

N8974XHarris Warren R · Mccleary, WABuilt 1960 · S/N 18253374 N8981XBales Philip J · Chandler, AZBuilt 1961 · S/N 18253381 N8984XSkydive Florida Keys Inc · Summerland Key, FLBuilt 1961 · S/N 18253384 N8985XHill Jack · New Lenox, ILS/N 18253385 N8993XEvans David J · Parker, COBuilt 1961 · S/N 18253393 N8995XHowards Hangar LLC · Peachtree City, GABuilt 1961 · S/N 18253395 N8996XRobertson Timothy A · Lewistown, MTS/N 18253396 N9000XAbidance Inc · Winthrop, WAS/N 18253400 N9003XPaselk Stuart · Winchester, ORS/N 18253403 N9004XMay James P · Huntington, WVBuilt 1961 · S/N 18253404 N9007XGustafson Stephen M · Tallulah, LABuilt 1961 · S/N 18253407 N9009XChick Theodore D DBA · Beulah, NDS/N 18253409 N9011XCowan James H · New Springfield, OHS/N 18253411 N9012XGone Flying LLC · Bartlesville, OKS/N 18253412 N9013XSpooner Brian P · Poway, CABuilt 1961 · S/N 18253413 N9014XSudoh Kenji · Duluth, MNBuilt 1961 · S/N 18253414 N9016XWolfe John G · Tooele, UTS/N 18253416 N9019XJudah LLC · Springdale, ARBuilt 1961 · S/N 18253419 N9020XBrackett Clayton J · Coopersville, MIBuilt 1961 · S/N 18253420 N9022XPartner 91 LLC · Scottsdale, AZBuilt 1961 · S/N 18253422 N9023XBlue Skies Matter LLC · Spokane, WABuilt 1961 · S/N 18253423 N9027XDelauder Patrick J · Terra Alta, WVBuilt 1961 · S/N 18253427 N9028XGold Coast Skydivers Louisiana Adventures LLC · Slidell, LABuilt 1961 · S/N 18253428 N9029XWichmann David · Park City, UTBuilt 1961 · S/N 18253429 N9032XWalters Douglas R · Sunbury, OHBuilt 1961 · S/N 18253432 N9034XCunningham Patrick J · Council Bluffs, IABuilt 1961 · S/N 18253434 N9036XNiemeyer Henry · Eagle River, AKS/N 18253436 N9037XFornasier Manuel Jr · Westcliffe, COBuilt 1961 · S/N 18253437 N9039XAhrens Videll A · Tintah, MNBuilt 1961 · S/N 18253439 N9040XAcme Air Venture Inc · Bristol, WIS/N 18253440 N9043XKruger Bruce W · Gustavus, AKS/N 18253443 N9047XKelley Ronald C · Deer Lodge, MTBuilt 1961 · S/N 18253447 N9048XK Fortner LLC · San Marcos, TXBuilt 1961 · S/N 18253448 N9050XClassy Cockpits LLC · Ham Lake, MNBuilt 1961 · S/N 18253450 N9053XI Buy U Fly LLC · Prescott Valley, AZBuilt 1961 · S/N 18253453 N9054XKnowles Charles M Jr · Chapmanville, WVBuilt 1961 · S/N 18253454 N9058XSouthern Skies Aviation Inc · Cedar City, UTBuilt 1960 · S/N 18253458 N9059XHunt William E Jr · San Jose, CABuilt 1961 · S/N 18253459 N9060XLattin Travis W · Beloit, KSBuilt 1960 · S/N 18253460 N9061XSmithhart James R · Normandy Park, WABuilt 1961 · S/N 18253461 N9063XGregory Larry C Trustee · Farmington, MOBuilt 1961 · S/N 18253463 N9064XCherokee Three LLC · Greensboro, NCBuilt 1961 · S/N 18253464 N9066XSkyskaters LLC · Portland, ORBuilt 1961 · S/N 18253466 N9067XN78305 LLC · Kindred, NDBuilt 1961 · S/N 18253467 N9068XWeinberg Jerry J · Metairie, LABuilt 1961 · S/N 18253468 N9069XKeefer Aviation LLC · Lancaster, OHBuilt 1961 · S/N 18253469 N9070XWeisenberger Michael J · Norwalk, OHBuilt 1961 · S/N 18253470 N9073XHartung Eric C · Howard, SDBuilt 1961 · S/N 18253473 N9074XDistel Richard G · Loveland, COBuilt 1961 · S/N 18253474 N9077XTmax Aviation LLC · Newcastle, WYBuilt 1961 · S/N 18253477

Back to Cessna 182D