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.

N9267VCabina Maintenance LLC · Waxhaw, NCBuilt 1969 · S/N 690074 N9268MN9268m LLC · Reseda, CABuilt 1966 · S/N 670037 N9275VBridges Linda Arnett · Friendswood, TXBuilt 1969 · S/N 690076 N9277VAoa Aviation Service LLC · Waxhaw, NCBuilt 1969 · S/N 690077 N9286VRupinski Casimir Michael III · Cape May, NJBuilt 1969 · S/N 690080 N9288VMooney N9288v LLC · Fernandina Beach, FLBuilt 1969 · S/N 690081 N9289MUa Aero LLC · Lewes, DEBuilt 1966 · S/N 660004 N9294VMulligan Sean S · Kitty Hawk, NCBuilt 1969 · S/N 690082 N929CKWilko Air Two LLC · Van Wert, OHBuilt 1975 · S/N 22-1192 N929PGN929pg LLC · Bethlehem, PABuilt 1967 · S/N 680039 N9300VRyan C Hanneken · Hollywood, MDS/N 690084 N9308VDapaah Seth O · Upper Marlboro, MDBuilt 1969 · S/N 690086 N9326VSprang Bob E · Smithville, OHBuilt 1969 · S/N 700002 N9330VWest Daryl DBA · Kirkland, WABuilt 1969 · S/N 700003 N9344VOchoa Hougan Michael H · Chino Hills, CABuilt 1970 · S/N 700052 N9356VWilson Willard L · Daphne, ALBuilt 1969 · S/N 700009 N9363VEye Squared Holdings Inc · Houston, TXBuilt 1969 · S/N 700011 N9368VMontrose Paul F · Greenbrier, ARBuilt 1969 · S/N 700013 N9377MFlying Cookies LLC · Lyman, SCBuilt 1966 · S/N 670001 N9378MStratus Investment Corp · Lino Lakes, MNBuilt 1966 · S/N 670002 N9378VN83993 LLC · Cherry Hill, NJBuilt 1969 · S/N 700016 N9380MSmith Ralph · Bel Air, MDBuilt 1966 · S/N 670004 N9382MBonifay Jason · Corona Del Mar, CABuilt 1966 · S/N 670006 N9383MTitle Benjamin H · Arlington, VABuilt 1966 · S/N 670007 N9384MNorfolk Aviation LLC · Norfolk, VAS/N 670008 N9386MWhite Jason · Lewes, DEBuilt 1966 · S/N 670010 N9387MKastner Doug · Prineville, ORBuilt 1966 · S/N 670011 N9387VPabst Erik R · Claremont, CABuilt 1969 · S/N 700018 N9388MN9388m LLC · Sheridan, WYBuilt 1966 · S/N 670012 N9389MRutledge Richard L · Hurst, TXBuilt 1966 · S/N 670013 N9390MKim Peter · Henderson, NVBuilt 1966 · S/N 670014 N9391MWilliams John A · Kirkland, WABuilt 1966 · S/N 670015 N9393MClassic Country Properties Inc · Sutter Creek, CAS/N 670017 N9394MN9394m LLC · Conway, ARBuilt 1966 · S/N 670018 N9396VWilliams Tom C III · Grovetown, GABuilt 1969 · S/N 700020 N9398MPearson Merten G Dvm · Amarillo, TXBuilt 1966 · S/N 670022 N9403VSwift Damian · Livermore, CAS/N 700022 N9407VWarkentin Lynden K · Russell Springs, KYBuilt 1969 · S/N 700023 N9414VMax Mix Gourmet Spice Blends LLC · Rocky Mount, MOS/N 700025 N9426VTwo Guys One Plan LLC · Clermont, FLBuilt 1970 · S/N 700029 N9427VBrack Enterprises LLC · Indianapolis, INBuilt 1970 · S/N 700053 N9430VRuff Deborah · Auburn, CABuilt 1970 · S/N 700030 N9441VKarge Robert F · Peachtree City, GAS/N 700034 N9456VSnover Darryl A · Cherryville, PABuilt 1970 · S/N 700037 N9460VDodie Aviation LLC · Sheridan, WYBuilt 1970 · S/N 700038 N9481VStutzman Mervin · Kingman, INBuilt 1970 · S/N 700046 N9489VReeder John Galen · Cedar Falls, IAS/N 700048 N9494VDoerr Jim · Austin, TXBuilt 1970 · S/N 700049 N9496VEvans Richard I · Elko, NVS/N 700050 N9500MZoom Thusiasts LLC · Smyrna, GABuilt 1967 · S/N 670258

Back to Mooney M20F