Bristol David W
Registered aircraft · 24
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
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_name = 'BRISTOL DAVID W' OR list_contains(g.other_registrant_names, 'BRISTOL DAVID W') 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_name = 'BRISTOL DAVID W' OR list_contains(g.other_registrant_names, 'BRISTOL DAVID W') 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.
N1061HAdams Balloon A50S · S/N 044N1062YAdams Balloon A55 · S/N 105N2423PHead Balloons AX8-88B · S/N 350N3087DHead Balloons AX9-118 · S/N 287N3088WHead Balloons AX7 77B · S/N 270N3099DHead Balloons AX8-88B · S/N 274N4001BHead Balloons AX8-88 · S/N 418N4001MHead Balloons AX7 77B · S/N 424N4031GAdams Balloon A55 · S/N 137N4035PAdams Balloon A55S · S/N 154N4109RLedoux Robert E HAB-3 · S/N 001N420BBBristol Balloons BBC-42K · S/N 005N4500JHead Balloons AX8-88 · S/N 150N4514LHead Balloons AX7 77B · S/N 163N45177Head Balloons AX8-88B · S/N 197N4528EHead Balloons AX8-88 · S/N 188N5659Bristol Balloons/David Bristol B77 · S/N 006N67007Adams Balloon L D-S · S/N 050N8101NSpencer Richard A RJS · S/N 0001N8305NHead Balloons AX7 77B · S/N 226N8307MHead Balloons AX8-88 · S/N 218N9054AAdams Balloon A50S · S/N 041N969DBPiper PA-28-140 · S/N 28-26197N990WBHead Balloons AX8-88B · S/N 450
Back to Bristol David W