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.

N3481XN3481x LLC · Reno, NVBuilt 1966 · S/N 3421 N3482XCollins Dallas · Columbia, SCBuilt 1966 · S/N 3422 N3486XLaas Enterprises Inc · Warrens, WIBuilt 1966 · S/N 3423 N3487XKrzeminski Paul A · San Carlos, CABuilt 1966 · S/N 3424 N3492XMckay Christopher L · Point Arena, CAS/N 3426 N3497XLawson Alan K · Kirbyville, MOBuilt 1966 · S/N 3428 N350XWeishaar Wallace O · Livingston, TXBuilt 1967 · S/N 670140 N3519HGulino Thomas V · College Park, MDBuilt 1976 · S/N 20-1220 N3527HFlight Meo LLC · Daytona Beach, FLBuilt 1976 · S/N 20-1222 N3528HBlack Kevin John · Edgewater, FLBuilt 1976 · S/N 20-1223 N3532NMoorefield Charles N · Houston, TXBuilt 1968 · S/N 680063 N3559HTipps Brandon · Shelbyville, TNBuilt 1977 · S/N 20-1233 N3573HBarnes Terry A · Austin, TXBuilt 1977 · S/N 20-1235 N358WGenco Holdings LLC Series A · Corpus Christi, TXBuilt 1966 · S/N 3417 N3599HSitter Duane A · Hayward, CABuilt 1977 · S/N 20-1238 N3601HStay Tuned LLC · Nashville, TNBuilt 1977 · S/N 20-1239 N3603HLewis Paul Jr · West Chester, PABuilt 1977 · S/N 20-1240 N3604HDobbelaere Bros Inc · Oakwood, OHS/N 20-1241 N3605HChilders Matthew W · Scottsdale, AZBuilt 1977 · S/N 20-1242 N3610HScheffing Glenn J · Palm Beach Gardens, FLBuilt 1977 · S/N 20-1246 N3611HTavalaro Joseph DBA · Massapequa, NYBuilt 1977 · S/N 20-1247 N3628HCutilo Jonathan C · Pottstown, PABuilt 1978 · S/N 20-1253 N3629HHolley Victor R · Seneca, SCBuilt 1978 · S/N 20-1254 N3638HQuantie Harold G · Locust Grove, OKS/N 20-1256 N3639HBeatty Earl IV · Gambrills, MDBuilt 1978 · S/N 20-1257 N366MDN366md LLC · Salinas, CABuilt 1974 · S/N 20-0015 N367DEHour Time Aviation LLC · Granbury, TXBuilt 1977 · S/N 20-1245 N377THMenard Keith L · Bellevue, TXS/N 3284 N3906NPoe Robert · Lincoln, CABuilt 1968 · S/N 680003 N3942NFlying Services Inc · Wilmington, DEBuilt 1968 · S/N 680007 N3964NListowski John Paul · Galveston, TXBuilt 1968 · S/N 680008 N3968NJohnson David E · Sunfish Lake, MNBuilt 1968 · S/N 680009 N3971NBravo Aviation LLC · Rexburg, IDBuilt 1968 · S/N 680010 N3984NSpencer Aviation Inc · Delaware, OHBuilt 1968 · S/N 680012 N3988NSchmeltz Sterling D · Ocala, FLBuilt 1968 · S/N 680014 N3992NBoehm Justin K · Cleveland Heights, OHS/N 680016 N3996NSumner Thurston B III · Ocracoke, NCBuilt 1968 · S/N 680017 N3KMStevens Burton G · Las Vegas, NVBuilt 1965 · S/N 2995 N3VEAero 356 LLC · Phoenix, AZS/N 3073 N4004NBrunkenhoefer Travis L · Lewisville, TXBuilt 1968 · S/N 680018 N401LALee Hunter · Colorado Springs, COBuilt 1965 · S/N 2949 N4026NSeiger T W DBA · Medford, ORBuilt 1968 · S/N 680021 N4036NJestice Manuel P · Ryder, NDBuilt 1968 · S/N 680023 N4045NPrivate Flights Inc · Harleysville, PABuilt 1968 · S/N 680025 N4050NCrawford Reagan Matthew · Lumberton, TXBuilt 1968 · S/N 680026 N4057NMominee Jules T · Evansville, INBuilt 1968 · S/N 680027 N4061NChristensen Kier · Scottsdale, AZBuilt 1968 · S/N 680028 N4068NThomas Averett V · Greensboro, NCBuilt 1968 · S/N 680030 N4073NBoswinkel Aviation Inc · Wilmington, DEBuilt 1968 · S/N 680031 N4106NGioia Matthew M · Stafford, VABuilt 1968 · S/N 680035

Back to Mooney M20C