Registered aircraft · 19

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 = 'IL' AND g.registrant_city = 'O FALLON' 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 = 'IL' AND g.registrant_city = 'O FALLON'
  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 = 'IL' AND g.registrant_city = 'O FALLON'
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.

N124VUAmerican General Acft AG5B · S/N 10060Built 1991 · Ryan Jeffrey R N1627YCessna 172C · S/N 17249327Built 1962 · Johnson Douglas J N208MENord 1101 · S/N 83Built 1945 · Sullivan Leo W N234BLMooney M20M · S/N 27-0234Built 1997 · Sullivan Leo W N33KVPiper PA-28RT-201 · S/N 28R-7918185Built 1979 · Wild Blue Aero LLC N356DPPiper PA-32RT-300 · S/N 32R-7885158Built 1978 · Mid America Aircraft LLC N365SBBeechcraft G36 · S/N E-4010Built 2013 · Clear Skys LLC N3759NMooney M-20G · S/N 680055Built 1968 · Ruffner Jay P N5293KCessna 172P · S/N 17274049Brooks Jimmy N5443VCessna 172RG · S/N 172RG0533Built 1980 · Turk Aviation LLC N59GGFlight Design CTLS · S/N F-13-01-07Johnson Douglas J N6050WPiper PA-28-140 · S/N 28-20050Landoll Aero LLC N664HWBeech V35B · S/N D-10260Built 1979 · Williamson Kemal N721WDDelacey William H RV9A · S/N 91640Built 2014 · Sill Aviation LLC N735NKCessna 182Q · S/N 18265553White Jeff N75483Nanchang China CJ-6A · S/N 3632013Carmichael Ryan J N82PSHoffman-Flugzeugbau H 36 DIMONA · S/N 36152Built 1985 · Sullivan Leo N8926PPiper PA-24-260 · S/N 24-4382Gallagher Derek P N96033Christen Industries A-1 · S/N 1127Built 1990 · Sullivan Leo W

Back to O Fallon, IL