Burlington, CO
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 = 'CO' AND g.registrant_city = 'BURLINGTON' 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 = 'BURLINGTON' 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.
N100YCPilatus PC-12/45 · S/N 281N104LJFeldhousen Larry A VANS RV 10 · S/N 40109N1150BLuscombe/Ranger Avia 8A · S/N 57778AN122LGBeech A36 · S/N E-2413N127JWAir Tractor AT-802A · S/N 802A-0553N2112GPiper PA-28-161 · S/N 28-7816367N222HHitchcock Duane B LANCAIR 320 · S/N 222N2313NPiper PA-38-112 · S/N 38-79A0781N2685XCessna 182G · S/N 18255311N2936QPiper PA-28-161 · S/N 28-7716126N3083ZAyres S2R-G6 · S/N G6-122N312SVStevenson John G RV 6 · S/N 20624N3155FCessna 182J · S/N 18257255N321VRVashon RANGER R7 · S/N 10173N325VRVashon RANGER R7 · S/N 10176N3337AHilt Fred JR VANS RV7A · S/N 70008N34955Rockwell International S-2R · S/N 1999RN35611Piper PA-28R-201T · S/N 28R-8031032N39580Aeronca 65-CA · S/N CA18492N4472FPiper PA-28-151 · S/N 28-7715034N4512LPiper PA-28-161 · S/N 28-8016016N4585MBeech A36 · S/N E-1239N45974Luscombe 8A · S/N 2501N515JHPiper PA-28-161 · S/N 28-7916021N5642XAero Commander S2R · S/N 1842RN5917PPiper PA-24-250 · S/N 24-1004N5941SBeech V35 · S/N D-8143N59RKStewart J/Schutte A STORCH · S/N 0041N602HBAir Tractor AT-602 · S/N 602-0565N6462CPiper PA-28-161 · S/N 28-7816426N7336ACessna 172 · S/N 29436N7627NPiper PA-18-150 · S/N 18-7379N76995Cessna 140 · S/N 11441N782RBCirrus Design SR22T · S/N 2434N79827Mooney M20E · S/N 491N799HSStewart John H VANS RV6A · S/N 23941N81592Aeronca 7AC · S/N 7AC-211N8191XPiper PA-28-161 · S/N 28-8016224N8756QCessna TU206F · S/N U20603509N93262Cessna T210L · S/N 21060324N97955Stinson 108-1 · S/N 108-955N99506Ercoupe 415-C · S/N 2129
Back to Burlington, CO