Skip to content

Registered aircraft · 380

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

N901JMGuderjahn Raymond · Garden Plain, KSBuilt 1962 · S/N 18253901 N917HSJpm Aircraft Leasing LLC · Wilmington, DEBuilt 1962 · S/N 18253933 N9200XCochreham Bryce O · Seibert, COBuilt 1962 · S/N 18253600 N9202XNohrenberg Larry R · Jamestown, NDBuilt 1962 · S/N 18253602 N9203XPeru Projects Inc · Lincoln, NEBuilt 1962 · S/N 18253603 N9207XHegge Darren S · Priest River, IDBuilt 1961 · S/N 18253607 N9211XSalter 11x LLC · Duluth, MNS/N 18253611 N9212XNs Aviation Inc · Ottumwa, IABuilt 1961 · S/N 18253612 N9213XChung Thomas · Stanwood, WABuilt 1961 · S/N 18253613 N9221XBoettger Gordon R · Carson City, NVBuilt 1961 · S/N 18253621 N9222Erkmann Christopher R Trustee · Chesterfield, MOBuilt 1962 · S/N 18254216 N9222XJones Margaret C · San Marcos, TXBuilt 1961 · S/N 18253622 N9225XMenix Travis L · Russell Springs, KYBuilt 1961 · S/N 18253625 N9226XJjm3 LLC · Twin Falls, IDS/N 18253626 N9231XPrelesnick Tony · Claremore, OKBuilt 1961 · S/N 18253631 N9232XRamirez Martin · Rockwall, TXBuilt 1961 · S/N 18253632 N9239XCarroll Bodo W · Franklin, OHBuilt 1962 · S/N 18253639 N9240XN9240x LLC · Martinsville, INBuilt 1961 · S/N 18253640 N9242XB Roberts Aviation LLC · Clovis, CABuilt 1961 · S/N 18253642 N9243XSchoo Peter L · Lewiston, IDBuilt 1961 · S/N 18253643 N9245XLeupp John R · Taylors, SCBuilt 1961 · S/N 18253645 N9246XGrodi Leslie A · Monroe, MIBuilt 1961 · S/N 18253646 N9248XPadua Corp · Wilmington, DEBuilt 1961 · S/N 18253648 N9250XRapchak Barbara A · Batavia, ILBuilt 1961 · S/N 18253650 N9251XWhite Ronald V · Overgaard, AZBuilt 1961 · S/N 18253651 N9260XColvin Buster · Big Cabin, OKBuilt 1961 · S/N 18253660 N9263XMieloszyk Nicholas A · Elko, NVS/N 18253663 N9265XWestern Pilot Service Inc · Phoenix, AZBuilt 1961 · S/N 18253665 N9266XWeichert Robert S · Parker, COS/N 18253666 N9270XCastle Rock Services LLC · Helena, MTBuilt 1961 · S/N 18253670 N9274XGawlik Leslie W · Reisterstown, MDBuilt 1961 · S/N 18253674 N9279XKhoury Alain W · Wills Point, TXBuilt 1961 · S/N 18253679 N9285XBlu Kaya LLC · Austin, TXS/N 18253685 N9286XRogne Fred A · Fallon, NVBuilt 1961 · S/N 18253686 N9289XFull Send Aviation LLC · Fairview, TNS/N 18253689 N9290XPetrich John W · Metaline Falls, WABuilt 1961 · S/N 18253690 N9293XRod Ricky L · El Cajon, CABuilt 1961 · S/N 18253693 N9296XJasuma Farms · Maxwell, CABuilt 1961 · S/N 18253696 N9297XJohnson Durwood D · Beaumont, TXBuilt 1962 · S/N 18253697 N9300XEdwards Karen Marie · Mcminnville, ORS/N 18253700 N9301XShaunkoe LLC · Merrill, ORBuilt 1961 · S/N 18253701 N9308X5p&P LLC · Glenwood Springs, COBuilt 1961 · S/N 18253708 N9309XRigsby R W · Salisbury, NCBuilt 1961 · S/N 18253709 N9311XLink Lance L · Concordia, KSBuilt 1961 · S/N 18253711 N9312XLewan William F · Naperville, ILBuilt 1962 · S/N 18253712 N9317XMoonshine Energy LLC · Midland, TXBuilt 1961 · S/N 18253717 N9318XTopnotch Aero Inc · Austin, TXBuilt 1962 · S/N 18253718 N9319XShepherd Joseph R · Fayetteville, GAS/N 18253719 N9323XBertelsen Sven Erik · Gulfport, FLBuilt 1961 · S/N 18253723 N9327XHull Ray · Waynoka, OKS/N 18253727

Back to Cessna 182E