Oxford, CT
Registered aircraft · 67
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 = 'OXFORD' 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 = 'OXFORD' 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.
N106TWPilatus PC-12/47E · S/N 1109N112CSGulfstream Aerospace GVI (G650ER) · S/N 6090N115GKTextron 208B · S/N 208B5590N127TWPilatus PC-12/47E · S/N 1574N17RXGulfstream Aerospace GV-SP (G550) · S/N 5548N180JWCessna 180J · S/N 18052751N1WPTextron 700 · S/N 700-0020N202TWPilatus PC-12/47E · S/N 2202N208TWCessna 208B · S/N 208B0671N20KJCessna 182S · S/N 18280143N212MFPilatus PC-12/47E · S/N 1418N224TWPilatus PC-12/45 · S/N 196N2515SPilatus PC-12/47G · S/N 3073N256TWPilatus PC-12/47E · S/N 1056N257TWPilatus PC-12/47E · S/N 2377N259TWPilatus PC-12/47E · S/N 2446N2616VCessna 170 · S/N 18126N26RXGulfstream Aerospace GV-SP (G550) · S/N 5425N293TWPilatus PC-12/47E · S/N 1293N313TDCourte John M RV-7 · S/N 72402N3MRBombardier BD-700-1A11 · S/N 9650N41287Piper PA-28-151 · S/N 28-7415159N416TWPilatus PC-12/45 · S/N 416N423RSConsolidated Vultee PBY-5A · S/N 48423N42CBeech D18S · S/N A-468N4334XPiper PA-28-181 · S/N 28-8490040N433TWPilatus PC-12/47E · S/N 2241N434TWPilatus PC-12/47E · S/N 2250N435TWPilatus PC-12/47E · S/N 2293N436TWPilatus PC-12/47E · S/N 2310N437TWPilatus PC-12/47E · S/N 2351N438TWPilatus PC-12/47E · S/N 2352N510THPiper PA-28R-200 · S/N 28R-7535221Registration pendingN523TWPilatus PC-12/45 · S/N 523N526TWPilatus PC-12/45 · S/N 656N5548AGrumman G-21A · S/N 75-7661N55BUBeech 95-B55 (T42A) · S/N TC-2138N599GRSocata TB 30 EPSILON · S/N 152N60TDArbc Inc DBA Lindstrand 60X · S/N 5552N612AFGulfstream Aerospace GIV-X (G450) · S/N 4069N616AFGulfstream Aerospace GV-SP (G550) · S/N 5295N623JHWegman THORP T-18 · S/N 940N64442Cessna 172M · S/N 17265230N650ZBGulfstream Aerospace GVI (G650ER) · S/N 6520N66DZInflight RV7A · S/N 72073N7125UMooney M20E · S/N 364N71BQCubcrafters CC11-160 · S/N CC11-00246N7211Grumman G-21A · S/N B24N7238HPiper J3C-65 · S/N 20508N730TWPilatus PC-12/47E · S/N 1516
Back to Oxford, CT