Registered aircraft · 20

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

N10443Hoff-Corben Baby Ace C · S/N 1Stern Jason C N12306Dart CW-3 · S/N 1Stern Jason C N1265CCirrus Design SR20 · S/N 1291Built 2003 · Dbg Aviation N172FMCessna 172K · S/N 17258008Built 1969 · Stern Jason C N1903PBrooks Kenyon D VANS RV-8 · S/N 80411Built 2015 · Brooks Kenyon D N190VTCessna 190 · S/N 7171Built 1948 · Marshall Rodney E N2037VCessna 120 · S/N 14250Built 1947 · Marshall Rodney E N2194YPiper PA-28RT-201T · S/N 28R-7931149Built 1979 · David Shawn M N2638LCessna 172H · S/N 17255838Built 1967 · Morgan Todd W N3032XCessna 150F · S/N 15064432Built 1966 · Magaruh George M N3825Robert L Oconnor CORBEN BABY ACE C · S/N 1001Built 1972 · Mazeika Mckenzie N5011MTaylorcraft BC12-D · S/N 10-311Jones Michael S N5035BBeech F35 · S/N D-4312Bohdan Lebid N507SDaniel L Syverson CH 750 CRUZER · S/N C75-11271Built 2022 · Syverson Daniel L N6225TCessna 150E · S/N 15060925Built 1964 · Mohnacky Robert A N6486CPiper PA-32RT-300 · S/N 32R-7885029Built 1978 · 86 Charlie Corp N65387Cameron Balloons US Z-77 · S/N 6707Built 2013 · Nelson Sarah N7091RHarold F L/Fink J W RV-8 · S/N 80784Built 2003 · Fink Jeffrey W N82TLCessna 182P · S/N 18263775Registration pending, pending cancellation N92166Piper J3C-65 · S/N 16608Built 1946 · Gerdeman Richard F III

Back to Roscoe, IL