Skip to content

Registered aircraft · 1,258

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

N2957LJohnson Cullen L · Abernathy, TXS/N 670091 N2958LStormo Jarrod M · Indianapolis, INBuilt 1967 · S/N 670092 N2959LMcphillips Jess H · Port Arthur, TXBuilt 1967 · S/N 670093 N2962LAllen Marcus I · Little Elm, TXBuilt 1967 · S/N 670096 N2966LCarpenter Robert E · Huntsville, ALBuilt 1967 · S/N 670100 N2967L2967lima LLC · Scott City, MOS/N 670101 N2971LRegistered aircraftBuilt 1967 · S/N 680002 N2976LRichardson Samuel O · Villa Rica, GABuilt 1967 · S/N 670136 N297VLewis Rodney · Andalusia, ALBuilt 1966 · S/N 3389 N2997LStorke Paul E · Laguna Beach, CABuilt 1967 · S/N 670102 N2998LJentes Charles A · Smithville, OHS/N 670103 N2999LSodt Brian K · Kernersville, NCBuilt 1967 · S/N 670104 N2VZUrbizu Carlos A · Tampa, FLBuilt 1968 · S/N 680015 N311XStevens Adam · Dacono, COBuilt 1963 · S/N 2592 N312AVAshley Dallas · Cardiff By The Sea, CABuilt 1968 · S/N 680049 N31DMLejeune David E · Lake Charles, LABuilt 1977 · S/N 20-1248 N31GGSchwend Brian · Forsyth, MTBuilt 1964 · S/N 2683 N3203FChampagne Anthony J · Prairieville, LABuilt 1967 · S/N 670123 N3238AHawley Timothy J · Ashland, OHBuilt 1965 · S/N 3185 N325PLTargia Kerry Marie · Statesville, NCS/N 3441 N32FDMansfield Stephen K · Boynton Beach, FLS/N 20-1249 N333JFWolfe LLC · Rogers, TXBuilt 1963 · S/N 2493 N3351XRuther Dennis A · Lake Havasu City, AZFirst renewal noticeBuilt 1966 · S/N 3370 N3360XCrail Aviation LLC · Colorado Springs, COBuilt 1966 · S/N 3373 N3376XVanmeter Investments LLC · Tecumseh, OKBuilt 1966 · S/N 3380 N3380XGretencord Howard F Trustee · Kansas City, MOBuilt 1966 · S/N 3381 N3381XBagwell Trevor T · Valencia, CABuilt 1966 · S/N 3382 N3385XKelly Paul M · Granite Bay, CABuilt 1966 · S/N 3383 N3390XPrince Aviation LLC · Las Vegas, NVS/N 3385 N3391XDunham Seth Aaron · Acampo, CABuilt 1966 · S/N 3386 N3396XS R Gilliam Construction Inc · Carthage, NCS/N 3388 N33DSAvion Ahoy LLC · Jacksonville, FLS/N 680176 N33ZZNmfc Inc · Branchburg, NJBuilt 1977 · S/N 20-1231 N3405XMurray Lacounte O · Leander, TXBuilt 1966 · S/N 3391 N3406XThuerauf John E · Plum City, WIBuilt 1966 · S/N 3392 N3411XLo Lo Aviation Inc · Wilmington, DEBuilt 1966 · S/N 3394 N3415XHackford Dalton Decory · Vernal, UTS/N 3395 N3420XBurns Kevin D · Decatur, TXBuilt 1966 · S/N 3397 N3421XAltitude Aviation Servieces LLC · Mountain Home, IDS/N 3398 N3436XWebb Chris · Burns, TNBuilt 1966 · S/N 3403 N3442XHouse Joseph Bradley · Lawrence, MSBuilt 1966 · S/N 3406 N3446XLin-Aero LLC · Conway, ARBuilt 1966 · S/N 3407 N3447XRmm Enterprises Inc · Isabel, SDS/N 3408 N3461XPerez Carlos D · Horizon City, TXBuilt 1966 · S/N 3413 N3462XNewberry Alfred L · Harrison, ARBuilt 1966 · S/N 3414 N3466XHenley Brad L · Fairview, TXBuilt 1966 · S/N 3415 N3467XKnowles Christopher Alan · Oklahoma City, OKBuilt 1966 · S/N 3416 N3472XWei Jeremy · Holmdel, NJS/N 3418 N3476XChristy Parker Consulting LLC · Wake Forest, NCBuilt 1966 · S/N 3419 N3477XCoulter Jack E · Chapel Hill, NCBuilt 1966 · S/N 3420

Back to Mooney M20C