Registered aircraft · 120

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

N8858Curtiss Wright TRAVEL AIR 4000 · S/N 949Air Combat Museum N915HKCirrus Design SR22 · S/N 3794Built 2011 · Skybound Advisory LLC N920ELLeonard Charles E JR ZODIAC 601 XL · S/N 6-5528Built 2007 · Smith Kenneth W N9293KPiper PA-32R-301 · S/N 3246093Built 1997 · Yakel Donald L Jr N9325VMooney M20C · S/N 690096Jaa Holdings LLC N934DBeech G35 · S/N D-4670Built 1956 · Zellers Clyde E N9407KPiper PA-28-151 · S/N 28-7615202Built 1976 · Collebrusco Robert L N951MNorth American/Aero Classics P-51D · S/N 44-73287NBuilt 1944 · George Michael J N95258Taylorcraft BC12-D · S/N 9658Built 1946 · Towsley Martin C N9687QCessna 172M · S/N 17265771Bron Chris R N96TClassic WACO YMF · S/N F5C-052George Mike J N971LLRaytheon B300 · S/N FL-267Built 1999 · State Of Illinois N971SPCessna 182S · S/N 18280653Built 1999 · Illinois State Police N9722DPiper PA-22-150 · S/N 22-6634Built 1959 · Lincoln Land Community College N974BDMcconnell H James BD-4 · S/N 16Built 1996 · Schwanke Donald D N981LLRaytheon B300 · S/N FL-265Built 1999 · State Of Il Dot N9848ESchweizer SGU 2-22E · S/N 229Built 1965 · Zellers Clyde E N991LLRaytheon B300 · S/N FL-142Built 1996 · State Of Illinois N991SPCessna 182S · S/N 18280714Illinois State Police N99461Cessna C-165 · S/N 461Built 1956 · George Mike

Back to Springfield, IL