Skip to content

Registered aircraft · 34

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'MO' AND g.registrant_city = 'PECULIAR' ORDER BY g.n_number

duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'MO' AND g.registrant_city = 'PECULIAR'
  ORDER BY g.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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'MO' AND g.registrant_city = 'PECULIAR'
ORDER BY g.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.

N1054ALeonard Robert D LHP-18 · S/N 089Built 1979 · Leonard Ronald A N1055WGlasflugel STANDARD LIBELLE · S/N 229Built 1971 · Midwestern Soaring Association N10CRCessna TR182 · S/N R18201808Built 1981 · Carlile Aviation LLC N15044Piper PA-28-140 · S/N 28-7225564Built 1972 · Summit Flight Academy LLC N15283Piper PA-28-140 · S/N 28-7325032Summit Flight Academy LLC N1582Schempp-Hirth SHK1 · S/N 24Built 1966 · Leonard Ronald A N196PLSchleicher KA 6 CR · S/N 6282Built 1964 · Midwestern Soaring Assoc N237ZMDJI AGRAS T40 · S/N 64TBL5H00200J3Menzel Michael A Jr N2557LCessna 172H · S/N 17255757Built 1967 · Sparks Ryan J N2747ZSchweizer SGU 2-22E · S/N 195Built 1964 · Midwestern Soaring Association N32514Piper PA-28-140 · S/N 28-7525075Summit Flight Academy LLC N332JNMooney M20J · S/N 24-1517Menzel Michael Alexander Jr N3406MDJI AGRAS T50 · S/N 63YBM5T0020097Menzel Michael A Jr N3494APiper PA-23-250 · S/N 27-2197Built 1962 · Wheeler Michael R N3577HHuffman Ray CH 601 HD ZODIAC · S/N 63166Built 2005 · Ginter Brian Scott N3827ASchweizer SGS 1-26C · S/N 89Built 1959 · Midwestern Soaring Association N38631Piper J3C-65 · S/N 7172Built 1941 · Galegor Samuel T Jr N425CBPiper PA-28-151 · S/N 28-7415210Built 1974 · Summit Flight Academy LLC N4353LPiper PA-28-181 · S/N 28-8490062Built 1984 · Summit Flight Academy LLC N4604HPiper PA-15 · S/N 15-358Galegor Samuel T Jr N4867QEiriavion PIK 20E · S/N 20245Built 1980 · Leonard Ronald A N57195Mooney M20K · S/N 25-0791Built 1983 · Self Levi N6227RCessna 150E · S/N 15061527Built 1965 · Midwestern Soaring Assoc N633FBeech B50 · S/N CH-70Built 1954 · Summit Aviation Holdings LLC N6894WPiper PA-28-140 · S/N 28-21053Built 1965 · Summit Flight Academy LLC N70326Cessna A188B · S/N 18801887TBuilt 1974 · Triple E Farms LLC N7332JPiper PA-28-140 · S/N 28-24686Registration pendingBuilt 1968 N7664YPiper PA-30 · S/N 30-742Built 1965 · Summit Flight Academy LLC N7820CPiper PA-28-181 · S/N 28-7690083Built 1975 · Summit Flight Academy LLC N7958CSchempp-Hirth DISCUS B · S/N 251Leonard Ronald A N8332WPiper PA-28-180 · S/N 28-2512Built 1965 · Surls Aviation Inc N8750NPiper PA-28-140 · S/N 28-25570Built 1969 · Midwest Avionics LLC N906DFAmerican Legend AL11 · S/N AL-1066Poe Joshua J N9830TCessna 172A · S/N 47630Built 1960 · Poe Joshua J

Back to Peculiar, MO