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.

N167LDRegistered aircraftS/N 670105 N175KTTurney Gerald E · Oakland, CABuilt 1962 · S/N 2382 N17HTSund Kenneth · Edmonds, WABuilt 1975 · S/N 20-1172 N17WJAngel Wings Flyers LLC · Wilson, NCBuilt 1964 · S/N 2881 N185DCWood Ronal D Jr · Clarksville, FLS/N 2239 N187TATech Air LLC · Lexington Park, MDBuilt 1964 · S/N 2688 N188DHDunworth Jack R · Rutledge, GABuilt 1968 · S/N 680119 N1900YMarrero Francisco J · Lake Charles, LABuilt 1964 · S/N 2684 N191ABRegistration Pending · Newport, ORRegistration pendingBuilt 1963 · S/N 2471 N191DJScallion Leon Ivy · Pine Bluff, ARBuilt 1965 · S/N 3206 N191HCTrinair Aviation LLC · Hampshire, ILBuilt 1965 · S/N 2992 N1920CVanjara Gufran U · San Ramon, CABuilt 1964 · S/N 2686 N1954YSasse David L · Rio Rancho, NMS/N 2691 N1972WCaruso Timothy Ernest · Gainesville, VABuilt 1962 · S/N 2332 N1PFTownes Patrick S · Lucerne Valley, CABuilt 1964 · S/N 2898 N202GESt Amant Mark S · Diamond Bar, CABuilt 1964 · S/N 2896 N202JAAdams Toby R · Paris, TXBuilt 1963 · S/N 2570 N20RTTyson Richard E · Barton, FLBuilt 1966 · S/N 3309 N20YBBurdick Rich · Montrose, COFirst renewal noticeBuilt 1964 · S/N 2708 N211MMAir Images Co LLC · Cochranville, PAS/N 1951 N211SCBc & Cs Holding LLC · Waxahachie, TXBuilt 1969 · S/N 690042 N216KKKleszcz Kenneth A · Wethersfield, CTBuilt 1962 · S/N 2042 N218MMN218mm LLC · Portland, ORBuilt 1964 · S/N 2825 N2200KLogston Thomas L · Ocala, FLBuilt 1962 · S/N 2058 N220BDAlexander Nathan D · Melrose, IABuilt 1964 · S/N 2862 N2211WTucker Christian Taylor · Butler, MOBuilt 1964 · S/N 2875 N221BBCendejas Agustin · Chino, CABuilt 1968 · S/N 690006 N222GDSolverson Aircraft Management LLC · Waunakee, WIS/N 2185 N224CMDerstine Ernest B · Pantego, NCBuilt 1962 · S/N 2203 N2413Gabardi Duane A · Manitou Springs, COBuilt 1963 · S/N 2624 N249DMAnderson Spencer D · Lafayette, LAS/N 2514 N2553WBrown Jeffrey B · Punta Gorda, FLBuilt 1965 · S/N 3265 N2559WHighfill Randall W · Hannibal, MOBuilt 1965 · S/N 3268 N2564WReynolds Stuart N II · Church Road, VABuilt 1965 · S/N 3270 N2567WSullivan Eric V · Santa Barbara, CABuilt 1965 · S/N 3271 N2568WSale Reported · Modesto, CASale reportedBuilt 1965 · S/N 3272 N2572WFlournoy Thomas H · Port Republic, NJBuilt 1965 · S/N 3273 N2573WTrail Air LLC · Springdale, ARBuilt 1965 · S/N 3274 N2577WSiegel Theodore Matthew · Merritt Island, FLBuilt 1965 · S/N 3275 N2578WCain Mitchell J · Ellisville, MOBuilt 1965 · S/N 3276 N2582WPetersen Bennett David · Ashland, OHBuilt 1965 · S/N 3277 N2583WRuckel Daniel A · Floyds Knobs, INBuilt 1965 · S/N 3278 N2587WOrourke Timothy L · Laguna Niguel, CABuilt 1965 · S/N 3279 N2588WJohnson Mitchell R · Bismarck, NDBuilt 1965 · S/N 3280 N2593WUehlin Bradley S · Danbury, NEBuilt 1965 · S/N 3282 N2596WClark Richard · Towanda, PABuilt 1965 · S/N 3283 N25JWFly 2 Hope LLC · Hilliard, FLBuilt 1962 · S/N 2004 N2600WDeaero LLC · Darwin, MNS/N 3285 N2605WHarman David M · Ballwin, MOBuilt 1965 · S/N 3287 N2615WSturgis Joel B · Pensacola, FLBuilt 1965 · S/N 3292

Back to Mooney M20C