Latham, NY
Registered aircraft · 32
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 = 'NY' AND g.registrant_city = 'LATHAM' 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 = 'NY' AND g.registrant_city = 'LATHAM' 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.
N123EEGlaser Dirks DG 300 · S/N 3E-54N13SPCessna 172H · S/N 17256431N19WRFairchild M-62A · S/N 9504AEN200NYBeech C-12C · S/N BC-25N319APNorth American AT-6D · S/N 8815598N34453Cessna 177B · S/N 17701814N35SDCirrus Design SR20 · S/N 9937N388LGPilatus PC-12/47E · S/N 2388N3940MPiper PA-28-161 · S/N 28-7816388N4200BPiper PA-28-181 · S/N 2843319N430SPAirbus Helicopters MBB-BK117 D-3 · S/N 21314N444WERaytheon A36 · S/N E-3579N518VACirrus Design SR22 · S/N 11169N518VVCirrus Design SR20 · S/N 11174N60DJCanadian Car & Foundry HARVARD MK IV · S/N CCF-4-264N651SPCessna U206G · S/N U20606996N65620Cessna 172P · S/N 17275787N67HPGoodyear FG1D · S/N 92095N749SPCessna U206G · S/N U20606957N756VHCessna R182 · S/N R18201165N761NYSikorsky S-76D · S/N 761021N7922CCessna 182Q · S/N 18266633N7946CNorth American B-25N · S/N 44-28938N854GWCessna 172S · S/N 172S8854N948SPKodiak KODIAK 100 · S/N 100-0360N9570ACessna 182S · S/N 18280286N9584ZGrumman TBM-3E · S/N 85882N9594CPiper PA-28R-201 · S/N 28R-7837209N959SPKodiak KODIAK 100 · S/N 100-0359N961DAPiper PA-28-181 · S/N 2843034N988SPKodiak KODIAK 100 · S/N 100-0362N9SPAirbus Helicopters MBB-BK117 D-3 · S/N 21301
Back to Latham, NY