Registered aircraft · 21

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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 = 'SPRING GROVE' 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 = 'SPRING GROVE'
  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 = 'SPRING GROVE'
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.

N10NCessna 195A · S/N 7657Built 1951 · Spring Grove Aviation LLC N149LTPiaggio P-149D · S/N 321Neil Squared LLC N1559NPiper J3C-65 · S/N 23091Johnston Samuel P N17061Beech C17B · S/N 112Built 1936 · Beech Fun Aviation LLC N2203LBeech F33A · S/N CE-669Built 1976 · Forni Robert N2233SCessna 210L · S/N 21061178Built 1976 · Richardson Robert O N3113GBeech F33A · S/N CE-1252Built 1988 · Christiansen Thad Charles N3170TNorth American SNJ-5 · S/N 84832Anderson Neil J N4273SPiper PA-18 · S/N 18-7118Cook Raymond L N4342ZPiper PA-18-150 · S/N 18-8660Built 1968 · Cook Raymond L N43645Taylorcraft BC12-D · S/N 7304Cook Raymond L N59TMLockheed T-33 · S/N 131770Spring Grove Aviation LLC N6204JPiper PA-28-151 · S/N 28-7615331Built 1976 · Fotos Kenneth J N70971Piper J3C-65 · S/N 18001Cook Raymond L N7359HPiper J3C-65 · S/N 20621Built 1946 · Anderson Neil N766DWaco Classic YMF-F5C · S/N F5C103Built 2003 · Round 7 Aviation LLC N880TBLancair LEGACY FG · S/N LS-225Built 2008 · Nippa Paul W N9115ANoorduyn HARVARD II · S/N 07-203Anderson Neil J N9340BCessna 175 · S/N 55140Built 1958 · Cook Raymond L N9796ZNorth American/Victoria MNT LT AT-6A · S/N AJ-935Antique Aircraft Aviation LLC N996EPPiper PA 46-350P · S/N 4636658Built 2015 · Lehecka Richard T

Back to Spring Grove, IL