Alliance, NE
Registered aircraft · 42
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 = 'NE' AND g.registrant_city = 'ALLIANCE' 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 = 'NE' AND g.registrant_city = 'ALLIANCE' 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.
N112SALet BLANIK L-13 · S/N 026954N137DCAviat A-1C-180 · S/N 3278N1771PPiper PA-22-150 · S/N 22-2543N202WFPiper PA-28R-201T · S/N 28R7803325N2759PPiper PA-22-150 · S/N 22-3067N29374Piper PA-28-236 · S/N 28-7911178N29750Taylorcraft BC · S/N 2597N32984Ayres S2R-G10 · S/N G10-116N372FCCessna T310Q · S/N 310Q0215N44409Taylorcraft BC12-D · S/N 10209N4440ZPiper PA-18-150 · S/N 18-8784N5017CBeech B35 · S/N D-2279N51080Thrush S2R-T660 · S/N T660-158DCN5158XChampion 7GCBC · S/N 163N5289JPiper PA-22-135 · S/N 22-654N5391YPiper PA-23-250 · S/N 27-2467N54750Piper PA-18-150 · S/N 18-7609053N549LGThrush S2R-T660 · S/N T660-169DCN5555VEaa Biplane MODIFIED · S/N 1N60510Cessna 150J · S/N 15070362N606JWBeech C-45H · S/N AF-895N60VACessna A185F · S/N 18503141N612JLPiper PA-18-150 · S/N 18-7409151N68095Piper J3C-65 · S/N 16979N6860KGrumman Acft ENG Cor-Schweizer G-164B · S/N 505BN7249DPiper PA-22-150 · S/N 22-5075N73068Cessna 172M · S/N 17267259N73496Cessna 172M · S/N 17267506N7395WPiper PA-28-180 · S/N 28-1283N756EYCessna TU206G · S/N U20604043N756ZHCessna TU206G · S/N U20604483N7848DPiper PA-22-150 · S/N 22-5498N8211WPiper PA-28-180 · S/N 28-2344N837DPDJI AGRAS T100 · S/N 1581F8ZLC25AA0022BMGN8701HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1478N9245EAeronca 11AC · S/N 11AC-879N942PHeisdorffer Roger RV9A · S/N 90651Registration pendingN9603DPiper PA-22-160 · S/N 22-6512N9629LGrumman American Avn. AA-1B · S/N AA1B-0129N9631CPiper PA-28-181 · S/N 28-7890431N9757RBeech M35 · S/N D-6286N9938PPiper PA-36-285 · S/N 36-7560050
Back to Alliance, NE