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.

N9585MScheuneman Carl V · Plano, TXBuilt 1966 · S/N 670162 N9586MH W S Enterprises Inc · Canal Fulton, OHBuilt 1966 · S/N 670163 N9587MNorman Bradley T · Glen Rose, TXBuilt 1966 · S/N 670164 N9588MDrietz Dallas A · Lake Benton, MNBuilt 1966 · S/N 670165 N9590MRegistration Pending · Paynesville, MNRegistration pendingBuilt 1966 · S/N 670167 N9591MPeakland Properties Inc · Charleston, TNS/N 670168 N9595MRegistered aircraftBuilt 1966 · S/N 670172 N9597MRegistered aircraftBuilt 1966 · S/N 670174 N9598MBergland John Edward · Santa Monica, CABuilt 1966 · S/N 670175 N9600MAstrup Aviation Enterprises LLC · Lincoln, CABuilt 1966 · S/N 670177 N9602MCullen William P · Alexandria, VAS/N 670179 N9605MAsv Aviation LLC · Salem, ORBuilt 1966 · S/N 670182 N9611MElectron Neutrino Inc · Lewes, DEBuilt 1966 · S/N 670188 N9613MLeland Erik J · Beaverton, ORS/N 670190 N9614MSmith Michael O · Conroe, TXBuilt 1966 · S/N 670191 N9615MMorgan Mark · Durango, COBuilt 1966 · S/N 670192 N9616MBohn Aaron L · Valdosta, GAS/N 670193 N9617MSlusser Dennis G · Biggs, CAFirst renewal noticeBuilt 1966 · S/N 670194 N9618MPatton Jeremy M · Dolores, COBuilt 1966 · S/N 670195 N961JKRegistration Pending · Menasha, WIRegistration pendingBuilt 1976 · S/N 22-1400 N9620VLetendre Norman W · Port Saint Lucie, FLBuilt 1971 · S/N 22-0011 N9621MSkys Mooney LLC · Missoula, MTBuilt 1966 · S/N 670198 N9622MRegistered aircraftBuilt 1966 · S/N 670199 N9623MHerb Adam W · Phoenix, AZBuilt 1966 · S/N 670200 N9625MGreen Evan Michael · Midland, TXBuilt 1966 · S/N 670202 N9628MMeyer Michael A Trustee · Phoenix, AZBuilt 1966 · S/N 670205 N9631MOrvin Sanden Inc · Wyndmere, NDBuilt 1966 · S/N 670208 N9632MAvimar · Marina Del Rey, CABuilt 1966 · S/N 670209 N9633MGould Zachary · Pleasant Hill, MOBuilt 1966 · S/N 670210 N9634MBig Sky Flying Inc · Napa, CAS/N 670211 N9635MN9635m LLC · Cumming, GABuilt 1966 · S/N 670212 N9636MBistline Leland K · Fredonia, AZBuilt 1966 · S/N 670213 N9640MDavis Psychological Services Pc · Grinnell, IABuilt 1966 · S/N 670217 N9643MExquisite Aviation Inc · Coachella, CABuilt 1966 · S/N 670220 N9644MBurley Joseph D · Fayetteville, GABuilt 1966 · S/N 670221 N9647MSoaring Eagle Flying Club · Midland, MIBuilt 1966 · S/N 670224 N9648MN9648m LLC · Louisville, KYBuilt 1967 · S/N 670225 N964JCIceman Air LLC · Stafford, VABuilt 1976 · S/N 22-1355 N9652MManna Farms Inc · Sherwood, NDS/N 670229 N9658MReames B Robert Jr · Six Lakes, MIS/N 670235 N9660MKnight Aviation LLC · Comanche, OKBuilt 1966 · S/N 670237 N9662MPotter Colin · Piedmont, SDBuilt 1966 · S/N 670239 N9664MProvide It Air Solutions LLC · Tampa, FLS/N 670356 N9665MMr Aviation Group LLC · Mifflintown, PABuilt 1966 · S/N 670242 N9698MCiota Shane · Tucson, AZBuilt 1967 · S/N 670245 N969DGDelta Sierra Avia Inc · West New York, NJBuilt 1967 · S/N 680117 N9701MInternational Air Services Inc Trustee · Carson City, NVS/N 670261 N9702MPippin Alan D · Prattville, ALBuilt 1967 · S/N 670262 N9703MBertucci David · Sunnyvale, CABuilt 1967 · S/N 670263 N9707MCombs Charles D · Buffalo, MOBuilt 1967 · S/N 670267

Back to Mooney M20F