Skip to content

Registered aircraft · 423

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

N2409XHarrison Nicholas R · Midland, NCBuilt 1965 · S/N 18256309 N2410XKitsap Aviation Squadron · Southworth, WABuilt 1965 · S/N 18256310 N2417XGerding Thomas P · Philomath, ORBuilt 1965 · S/N 18256317 N2418XPoessel Frank George Jr · East Bernard, TXBuilt 1965 · S/N 18256318 N241SRLeman Joseph A · Anchorage, AKBuilt 1965 · S/N 18256316 N2421XMills Michael N Jr · Granbury, TXBuilt 1965 · S/N 18256321 N2423XCarrier Peter · Skowhegan, MEBuilt 1965 · S/N 18256323 N2426XColwell Patrick R Jr · Medford, WIBuilt 1965 · S/N 18256326 N2428XBiggs Clifford G · Washington, UTBuilt 1965 · S/N 18256328 N2429XMontpetit Steven W · New Richmond, WIBuilt 1965 · S/N 18256329 N2432XVickers Ryan P Trustee · Tarpon Springs, FLBuilt 1965 · S/N 18256332 N2434XJensen Shaun V · Anchorage, AKBuilt 1965 · S/N 18256334 N2437XLudke Arnold · Oakland, NJBuilt 1965 · S/N 18256337 N2438XRousser Cattle LLC · Amarillo, TXBuilt 1965 · S/N 18256338 N2439XAlpha Aero LLC · Biddle, MTBuilt 1965 · S/N 18256339 N2444XRocha Frank N · Knights Ferry, CAFirst renewal noticeBuilt 1965 · S/N 18256344 N2445XBald Eagle Aviation LLC · West Chester, PABuilt 1965 · S/N 18256345 N2448XBlough Robert M · Hoonah, AKBuilt 1965 · S/N 18256348 N2450XBackcountry LLC · Ennis, MTBuilt 1965 · S/N 18256350 N2454XShiflett Tyrell · Deming, NMBuilt 1965 · S/N 18256354 N2456XBennett Annelise · Granbury, TXBuilt 1965 · S/N 18256356 N2458XMountain City Flying Club Inc · Hazle Township, PABuilt 1965 · S/N 18256358 N2460XHardy Gareld L · Rimrock, AZS/N 18256360 N2461XBallard Devin J · Quail, TXBuilt 1965 · S/N 18256361 N2465XK4 Land And Grain Co · Lothair, MTBuilt 1965 · S/N 18256365 N2469XFraulini Michael M · Franklin Furnace, OHBuilt 1965 · S/N 18256369 N2472XPhillips Robert Frank · Tabernacle, NJBuilt 1965 · S/N 18256372 N2474XKramer William L · Wellington, FLBuilt 1965 · S/N 18256374 N2475XJohnston Bruce W · Puyallup, WABuilt 1965 · S/N 18256375 N2478XCrooked Lake Aero LLC · Hammondsport, NYBuilt 1965 · S/N 18256378 N2479XKruse Interests LLC · League City, TXS/N 18256379 N2486XGreat Escape Aviation LLC · Marquette, MIBuilt 1965 · S/N 18256386 N2488XCentral Oil Co LLC · Mcminnville, TNBuilt 1965 · S/N 18256388 N2489XVanderweel Martha · Wolcott, NYBuilt 1965 · S/N 18256389 N2490XFoley David A Trustee · Afton, WYBuilt 1965 · S/N 18256390 N2491XBaalman Murray J · Grinnell, KSBuilt 1965 · S/N 18256391 N2493XKoenig William T · Sauk Centre, MNBuilt 1965 · S/N 18256393 N2497XVoeltzel Rick K · Rio Rico, AZBuilt 1965 · S/N 18256397 N2498XVotava Paul A · Mcintosh, MNBuilt 1965 · S/N 18256398 N28PWGoodnight Ranch Co · Englewood, KSBuilt 1965 · S/N 18256064 N290FCRegistration Pending · Greenwood, MSRegistration pendingBuilt 1965 · S/N 18256135 N31KEWilcox John B · South Charleston, WVBuilt 1965 · S/N 18256600 N3447S182 Corp · Rockford, ILBuilt 1964 · S/N 18255847 N3451SChancellor Marvin E · Houston, TXBuilt 1964 · S/N 18255851 N3452SWolff David Christian · Port Saint Lucie, FLBuilt 1964 · S/N 18255852 N3455SAcute Holdings LLC · Jenks, OKBuilt 1964 · S/N 18255855 N3457SC Ville Flying Club · Nunica, MIBuilt 1964 · S/N 18255857 N3459SStg LLC · Mountain Green, UTBuilt 1965 · S/N 18255859 N3461SBoyle Gene J · Moab, UTBuilt 1964 · S/N 18255861 N3465SWalker Kathleen L · Hartline, WABuilt 1964 · S/N 18255865

Back to Cessna 182H