Skip to content

Registered aircraft · 721

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

N100TEBlaney Robert L · Newark, OHBuilt 1975 · S/N 22-1255 N103PTAvion Guy LLC · Baton Rouge, LABuilt 1975 · S/N 22-1252 N10CHGulf Coast Rail Service Inc · Victoria, TXBuilt 1969 · S/N 690048 N112PHRegistered aircraftBuilt 1967 · S/N 670466 N1133XBristol Aircraft Leasing LLC · Willoughby, OHBuilt 1967 · S/N 670504 N118RCAscent Aviation LLC · Lander, WYBuilt 1966 · S/N 670036 N133CLDukes Grant M · Horseshoe Bay, TXBuilt 1970 · S/N 700004 N135JCNelson Bradley L · Portland, ORBuilt 1967 · S/N 670337 N13MDMoorstein Mark A · Manassas, VABuilt 1967 · S/N 680025 N14483Amar John D · Las Vegas, NVBuilt 1976 · S/N 22-1405 N167QQGrondahl Chad R · Peyton, COBuilt 1966 · S/N 670149 N177TCCaram John M · Saint Leonard, MDBuilt 1975 · S/N 221231 N17ACPressley Brent DBA · Morristown, TNBuilt 1967 · S/N 670329 N187JWBriley Christopher P · Lynchburg, VABuilt 1970 · S/N 700056 N19411Taylor Fred H · Plano, TXBuilt 1969 · S/N 690085 N1967FLeander Henry Anske IV · San Antonio, TXBuilt 1967 · S/N 670456 N1969FRandel Benjamin Steven · Zionsville, INBuilt 1969 · S/N 690061 N197AWO'Steen James D Jr · Laurel, FLS/N 670295 N202PMIrons Gregory B · Nixa, MOBuilt 1967 · S/N 670440 N204TAAnderson Thomas W · Mustang, OKBuilt 1967 · S/N 680059 N20UKN Registration Service LLC Trustee · Sanford, NCBuilt 1976 · S/N 22-1380 N211CTCabe Jonathan W · Dallas, TXBuilt 1966 · S/N 670083 N211DWSamuel James · College Station, TXBuilt 1969 · S/N 690079 N211HKGtairco LLC · Sandy Springs, GABuilt 1976 · S/N 22-1340 N211KBCan-Wal LLC · Fort Smith, ARBuilt 1967 · S/N 670491 N211MEN211me LLC · Brownsburg, INBuilt 1969 · S/N 700006 N211NTaylor Matthew · Orlando, FLBuilt 1975 · S/N 22-1278 N212MTLindenauer David L · Boca Raton, FLBuilt 1967 · S/N 670305 N212MZInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 22-1332 N212SCDavies Charles C · Lovettsville, VABuilt 1967 · S/N 680111 N212WDFoghorn Airfleet LLC · Columbus, INBuilt 1968 · S/N 680066 N21NABeck Donald R · Lakeland, TNBuilt 1968 · S/N 680203 N221HPHardie Zachary · Ypsilanti, MIBuilt 1967 · S/N 670468 N222RJAmbrose James · Dyersburg, TNBuilt 1977 · S/N 22-1438 N2269PBlackwell Steve · Lewisburg, TNBuilt 1966 · S/N 670152 N226ADDercole Anthony · Bowden, GABuilt 1967 · S/N 680076 N2288TRegistered aircraftBuilt 1966 · S/N 670204 N22NSWeachock Michael J · Franklin Park, NJBuilt 1976 · S/N 22-1430 N22WDEhrler Ryan R · Spokane, WABuilt 1967 · S/N 680110 N234GAAllen Dean C II · Green Sea, SCBuilt 1967 · S/N 680036 N234MPBaugher Gregory V · Hannibal, MOBuilt 1968 · S/N 680183 N24BSSiemers Warren G · Fort Collins, COBuilt 1967 · S/N 670495 N2667WMartens Steven A · Stanley, NDBuilt 1966 · S/N 670024 N26HSCole Gregory B DBA · Santa Cruz, CABuilt 1967 · S/N 670343 N27MCFratangelo Robert A · Sodus, NYBuilt 1969 · S/N 690043 N2905LSteel Alan P · Odessa, TXBuilt 1967 · S/N 670299 N2906LHogue Aviation LLC · Dover, PABuilt 1967 · S/N 670300 N2908LGurney Stephen E · Niceville, FLBuilt 1967 · S/N 670302 N2910LBurger Walter F III · Sugar Land, TXBuilt 1967 · S/N 670304 N2914LPanalucent LLC · Saint Petersburg, FLBuilt 1967 · S/N 670486

Back to Mooney M20F