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.

N3534NCoffey Joseph · Camarillo, CABuilt 1967 · S/N 680087 N3535XZulu Aviation Corp · Fort Worth, TXBuilt 1966 · S/N 670072 N3536NWestern Fires Inc · Yoncalla, ORBuilt 1967 · S/N 680088 N3536XGreen William Robert Jr · Waller, TXBuilt 1966 · S/N 670073 N3537NCreaney William Gerald · Franklin, TNS/N 680089 N3537XMurphy James Stuart · Rock Hill, SCS/N 670074 N3538NBillquist H Lee · Helena, MTBuilt 1967 · S/N 680090 N3538XSkye Air LLC · Cypress, TXBuilt 1966 · S/N 670075 N3546NGleason John R · Yorktown, VAS/N 680092 N3554NPatterson Ted · Skiatook, OKBuilt 1967 · S/N 680094 N3555NLarimore Jacob William · Ypsilanti, MIBuilt 1967 · S/N 680095 N3563NHill Michael T · Cedarpines Park, CABuilt 1968 · S/N 680097 N3569NPhp Air LLC · Oscoda, MIBuilt 1967 · S/N 680100 N3571NCoker Steve L · Tyler, TXBuilt 1967 · S/N 680101 N3575NPierson Oran · Tucson, AZBuilt 1967 · S/N 680102 N3579NPorter Gary · Oregonia, OHBuilt 1967 · S/N 680104 N3591NPeperuka LLC · Olympia, WABuilt 1967 · S/N 680108 N35LABohachevsky John V · Bloomfield, KYBuilt 1966 · S/N 670184 N3762NHuckleberry Raymond · Greenville, MIBuilt 1967 · S/N 680109 N3770NCustodio David I · Bay Point, CABuilt 1967 · S/N 680113 N3779NObrien Edward Trustee · Walnut Creek, CAS/N 680116 N3784NMorcott Ian · Mountain Home, IDBuilt 1967 · S/N 680118 N3794NLc Aviation LLC · Hartland, WIS/N 680120 N3799NCarlson John W · Wichita, KSBuilt 1967 · S/N 680122 N3805NHopkins Michael P · Granbury, TXBuilt 1968 · S/N 680124 N3840NDmitrich Michael A · Pleasant Grove, UTBuilt 1968 · S/N 680127 N3844NKlauschie David A · Papillion, NEBuilt 1967 · S/N 680128 N3859NWilson Bryan J · Henderson, NCBuilt 1968 · S/N 680134 N385AWoodin David G · Margate, FLBuilt 1967 · S/N 670484 N3861NZekic Zivojin · Austin, TXBuilt 1968 · S/N 680136 N3873NGill Warren K · Colorado City, TXBuilt 1968 · S/N 680139 N3892NNeed For Speed Inc · Dover, DEBuilt 1968 · S/N 680145 N3901NMgg Airplane LLC · Lewes, DES/N 680148 N3977NKelley Daniel P · Newton, ALBuilt 1968 · S/N 680151 N3985NRobinett Christopher T · Oklahoma City, OKBuilt 1968 · S/N 680152 N3987NCascadia Software Inc · Puyallup, WABuilt 1968 · S/N 680153 N3989NOlson Michael J · Grand Island, NYBuilt 1968 · S/N 680154 N3994NJohnson Gregory H · Thousand Oaks, CABuilt 1968 · S/N 680156 N3997NStevens James A · Acworth, GABuilt 1968 · S/N 680157 N3BVWunder Arnold J · Collegeville, PABuilt 1975 · S/N 22-1237 N4015NHazel Consulting LLC · Dayton, NVBuilt 1968 · S/N 680159 N4027NC2c LLC · Chesterfield, MOBuilt 1968 · S/N 680161 N4035NTodd Steven G · Binghamton, NYBuilt 1968 · S/N 680162 N4044NLundquist Matthew Michael · Navarre, FLBuilt 1968 · S/N 680164 N4049NCulley Richard A · Scottsdale, AZBuilt 1968 · S/N 680166 N4058NHancock Randall G · Evanston, WYBuilt 1968 · S/N 680168 N4069NGrady Kevin M · Spokane, WABuilt 1968 · S/N 680171 N4076NStewart Jason S · Hornell, NYBuilt 1968 · S/N 680172 N4099NS O Witt And Associates LLC · Ridgecrest, CAS/N 680174 N418TASale Reported · Lancaster, TXSale reported, pending cancellationS/N 680105

Back to Mooney M20F