Registered aircraft · 17

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 = 'MOUNT PROSPECT' 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 = 'MOUNT PROSPECT'
  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 = 'MOUNT PROSPECT'
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.

N1190VAmerican General Acft AG5B · S/N 10008Built 1990 · Triple Jerks Inc N126THAS+ AC 4 · S/N 014Park Forest South Aviation Group N2026XCessna 182H · S/N 18256126Built 1965 · Gonzales Alvin S N20771Cessna 182P · S/N 18261190Built 1972 · Cussen George J N21KTCirrus Design SR22 · S/N 10245Built 2024 · Tatkowski Dorota N22759Cessna 150H · S/N 15068501Built 1968 · Park Forest South Aviation Group N2793ZSchweizer SGS 1-26C · S/N 286Park Forest South Aviation Group N4308LCessna 172G · S/N 17254377Built 1966 · Kim Jingu N448RSPzl-Swidnik PW-5 · S/N 1705018Built 1996 · White Wings Soaring Inc N60ASSzybowcowy Zaklad Doswiadczaln 41A JANTAR STANDARD · S/N B-878Built 1978 · White Wings Soaring Inc N611NLDJI MAVIC 2 ZOOM · S/N 0M6DF750018LD7Lorusso Michael R N6431Pitts Special S-1C · S/N 6431Built 1971 · Cussen George J N737TECessna 172N · S/N 17269656Built 1977 · John P Kintzle LLC N800UADJI MATRICE 600 · S/N M64DDG04010007Summers Nic E N84289Cessna 172K · S/N 17258410Angelov Ruslan P N8713KStinson 108-1 · S/N 108-1713Ewing Laurence W N9831GCessna 172N · S/N 17273637Built 1979 · Starr David

Back to Mount Prospect, IL