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 = 'ST CHARLES' 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 = 'ST CHARLES'
  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 = 'ST CHARLES'
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.

N119DDBeech C35 · S/N D-3380Built 1952 · Coleman Russell L N170JECessna 170B · S/N 25501Built 1953 · Barrett John E N171SFDiamond Aircraft Ind DA 40 · S/N 40.494Built 2005 · Stratusfire LLC N181SPCirrus Design SR22T · S/N 9121Built 2023 · Ikway Air LLC N321MLLamos Mark Allan THORPE T-18 · S/N 1042Built 1991 · Salerno Lawrence B N3457VCessna 195 · S/N 7154Built 1948 · Schwab Coyle P N3499VCessna 190 · S/N 7203Built 1948 · Sponsler William D N3618HEngineering & Research 415-D · S/N 4243Built 1946 · Ericson Eric N408PSSebern-Paul SONERAI-2 · S/N 408Built 1979 · Sebern Paul E N415JSCarey James A RV-10 · S/N 40874Built 2016 · Carey James A N4382SPiper PA-32-301 · S/N 32-8506004Bcw Alpine LLC N4406MPiper PA-12 · S/N 12-3358Built 1947 · Smith Matthew E N46470Cessna 172K · S/N 17257291Registration pendingBuilt 1968 N4XPBeech V35B · S/N D-10401Built 1982 · Pazdziora Ronald G N5399HPiper PA-16 · S/N 16-206Built 1949 · Kling Edward V N556CDCirrus Design SR22 · S/N 1033Built 2004 · Sec Ventures LLC N6006UPiper PA-28-140 · S/N 28-26907Faith Peter E N67MKKamrat Mike VANS ACFT RV-6A · S/N 001Built 1994 · Salerno Lawrence B N71313Luscombe 8E · S/N 2740Built 1946 · Albers Edward R N7153GCessna 150L · S/N 15074618Built 1973 · Ericson Eric N718TEBellanca 7GCAA · S/N 334-76Theis Timothy J N731JBPiper PA46-500TP · S/N 4697343Lea Kenneth R Trustee N746ZXCessna T210N · S/N 21064368Slater R Winston Trustee N75817Boeing B75N1 · S/N 75-7548Built 1943 · Schwab Coyle P N7WYDouglass James D HATZ JD-1 · S/N 0005Built 2003 · Kling Edward V N833JDCirrus Design SR22T · S/N 2463Built 2021 · Reading Air LLC N9080BChampion 7FC · S/N 7FC-164Built 1958 · Airline Pilot'S Historical Society N94427Ercoupe G · S/N 5073Ericson Eric N97AJCessna 560XL · S/N 560-5609Built 2005 · Rukel Aviation LLC N980GMCompagnie Daher TBM 700 · S/N 1632Built 2026 · Mcgrath Air LLC N992BZCirrus Design SR20 · S/N 11387Built 2026 · Cirrus Skies LLC

Back to St Charles, IL