Crowley, LA
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
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 = 'LA' AND g.registrant_city = 'CROWLEY' 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 = 'LA' AND g.registrant_city = 'CROWLEY' 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.
N1521MDJI AGRAS T50 · S/N 1581F6BUB247S001284RN16206Cessna 150L · S/N 15073544N174DBS N I A S SE 3130 ALOUETTE II · S/N 1593N2772GChampion 7ECA · S/N 460N35RJCessna 150F · S/N 15062932N3790BDJI AGRAS T50 · S/N 63YBM6J00200HVN37LVAmerican Champion 8KCAB · S/N 695-92N4513UBurgin John B DDS EXCALIBUR 2002 · S/N 42902N517ZBDJI AGRAS T40 · S/N 64TBK8H001003EN519QBDJI AGRAS T100 · S/N ASHCN5U00101TDN537BBeech A35 · S/N D-1553N626MBusch Mike LONG-EZ · S/N 960N65528Cessna 172P · S/N 17275775N777SKPiper PA-32R-300 · S/N 32R-7780017N8301KGrumman Acft ENG Cor-Schweizer G-164B · S/N 653BN8942PPiper PA-24-260 · S/N 24-4398N8950HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1588N911ABBalloon Works FIREFLY 8B-15 · S/N F8B-432N944WBCessna 182Q · S/N 18266811N9892RBeech M35 · S/N D-6441
Back to Crowley, LA