Skip to content

Registered aircraft · 829

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

N9398VJp Sky Colorado LLC · Castle Rock, COBuilt 1969 · S/N 700019 N93GGGosser Chad K · Russell Springs, KYBuilt 1964 · S/N 385 N9401VMedin David T · Marion, IABuilt 1969 · S/N 700020 N9405VShoop Robert A Jr · Austin, TXBuilt 1969 · S/N 700021 N9413VBindl Daniel Leo · Edgewater, FLBuilt 1969 · S/N 700023 N9416VCothren Edward W · Ada, OKS/N 700050 N9418VSmith James · Lawrenceburg, TNS/N 700024 N9421VKohler Robert · Gilroy, CABuilt 1969 · S/N 700025 N9428VMcconnaughhay Ken · Searcy, ARS/N 700027 N943RWBluflyt LLC · Athens, WVBuilt 1966 · S/N 929 N9440VVanhorn Jonathan F · Laguna Hills, CABuilt 1970 · S/N 700030 N9467Allen Lanny Dean · Indianapolis, INBuilt 1970 · S/N 700036 N9469VNorton Curtis S Jr · Beaver Falls, PAS/N 700038 N9473VBarcus Roger L · Saint Paul, MNBuilt 1970 · S/N 700039 N9483VScholls Arnold W · Syosset, NYBuilt 1970 · S/N 700042 N9485VBrown Douglas B · Petaluma, CABuilt 1970 · S/N 700043 N9488VMarlow Michael L · Bandera, TXBuilt 1970 · S/N 700045 N9499VBerliner Donald D · Medford, NJBuilt 1970 · S/N 700048 N9606VNeilson Dakoda S · Franklin, MABuilt 1971 · S/N 21-0012 N9612VLe Roux Rocco · Carlsbad, CABuilt 1971 · S/N 21-0018 N9616VFlorio Michael J Jr Owner · Northampton, MABuilt 1971 · S/N 21-0022 N9670GStinton Jacob M · Palmetto, FLBuilt 1965 · S/N 581 N990DGRichmeier Patrick R · Quinter, KSBuilt 1967 · S/N 670039 N990JDPaoli Sylvia L · La Mirada, CABuilt 1965 · S/N 655 N992GCorbett Joshua J · La Canada, CABuilt 1964 · S/N 473 N997REEuroaviation Inc Trustee · KematenBuilt 1966 · S/N 961 N99EWClegg Kent R · Grace, IDS/N 477 N99PWHarding Willam R Jr · Quinlan, TXBuilt 1968 · S/N 690016 N9GNGudgel Scott A · Ogallala, NEBuilt 1965 · S/N 639

Back to Mooney M20E