Tallulah, LA
Registered aircraft · 17
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 = 'TALLULAH' 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 = 'TALLULAH' 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.
N10404Piper PA-18-135 · S/N 18-3561N1521HCessna 177RG · S/N 177RG0698N2110DLiles W J AVID MK IV STOL · S/N 1028DN24732American Legend AL3 · S/N AL-1115N30HUAviat A-1A · S/N 1406N325BMAir Tractor AT-802A · S/N 802A-0144N459RPWilliam C Pratt SPORT SPITFIRE · S/N MK1US77N6212TCessna R182 · S/N R18201939N65LCAmerican Legend AL3 · S/N AL-1083N6625CNorth American T-6G · S/N 49-3100N7462CNorth American AT-6 · S/N 12163211N8569VBellanca 7GCBC · S/N 795-75N8992GCessna 182N · S/N 18260532N9007XCessna 182D · S/N 18253407N9121PAir Tractor AT-602 · S/N 602-0541N9467QBeech 58 · S/N TH-206N982ASAir Tractor AT-802A · S/N 802A-1081
Back to Tallulah, LA