Longmont, CO
Registered aircraft · 160
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 = 'LONGMONT' 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 = 'LONGMONT' 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.
N101DAerocar ONE · S/N 3N104WCTimmerman Warren H GN-1 AIRCAMPER · S/N 1893N111GCessna A185F · S/N 18502507N121WWArensmeyer Walter W SA-300 STARDUSTER TO · S/N 001N125FRSocata TB 30 EPSILON · S/N 125N125PMDehavilland DHC-6 TWIN OTTER · S/N 89N1394GSkiles Thomas N KR-2 · S/N TS-01N139SHAero Vodochody L39C · S/N 931519N142WYMacadams Robert E CHALLENGER II · S/N CH2-0796-1505N146ECScottish SERIES 100 MDL 101 · S/N BH100/146N14884Rose-Rhinehart A4-C · S/N 508N149MPMooney M20L · S/N 26-0030N156LMPiper PA-30 · S/N 30-1017N157MHBeech E-90 · S/N LW157N160GWhittman Tailwind W-8 · S/N 25N1681DCessna 170B · S/N 20323N16XVOlson Mark F1 EVO · S/N 168N17936Schweizer SGS 1-26E · S/N 566N184Cessna T337G · S/N P3370206N190RRORR John VANS ACFT RV-6 · S/N 23039N194PTMcneese Robert A VANS RV-8 · S/N 81717N19DCUltramagic S A T-150 · S/N 150/28N19MGGinsberg Matthew L CHRISTEN EAGLE II · S/N AIR FORCE EPSILN1XNBuck SKYOTE · S/N 004N201FWUltramagic T210 · S/N 210/72N201REMooney M20J · S/N 24-0341N2028CHead Balloons AX8-105 · S/N 353N2060BLuscombe 8A · S/N 6487N2101KLuscombe 8E · S/N 4828N2110ABeech 58P · S/N TJ-129N211MYIndus T-211 THORPEDO · S/N 022SN2362HPiper PA-18-150 · S/N 18-7909177N23GFFrancis Ronald E RV6A · S/N 23184N23MGPiper PA-39 · S/N 39-28N2482UPowrachute PEGASUS · S/N A-073PEGN250KWAlexander Schleicher AS 33 ME · S/N 33527N2607YPiper PA-28-161 · S/N 28-8516086N261DBMooney M20K · S/N 25-1083N264HSCirrus Design SR20 · S/N 9385N272KMHansen Paul Arvid GLASTAR · S/N 5003N2751GChampion 7KCAB · S/N 56N275FWUltramagic S A N-250 · S/N 250/111N281TTNorth American T-28A · S/N 49-1580N2829YCessna 182E · S/N 18253829First renewal noticeN286WBeech V35 · S/N D-8042N299HCHoward D Cammack SKYBOLT · S/N 3N3088CBeech K35 · S/N D-5773N3138CCessna R182 · S/N R18200239N313KBBickers Kenneth N PIETENPOL AIR CAMPER · S/N 001N3147CCessna 180 · S/N 30946
Back to Longmont, CO