Carencro, 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 = 'CARENCRO' 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 = 'CARENCRO' 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.
N1551FColumbia Aircraft Mfg LC41-550FG · S/N 41721N1571JPiper PA-28-140 · S/N 28-23977N19882Cessna 172M · S/N 17260831N2179UBrantly B-2B · S/N 341N251RFExtra Flugzeugbau EA 300/L · S/N 1239N260PHDavis Charles M KITFOX SERIES 5 · S/N S9702-0208N334RSSheer Bernard BABY ACE D · S/N 1N3835UCessna 336 · S/N 336-0135N390LFBeech F33A · S/N CE-1378N407TVBell Helicopter Textron Canada 407 · S/N 54812N491Cessna A185F · S/N 18503597N555WUUHL William R RV6 · S/N 23897N596RVCondrell Kenneth N RV9A · S/N 90522N6064DPiper PA-22-150 · S/N 22-4717N60963Commander 114-B · S/N 14633N7011DPiper PA-22-150 · S/N 22-4904N716KDDJI INSPIRE 1 · S/N W13DCC17030511N825TRCirrus Design SR22 · S/N 4317N84856Aeronca 7AC · S/N 7AC-3575N85138Aeronca 7BCM · S/N 7AC-3869
Back to Carencro, LA