Brighton, CO
Registered aircraft · 117
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 = 'CO' AND g.registrant_city = 'BRIGHTON' 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 = 'CO' AND g.registrant_city = 'BRIGHTON' 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.
N100TBBeech 35-B33 · S/N CD-637N1026PDJI AGRAS T40 · S/N 64TBL1S002002SN103PZMaule M-7-235C · S/N 25102CN109AAAviat A-1B · S/N 2427N118EVCirrus Design SR22T · S/N 1272N1208QLawson Jerome Lon RANS S-7 · S/N 195145N122WPiper J4A · S/N 4-846N1232FCessna A185F · S/N 18502794N134MEGordon James Alva VANS RV-3A · S/N 10931N14309Piper PA-18-150 · S/N 18-7409073N1437GBeech P35 · S/N D-6910N153JWWinders Jimmie L TITAN MUSTANG T-51 · S/N M09HV6COHK0153N1587RCameron Balloons US A-105 · S/N 6569N1604VCessna 140 · S/N 13776N1823WBeech 95-B55 (T42A) · S/N TC-1509N1945MCessna 182P · S/N 18264496N2018CBeech M35 · S/N D-6498N226ALTracy Ross SPORTSMAN 2+2 · S/N 7407N233WBenell Ronald E RV 7A · S/N 71973N235PSSteven M Harless VANS RV-8 · S/N 83459N2385BTemco GC-1B · S/N 3685N239LLAmerican Champion 8GCBC · S/N 618-2021N2437BTemco GC-1B · S/N 3739N248DAPiper PA46-500TP · S/N 4697156N2509UCessna 172D · S/N 17250109N2511TSchempp Hirth NIMBUS II · S/N 3N2524TNavion NAVION H · S/N NAV-4-2525N25641Douglas DC3C-S4C4G · S/N 9059N2690KLuscombe 8E · S/N 5417N2742DCessna 170B · S/N 25284N30507Piper J3C-65 · S/N 4885N3087CMaule MX-7-180A · S/N 20031CN3127ECessna 180 · S/N 30087N3180GMaule M-7-235C · S/N 25002CN31FCessna 140 · S/N 8508N31WBGoldman Norman C RV-6 · S/N 22470N3407XMooney M20E · S/N 1110N34MLBeech A45 · S/N G-719N35075Piper J3L-65 · S/N 6085N3601CCessna 180 · S/N 31099N360JVHeath Lowry CAVALON · S/N V00271N3696Mohr STARDUSTER TOO · S/N LM-2N36SCJewett Brandon SC-360 · S/N 001N37401Interstate S-1A · S/N 244N37674Whitesell Michael Lee RV-3 · S/N 516N388DMWerner David & Marlene GLASAIR RG · S/N 561N394ALBeech B90 · S/N LJ394N42RMSzybowcowy Zaklad Doswiadczaln 41A JANTAR STANDARD · S/N B-720N434DBeech T-34B · S/N 140819N4396UCessna 150D · S/N 15060396
Back to Brighton, CO