Skip to content

Registered aircraft · 31

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 = 'CARBONDALE' 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 = 'CARBONDALE'
  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 = 'CARBONDALE'
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.

N142RNBeech 35 · S/N D-1353Built 1948 · Nelson Robert J N18748Beech 58 · S/N TH-875Board Of Trustees Of Southern Illinois Univ N199PWTextron T206H · S/N T20609506Built 2017 · J & C Express Inc N297BTextron 172S · S/N 172S12962Built 2023 · Board Of Trustees Of Southern Illinois University N298MAAmerican Champion 8KCAB · S/N 961-2004Built 2004 · Southern Air Service Inc N306HTextron 172S · S/N 172S12968Built 2023 · Board Of Trustees Of Southern Illinois University N3099GBalloon Works FIREFLY 7-15 · S/N F71003Built 1996 · Glaeser Lilyan C N33083Piper PA-28-180 · S/N 28-7505120Built 1975 · Barnhill Chris N331PAPiper PA-28-181 · S/N 2843514Built 2002 · Hale Enterprises Inc N368VRVashon RANGER R7 · S/N 10223Board Of Trustees Of Southern Illinois University N36ABeech J35 · S/N D-5451Built 1958 · Oral & Maxillofacial Surgery Of Carbondale Inc N3702JCessna 150G · S/N 15065002Built 1966 · Maslovsky Serhiy A N39BHHubenthal William L FLYING K SKY RADR II · S/N 39Hubenthal William L N427CCCessna 421C · S/N 421C0348Built 1977 · Board Of Trustees Of Southern Illinois University N478KTextron 172S · S/N 172S12966Built 2023 · Board Of Trustees Of Southern Illinois University N495PPHartline John Bon KITFOX IV SPEEDSTER · S/N KBS 047Morris Donald N5071HCessna 172M · S/N 17265329Fosse David K N524KWWarr Gregory D RV-4 · S/N 1456Morris Donald R N5859NRockwell International 114 · S/N 14404Pegasus Flight LLC N58TEBeech 58P · S/N TJ-326Built 1980 · Gtk Services LLC N682PTextron 172S · S/N 172S12963Built 2023 · Board Of Trustees Of Southern Illinois University N724CTCessna 172E · S/N 17251105Built 1963 · Warner David A N729ETextron 172S · S/N 172S12965Built 2023 · Board Of Trustees Of Southern Illinois Universtiy N7617JPiper PA-28R-180 · S/N 28R-31010Built 1968 · Milner Quinn D N817MHawker Beechcraft G58 · S/N TH-2361Built 2013 · Jr Mcbride Inc N833RTCessna P210N · S/N P21000809Built 1982 · Nash LLC N8383TPiper PA-28-161 · S/N 28-8116223Built 1981 · Loyd Dayton A N849KTextron 172S · S/N 172S12960Built 2023 · Board Of Trustees Of Southern Illinois University N8574JCessna 150G · S/N 15066474Built 1967 · Hubenthal William L N9491JPiper PA-28-180 · S/N 28-3609Built 1966 · Roy Thomas M Jr N959YTextron 172S · S/N 172S12959Built 2023 · Board Of Trustees Of Southern Illinois University

Back to Carbondale, IL