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.

N4109NRoss George H · Delano, MNS/N 680036 N4120NBurr Eugene F Jr · Lugoff, SCS/N 680037 N412HMCain Ryan C · Beaumont, CABuilt 1975 · S/N 20-1163 N412MRMundy Mark · Cape Coral, FLBuilt 1968 · S/N 680163 N419TEEp Enterprises Inc · San Juan, PRS/N 20-0039 N427SFN427sf LLC · Lakeview, NCBuilt 1966 · S/N 3410 N444DJSims George W III · Eclectic, ALBuilt 1970 · S/N 700075 N444KRSmith Wylie J · Hawthorne, FLS/N 690068 N445WTClayton Edwin G · North Chesterfield, VABuilt 1964 · S/N 2776 N4564HSwanson Terence S · Montrose, COBuilt 1965 · S/N 3006 N466TCSale Reported · Sarasota, FLSale reportedBuilt 1965 · S/N 2989 N46HSBlackburn Aviation Air LLC · Mesa, AZS/N 3430 N46JLWeaver Aviation LLC · Yucaipa, CABuilt 1975 · S/N 20-1169 N4961KGirolami Philip · Fircrest, WABuilt 1977 · S/N 20-1232 N4AULineberger Joel Preston · Catawba, NCBuilt 1963 · S/N 2430 N505CEMoore Travis S · Montrose, COBuilt 1968 · S/N 680092 N505LShores Robert C · Rocklin, CABuilt 1965 · S/N 3171 N518TPos LLC · Glencoe, MOS/N 3466 N51CTLionudakis Chris L · Conroe, TXBuilt 1962 · S/N 2034 N521CBHodge Cleo U · St Thomas, VIBuilt 1962 · S/N 2304 N524TLMoroni Nanette Teresa DBA · Orlando, FLBuilt 1965 · S/N 3086 N52RMStone Patrick S Jr · Houston, TXBuilt 1961 · S/N 1852 N543UCAllred Bradly James · San Francisco, CABuilt 1964 · S/N 2758 N5503QPrecious Metal Aviation LLC · Menomonee Falls, WIBuilt 1965 · S/N 2940 N5505QReynolds C J · Cornelius, NCBuilt 1965 · S/N 2941 N5509QCarlson Jeremy Nathaniel · Arnold, CABuilt 1965 · S/N 2943 N5511QJohnston Evan · Yakima, WABuilt 1965 · S/N 2944 N5517QTrayhan Edward J · Schertz, TXBuilt 1965 · S/N 2947 N5529QWhipple Ron · Etna, CABuilt 1965 · S/N 2953 N5533QBoldt Matthew Frederick · Santa Fe, NMBuilt 1965 · S/N 2955 N5535QJohnson Bar Inc · Pensacola, FLBuilt 1965 · S/N 2956 N5539QJostad Leo D · Bottineau, NDBuilt 1965 · S/N 2958 N5545QVan Wagner Paul A · Waterford, PABuilt 1965 · S/N 2961 N5547QMooney N5547q LLC · Sacramento, CABuilt 1965 · S/N 2962 N5553QLieff Daniel · Yellow Springs, OHBuilt 1965 · S/N 2965 N5561QRoberson Richard J Jr · Panama City, FLBuilt 1965 · S/N 2969 N5563QFishero John D · Spring, TXBuilt 1965 · S/N 2970 N5567QRicol Aviation LLC · Naples, FLBuilt 1965 · S/N 2972 N5569QBrian C Elbert · Rochester, NHBuilt 1965 · S/N 2973 N5571QBerry Charles P · Monroe, NCBuilt 1965 · S/N 2974 N5573QAthens Neurology Professional Association · Athens, TXBuilt 1965 · S/N 2975 N5585QCoxwell James · Midlothian, TXBuilt 1965 · S/N 2981 N5591QDelogu Joseph F · Orland Park, ILBuilt 1965 · S/N 2985 N5592QGrant Charles A Jr · Denton, TXBuilt 1965 · S/N 2986 N5593QBrazdys Luke V · Kingman, AZBuilt 1965 · S/N 2987 N5595QLivezey Patrick · Lithia, FLBuilt 1965 · S/N 2988 N5599QFerraro Christopher · Croydon, PABuilt 1965 · S/N 2990 N5601QRegistered aircraftBuilt 1965 · S/N 2999 N5602QWacker Jeremy C · Denver, COBuilt 1965 · S/N 3102 N5611QSale Reported · Star Prairie, WISale reportedBuilt 1965 · S/N 3004

Back to Mooney M20C