Skip to content

Registered aircraft · 58

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

N1046BOglesby Jonathan D · Okmulgee, OKBuilt 1958 · S/N 1273 N1063BFlat Earth LLC · Kalispell, MTBuilt 1958 · S/N 1290 N1066CGullett Steve L · Bethel, OHBuilt 1958 · S/N 1337 N1073BPickering Michael A · Walpole, NHS/N 1300 N1077CMckinney Jonathan C · Oviedo, FLS/N 1348 N1089BDakota Territory Air Museum Inc · Minot, NDBuilt 1958 · S/N 1315 N1091CReif James D · East Lansing, MIBuilt 1959 · S/N 1362 N1095BReinschmidt John S · Austin, TXBuilt 1958 · S/N 1321 N1099CBrooks Jerald W · Anderson, CABuilt 1959 · S/N 1370 N1960Jackson Chester L · Sherman, TXBuilt 1960 · S/N 1620 N27STStefenelli Aviation N-Tr Inc Trustee · AtterseeBuilt 1958 · S/N 1201 N3205JSchumacher Eraine · Hague, NDBuilt 1958 · S/N 1238 N406TWT C Willis LLC · Three Forks, MTS/N 1217 N454WCNielsen Kai V · Arlington, WABuilt 1959 · S/N 1397 N5787DWyoming Development LLC · Cheyenne, WYBuilt 1960 · S/N 1623 N59PPJohnson Monte W · La Porte, INBuilt 1960 · S/N 1646 N6003XB&E Leasing LLC · Dubuque, IAS/N 1591 N6016XBeland Michael R · Maiden, NCS/N 1650 N6023XSytsma Douglas A · Canton, MIBuilt 1960 · S/N 1611 N6028XHarnagel Duard R · Scottsdale, AZBuilt 1960 · S/N 1618 N6036XGomez Douglas Augusto · Greenville, NCBuilt 1960 · S/N 1627 N6043XMwm Interests Inc · The Woodlands, TXS/N 1634 N6044XAddessi Frank · Independence, ORBuilt 1960 · S/N 1635 N6046XHays Carl W · Kingman, AZBuilt 1960 · S/N 1637 N6047XGilman John W · Yakima, WABuilt 1960 · S/N 1638 N6085XLight Richard S · Wichita, KSBuilt 1960 · S/N 1681 N6090XAstle James H · Saint John, KSBuilt 1960 · S/N 1688 N6096XBergman James H · Buckley, WAS/N 1694 N6099XStar Larry D · Gold Hill, NCBuilt 1960 · S/N 1700A N6534BMurphy Timothy · Lake City, FLS/N 1203 N6556BLewis Joseph M · Huntington Beach, CABuilt 1958 · S/N 1226 N6562BPrairie Aero LLC · Elgin, ILBuilt 1958 · S/N 1232 N6563BFurmanski Stan · Encino, CABuilt 1958 · S/N 1233 N6571BWooden Wings LLC · Cheyenne, WYS/N 1241 N6589BElliott Jason R · Brawley, CABuilt 1958 · S/N 1259 N8107EPrice John DBA · Bennington, KSS/N 1471 N8114EGonser Albert L · White Hills, AZBuilt 1959 · S/N 1385 N8119EMorse Daniel D · Edinburg, TXBuilt 1959 · S/N 1390 N8127EFugate Ruth · Riverside, CARegistration revokedBuilt 1959 · S/N 1398 N8139EElliott Carl J · Fort Worth, TXRegistration revokedBuilt 1959 · S/N 1410 N8142EAbourezk Michael C · Rapid City, SDS/N 1413 N8155EOneill Jon · Argyle, TXBuilt 1959 · S/N 1426 N8162EMcmahan Steven C · Clay Center, KSBuilt 1959 · S/N 1433 N8169EDavis Kerry N · Las Vegas, NVBuilt 1959 · S/N 1440 N8175EHigh Planes Aviation LLC · Goodland, KSBuilt 1959 · S/N 1446 N8308EBo Rafter Tx LLC · Gail, TXBuilt 1960 · S/N 1580 N8322EHorton Ernest J III · Galveston, TXBuilt 1959 · S/N 1500 N8325EAnzaldi Carl J · Cherry Valley, CABuilt 1959 · S/N 1503 N8335EMillheim Roger L · Frankston, TXBuilt 1959 · S/N 1513 N8337EC & S Aerial Photography LLC · Ponca, NEBuilt 1959 · S/N 1515

Back to Mooney M20A