Alexandria, LA
Registered aircraft · 46
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 = 'ALEXANDRIA' 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 = 'ALEXANDRIA' 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.
N11BEEbbinga William R VANS RV-9A · S/N 91487N17668Beech A36 · S/N E-1001N212KCCarpenter Kenneth B WOODY PUSHER 284 · S/N KC210N2240JCessna 150G · S/N 15065440N2660RCessna 182K · S/N 18258360N28848Grumman American Avn. AA-5B · S/N AA5B0852N363MMPiper PA 46-350P · S/N 4622007N3650RPiper PA-28-180 · S/N 28-5747N366CBBrewer Donald R BREWER SKYBOLT · S/N 001N4294PPiper PA-32R-301T · S/N 32R-8329015N45REEsterak David R Q-200 · S/N 2603N46092Cessna 172I · S/N 17257038N4876HPiper PA-17 · S/N 17-175N497MAPiper PA 46-350P · S/N 4636498N5011XCessna 185 · S/N 185-0033N5247FPiper PA-32-300 · S/N 32-7740002N527PNRaytheon 390 · S/N RB-177N545WBSocata TBM 700 · S/N 107N596ACCirrus Design SR22 · S/N 4245N60WEEdwards SPEZIO SPORT · S/N 352N615Elliott Ronald H GN-1 AIR CAMPER · S/N 2867N6308RCessna 172RG · S/N 172RG0159N661CGRobinson Helicopter R66 · S/N 0057N7087FCessna 150F · S/N 15063687N718BVWaidner Andrew W VAN'S RV-9A · S/N 90782N7508XCessna 172B · S/N 17248008N752FAUnmanned Aerial Solutions M6 SERAPH · S/N 1512101N7571BChampion 7FC · S/N 7FC-76N770DCSocata TBM 700 · S/N 183N772AAAir Tractor AT-502B · S/N 502B-0691N77838Luscombe 8A · S/N 3565N810NHBeech A36 · S/N E-2819N81675Aeronca 7AC · S/N 7AC-294N81837Piper PA-34-220T · S/N 34-8233136N82546Aeronca 7AC · S/N 7AC-1183N82602Champion AERONCA 7AC · S/N 7AC-1239N83632Aeronca 7AC · S/N 7AC-2310N8496UCessna 172F · S/N 17252396N86JFFriling John VOLMER SPORTSMAN · S/N CB-5N8727NPiper PA-28-140 · S/N 28-25540N876LGGibson John / Williams Gerald RANS S-12XL · S/N 0403969N910WZSocata TBM 700 · S/N 1210N915BBAmerican Legend AL11 · S/N AL-1090N91710Mooney M20S · S/N 30-0013N92TDVeillon Joseph B BREEZY · S/N 001JBVN9522TChampion 7ECA · S/N 555
Back to Alexandria, LA