Danbury, CT
Registered aircraft · 65
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 = 'CT' AND g.registrant_city = 'DANBURY' 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 = 'CT' AND g.registrant_city = 'DANBURY' 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.
N10RNBell 47G-2 · S/N 2229N11907Cessna 177B · S/N 17702380N121MSCessna 172N · S/N 17271893N12611Fairchild 22 C7A · S/N 1013N12RNBell 47G-4 · S/N 3350N15RNCessna 560 · S/N 560-0520N17MSPiper PA-28RT-201 · S/N 28R-7918152N2083BLuscombe 8A · S/N 6510N210FUDJI PHANTOM 3 STANDARD · S/N P5ADCG240100L0N22533Cessna 150H · S/N 15068343N228TRCirrus Design SR20 · S/N 1511N2363TNavion NAVION G · S/N NAV-4-2363N2521UPiper PA-28-161 · S/N 28-8016029N26LZHarrison Philip Wayne GLASAIR 1 RG · S/N 001N2839GChampion 7KCAB · S/N 65N28591Grumman American Avn. AA-5B · S/N AA5B0696N2999GBeech A36 · S/N E-2348N322WACirrus Design SR22 · S/N 0811N324GPiper PA-32R-301 · S/N 3246003N326VBAviat A-1B · S/N 2229N340CBCostruzioni Aeronautiche Tecna P2008 · S/N 213N3899JGrumman American Avn. AA-5B · S/N AA5B-0124N401BRCirrus Design SR22 · S/N 10683N4240XMaule M-7-260C · S/N 30004CN427AFRobinson Helicopter R44 · S/N 1191N474EPCessna 172R · S/N 17280616N48JBeech 58 · S/N TH-409N508MVPilatus PC-12/47E · S/N 2317N525EZCessna 525C · S/N 525C0096N531ABBeech 58P · S/N TJ-454N5490JCessna 310R · S/N 310R0288N5546JCessna 172N · S/N 17273816Registration pendingN5JMTextron 525C · S/N 525C0394N605JMBombardier CL-600-2B16(CL-604) · S/N 5935N6377BCessna 152 · S/N 15283926N6475DCessna 172N · S/N 17272823N6486LCessna 152 · S/N 15284414N65563Cessna 152 · S/N 15281621N6702ECessna 175 · S/N 56202Registration pendingN6988TCessna 310D · S/N 39288N70293Piper J3C-65 · S/N 17334N70336Piper J3C-65 · S/N 17317N70868Piper J3C-65 · S/N 17884N725JACessna 560 · S/N 560-0205N727TEGulfstream Aerospace GV-SP (G550) · S/N 5223N737RQCessna 172N · S/N 17269619N757YMCessna 152 · S/N 15280110N76624Cessna 140 · S/N 11064N79195Cessna 172K · S/N 17257949N810ETDassault FALCON 2000EX · S/N 190
Back to Danbury, CT