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.

N6471QNugent Todd · Lake Bluff, ILBuilt 1967 · S/N 680013 N6472QCornay Louis J Jr · Franklin, TNBuilt 1967 · S/N 680014 N6474QSale Reported · Sarasota, FLSale reported, canceledBuilt 1967 · S/N 680016 N6476QPacheco Enrique Roman · Albuquerque, NMBuilt 1967 · S/N 680018 N6478QGlasgow Christopher S · Morgans Point, TXBuilt 1967 · S/N 680020 N6479QRegistration Pending · Myrtle Beach, SCRegistration pendingS/N 680021 N6480QTadlock Stephen S · Midland, TXBuilt 1967 · S/N 680022 N6482QStevenson Randall J · Wildwood, MOBuilt 1967 · S/N 680024 N6485QWaller Drew · Bellville, TXBuilt 1967 · S/N 680027 N6486QHilhorst Kenneth E · Rocky Mount, NCBuilt 1967 · S/N 680028 N6487QGordon Jeff · Cleveland, OHFirst renewal noticeBuilt 1967 · S/N 680029 N6488QClark Thomas L · Kingman, AZBuilt 1967 · S/N 680030 N6489QMccurry Aviation Company LLC · Weatherford, TXBuilt 1967 · S/N 680031 N6490QSuchting Carl J · Little Egg Harbor, NJS/N 680032 N6495QBaker Chad W · Forney, TXBuilt 1967 · S/N 680037 N6498QShartle Wesley P · Fredericksburg, PABuilt 1967 · S/N 680040 N6499QWhiteside Kim D · Decatur, ILBuilt 1967 · S/N 680041 N651RKChristensen Nathan · Newnan, GABuilt 1968 · S/N 680125 N6718NHoefly Christopher S · Belleview, FLBuilt 1968 · S/N 680175 N6720NWatson Andrew J · Chelmsford, MABuilt 1968 · S/N 680176 N6722NShipman Jesse L · Honey Grove, TXBuilt 1968 · S/N 680177 N6731NLarue Bruce W · Oberlin, KSS/N 680182 N6734NMerritt James H Jr · Charlotte, NCBuilt 1968 · S/N 680184 N6737NCox James G · Yankton, SDBuilt 1968 · S/N 680186 N6739NMeyer Ross · Apollo Beach, FLBuilt 1968 · S/N 680187 N673LJLegg Daniel T · Knoxville, TNBuilt 1976 · S/N 22-1414 N6740NGraham Bruce A · Port Saint Joe, FLBuilt 1968 · S/N 680188 N6744NVan Benschoten Mark T · Linwood, MIBuilt 1968 · S/N 680190 N6746NOlive City Flying Club Inc · Corning, CABuilt 1968 · S/N 680191 N6748NMcneil Scott · Phoenix, AZS/N 680192 N6754VTharp Kenneth Lynn · Apple Valley, CABuilt 1970 · S/N 700054 N6756VFelicione Frank S Jr · Idaho Falls, IDFirst renewal noticeBuilt 1970 · S/N 700055 N6767VParmenter Micah J · Aurora, COBuilt 1970 · S/N 700059 N6770VDobalian Vaughn E · Jacksonville Beach, FLBuilt 1970 · S/N 700060 N6781VSullivan Michael G · Newport Beach, CABuilt 1970 · S/N 700063 N6794VNewman James · Gillette, WYBuilt 1970 · S/N 700068 N6797VForslund Blake · Allendale, MIBuilt 1970 · S/N 700069 N6799VPolgreen Andrew · Leonardtown, MDBuilt 1970 · S/N 700070 N67EXLatterell Jerry W · Foreston, MNS/N 670227 N67LGDowd Timothy W · Stuart, FLBuilt 1967 · S/N 670515 N67MJHorton James D · Las Vegas, NVBuilt 1967 · S/N 670447 N67UWarbington Michael L · Enid, OKS/N 670303 N6847VSell James Leo II · Tempe, AZBuilt 1975 · S/N 22-1240 N6848VHalbrooks David N · Centerville, TNS/N 22-1241 N6849VMcguire Rick · Liberty, TXBuilt 1975 · S/N 22-1242 N6850VCemo Management Inc · San Antonio, TXBuilt 1975 · S/N 22-1243 N6851VKing Jason G · Newnan, GABuilt 1975 · S/N 22-1244 N6853VReuland Aviation Services LLC · Marietta, GAS/N 22-1246 N6854VRegistered aircraftBuilt 1975 · S/N 22-1247 N6855VN6855v LLC · Madras, ORBuilt 1975 · S/N 22-1248

Back to Mooney M20F