Skip to content

Registered aircraft · 23

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

N101CRush David T · Durham, NCBuilt 1949 · S/N 62 N118CWilke Brian S · Arlington Heights, ILBuilt 1950 · S/N 79 N119CAn Yongmin · Phoenix, AZBuilt 1949 · S/N 51 N120CVasquez Bernie W · Esparto, CAS/N 81 N123CKing Stephen W · Kerrville, TXBuilt 1950 · S/N 82 N246MMHildreth Shawn M · Osceola, IABuilt 1949 · S/N 59 N3162KDouthit Norman L · San Bernardino, CABuilt 1948 · S/N 6 N3165KHackenburg Jess P · Montoursville, PAS/N 9 N353ALee Jonathan C E · Bossier City, LABuilt 1949 · S/N 14 N361ADouthit Norman L · San Bernardino, CABuilt 1949 · S/N 22 N363ADoutnit Norman L · San Bernardino, CABuilt 1949 · S/N 24 N366ARamin Reuben F · Tomball, TXBuilt 1949 · S/N 27 N369AStrange Jim · Tyler, TXBuilt 1949 · S/N 30 N371ABeltz Richard D · Lehighton, PABuilt 1949 · S/N 32 N378ASpicer Michael W · Phillipsburg, KSS/N 39 N379AWingnut Inc · Wilmington, DEBuilt 1949 · S/N 40 N382ADga Aviation LLC · Sacramento, CABuilt 1949 · S/N 43 N383AKlenoski Brian D · Fulton, MIS/N 44 N384APlyler Aviation Lp · Sherman, TXBuilt 1949 · S/N 45 N386AOrtet Craig · Etna, WYBuilt 1949 · S/N 47 N391ATwibell David Jerome · Ceresco, NES/N 52 N393ACollins Elizabeth M · Carnelian Bay, CABuilt 1949 · S/N 54 N612CBelton Mark S · Eugene, ORBuilt 1948 · S/N 5

Back to Mooney M-18L