Poplar Grove, IL
Registered aircraft · 168
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
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 = 'POPLAR 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 = 'POPLAR 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.
N102TJT J Olaughlin OLAUGHLIN PANTHER · S/N 036N1045WBeech 95-B55 (T42A) · S/N TC-1535N110XPBolin Thomas E VANS RV-10 · S/N 40433N11444Waco QCF-2 · S/N 3495N11465Waco QCF · S/N 3537N11480Waco QCF-2 · S/N 3556N114CHDaub Kenn PIONEER 300 JS · S/N 87N12430Waco UBF-2 · S/N 3646N1252WWaco SRE · S/N 5153N1279BLuscombe 8A · S/N 5906N1291Breezy RLU-1 · S/N 1291N12920Dienst Lon C DIENST CHESTER SPECI · S/N 002N129YWaco RNF · S/N 3308N13026Waco UBF-2 · S/N 3615N13179Piper E-2 · S/N 60N132PWAirborne Windsports PTY EDGE XT-912-L · S/N XT-912-0165N13LEPiper J3C-65 · S/N 17571N14JKKillough PITTS SPECIAL S-1S · S/N 7978N16214Waco EQC-6 · S/N 4425N16517Waco YKS-6 · S/N 4508N16935Piper J-2 · S/N 801N17288Warren-Corn CORBEN SUPER ACE FB · S/N 1N1744EAeronca 7AC · S/N 7AC-6125N175CHWilliams W F BABY ACE D · S/N 1N17716Waco YKS-7 · S/N 4623N177FBeech 95-B55 (T42A) · S/N TC-587N17BFFisher Robert H HP-18 · S/N BF-02N17BPBeech 95-B55 (T42A) · S/N TC-1650N18056Monocoupe 90A · S/N A-765N180LLCessna 180K · S/N 18052868N185BLCessna A185F · S/N 18503775N18PMCessna 182S · S/N 18280300N191YXCotton Bryan S WAIEX · S/N W0191N199RJVans RV-7A · S/N 72570N1DPDonald C Perry CURTISS JN-4D · S/N 7685N2003LTaylorcraft F19 · S/N F-151N2084VCessna 140 · S/N 14300N20950Waco EGC-8 · S/N 5068N2115NCessna 140 · S/N 12351N211HRAeronca 15AC · S/N 15AC-255N2131EMooney M20J · S/N 24-3401N214KMNussbaum Marlin D VANS RV-7A · S/N 70849N2158CCessna 195B · S/N 16143N23AMRuffatto Michael J RV-7 · S/N 74167N24740Piper J3L-65 · S/N 3413N247EWaco SRE · S/N 5081N2502GInterplane Spol Sro SKYBOY · S/N 2003-79-912N2648LCessna 172H · S/N 17255848N2806WGrasso Kurt TAYLORCOUPE · S/N 1N2840RBeech P35 · S/N D-7221
Back to Poplar Grove, IL