Skip to content

Registered aircraft · 116

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

N177FDSale Reported · Bowling Green, KYSale reportedBuilt 1967 · S/N 680040 N207LSNightbreak Aviation LLC · Houston, TXBuilt 1968 · S/N 680072 N212MWColorado Mountain Leisure LLC · Sioux Falls, SDBuilt 1969 · S/N 690005 N21FWilson Christopher J · W Hartford, CTBuilt 1967 · S/N 680043 N3293FYe Xiaofeng · Los Gatos, CABuilt 1968 · S/N 680001 N333WJKite Neal · Kansas City, MOBuilt 1968 · S/N 680053 N3587XFlynn Sean C · Torrance, CABuilt 1968 · S/N 680156 N3592XBryant David Wayne · Ada, OKBuilt 1968 · S/N 680161 N3611NDowden Frank D · Fallbrook, CABuilt 1967 · S/N 680010 N3613NBradbury Kevin Earl · Saint George, UTBuilt 1967 · S/N 680011 N3615NWalker Eric L · Southlake, TXBuilt 1967 · S/N 680012 N3616NDe Masters Jasper · Bakersfield, CABuilt 1967 · S/N 680013 N3618NYoung Donald Colin · West Plains, MOBuilt 1967 · S/N 680014 N3619NChiques Aero Corporation · Lancaster, PABuilt 1967 · S/N 680015 N3620NMooney N3620n LLC · Chesterfield, MOBuilt 1967 · S/N 680016 N3630NSalvesen William · Clermont, NJBuilt 1967 · S/N 680018 N3633NPerotti Camille C · Carolina Beach, NCBuilt 1967 · S/N 680019 N3640NShaikh Samir K · Schaumburg, ILS/N 680021 N3641NVilliger Arnold H · Henry, ILBuilt 1967 · S/N 680022 N3643NHoward Trae · San Antonio, TXBuilt 1967 · S/N 680023 N3653NBurch Herbert K · Milan, OHBuilt 1967 · S/N 680025 N3657NEstes Aviation LLC · Vicksburg, MSBuilt 1967 · S/N 680027 N3665NElt Aviation Inc · Peewee Valley, KYBuilt 1967 · S/N 680029 N3672NSonger Dylan · Veedersburg, INBuilt 1967 · S/N 680030 N3674NWitt Larry · Waco, TXBuilt 1967 · S/N 680032 N3691NGalvan Peter R · Slidell, LAS/N 680038 N3694NWheeler Kevin J · Concord, CABuilt 1967 · S/N 680039 N3698NKienitz David A · Buffalo Lake, MNBuilt 1967 · S/N 680041 N3706NJsn Aviation LLC · Huntersville, NCBuilt 1967 · S/N 680044 N3709NShow Me The Mooney LLC · Hartford, KYBuilt 1967 · S/N 680045 N3714NFerguson Michael D · Mendon, MIBuilt 1967 · S/N 680046 N3715NHeiderscheidt Cory L · Sleepy Eye, MNBuilt 1967 · S/N 680047 N3726NVilvens Justin T · Granville, OHBuilt 1968 · S/N 680051 N3759NRuffner Jay P · O Fallon, ILBuilt 1968 · S/N 680055 N3910NStratus Aviation Group LLC · Washington, DCBuilt 1968 · S/N 680058 N3912NChiwaya Brandon · Philadelphia, PABuilt 1968 · S/N 680059 N3914NBradford Michael G · San Jose, CABuilt 1968 · S/N 680060 N3928NVose Richard C · King Of Prussia, PAS/N 680062 N3938NSundance Aviation Inc · Richland, WABuilt 1968 · S/N 680065 N3970NBrown Roland T · Raymond, MSS/N 680071 N4103NKarpik Joseph Paul · Floodwood, MNS/N 680074 N4107NWest Main Auto Sales Inc · Tupelo, MSS/N 680075 N4119NJohnson Cherryl A · Cadillac, MIBuilt 1968 · S/N 680076 N4141KKimminau Jeremy · Sacramento, CABuilt 1967 · S/N 680006 N5005LBlanton Jeffrey D · Valley Center, KSBuilt 1968 · S/N 680048 N500LTSeeth Richard D · Yardville, NJBuilt 1967 · S/N 680007 N514LLLenahan Lawrence M · Scottsdale, AZBuilt 1968 · S/N 680152 N56CPBulldog Aviation LLC · Goodyear, AZBuilt 1969 · S/N 700003 N59PHSeider Jason · Dallas, TXBuilt 1968 · S/N 680116 N6702NRoman Jose Ernesto · Guaynabo, PRBuilt 1968 · S/N 680080

Back to Mooney M-20G