Skip to content

Registered aircraft · 829

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

N9210VHarrison Joe · Atlanta, TXS/N 690044 N9215VGonzalez Cruz · North Las Vegas, NVS/N 690045 N9219VChen Brian K · Bakersfield, CABuilt 1969 · S/N 690047 N9220MBeaty David · Santa Fe, NMBuilt 1966 · S/N 1181 N9225MSmith Carl L · Danville, KYBuilt 1966 · S/N 1184 N9225VDuncan Mark E · Marlton, NJBuilt 1969 · S/N 690048 N9228MSteubs Mike H · Portland, ORBuilt 1966 · S/N 1185 N9228VDuval James A · Lima, OHBuilt 1969 · S/N 690049 N9229MMadsen Jan Eric · Lincoln, NEBuilt 1966 · S/N 1186 N9230MPernick Kevin · Milford, IABuilt 1966 · S/N 1187 N9231VShaffer Lawrence · West Des Moines, IABuilt 1969 · S/N 690050 N9233MSlone Buddie M · Waynesburg, KYBuilt 1966 · S/N 1188 N9234MRed Tail Scholarship Foundation · Tuskegee, ALBuilt 1966 · S/N 1189 N9235VLott William F Jr Trustee · Oklahoma City, OKBuilt 1969 · S/N 690051 N9240MMathews Justin R · Omaha, NEBuilt 1966 · S/N 1193 N9243MHill James C · Grand Saline, TXBuilt 1966 · S/N 1194 N9244MAntos Corey · Leland, NCBuilt 1966 · S/N 1195 N9245MIneson Thomas · Edgewood, NMBuilt 1966 · S/N 1196 N9248MTaylor Douglas W · Tucson, AZBuilt 1966 · S/N 1197 N9249MMaverick Aviation LLC · Richmond, KYBuilt 1966 · S/N 1198 N9253VChristopher Damien · Savannah, GAS/N 690056 N9254MWhittaker Victor · Panama City Beach, FLBuilt 1966 · S/N 1201 N9257VKelley Gaylord L Jr · Murrells Inlet, SCBuilt 1969 · S/N 690057 N9258MJones Mavin D · Monroe, UTBuilt 1966 · S/N 1203 N9260MRegistered aircraftBuilt 1966 · S/N 1205 N9262VAdams Kirk A · Sanger, CABuilt 1969 · S/N 690058 N9263MBarefoot Releaf LLC · Scottsdale, AZBuilt 1966 · S/N 1206 N9264MRegistered aircraftBuilt 1966 · S/N 1207 N9265MKobe Thomas J · Lake Placid, FLBuilt 1966 · S/N 1208 N9269MHernandez Raul H · Chico, CABuilt 1966 · S/N 1210 N9270MMcmanus Nicholas A · Versailles, KYBuilt 1966 · S/N 1211 N9274MGibson Rodney A · Saluda, NCBuilt 1966 · S/N 1213 N9276VBlair Jason C · Elbert, COS/N 690062 N9278MIlya Sevrugin · Santa Clarita, CABuilt 1966 · S/N 1215 N9280VReifel Harry C Jr · Boxford, MABuilt 1969 · S/N 690065 N9283MHazelswart India A · Chase City, VABuilt 1966 · S/N 670001 N9284VBloomer Garett · Ballston Lake, NYBuilt 1969 · S/N 690064 N9288MHogue Marc A · Tempe, AZBuilt 1966 · S/N 1221 N9292MAkro N9292m LLC · Lighthouse Point, FLBuilt 1966 · S/N 1225 N9292VPacini Ross Alex · Roseville, CABuilt 1969 · S/N 690063 N9296VOswald Paul C · Shohola, PABuilt 1970 · S/N 700049 N9297MBowers Matthew Monroe · Dayton, NVBuilt 1966 · S/N 1230 N9298VJones Eric S · Tucson, AZBuilt 1969 · S/N 690067 N92BRQuinn Kenneth V · Pearl City, ILBuilt 1965 · S/N 566 N9301MPivac Jorge I · Chandler, AZS/N 1234 N9303MPierotti Robert Paul · Bowie, TXBuilt 1966 · S/N 1236 N9304MSweeney William B · Leesville, LABuilt 1966 · S/N 1237 N9305MSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 1238 N9306MV1 Consulting Co · Crestwood, KYBuilt 1966 · S/N 1239 N9306VWilliams Steven M · Redwood, NYS/N 690069

Back to Mooney M20E