OpenAirDocs.org
Wings And Things

Registered aircraft · 16

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 = 'WINGS AND THINGS' OR list_contains(g.other_registrant_names, 'WINGS AND THINGS')
  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.

N1466CPiper PA-18-135 · S/N 18-2668Palatine Bridge, NY · Co-owner with Bent James L Jr DBAN1500JPiper PA-18-105 SPECIAL · S/N 18-294Palatine Bridge, NY · Co-owner with Bent James L Jr DBAN1500PPiper PA-18A-135 · S/N 18-3672Palatine Bridge, NY · Co-owner with Bent James L Jr DBAN1602APiper PA-18-125 · S/N 18-1240Palatine Bridge, NY · Co-owner with Bent James L Jr DBAN1853DPiper PA-18 · S/N 18-53Palatine Bridge, NY · Co-owner with Bent James L Jr DBAN2246APiper PA-20S-135 · S/N 20-906Palatine Bridge, NY · Co-owner with Bent James L JrN23132Piper J3L-65 · S/N 2906Built 1939 · Palatine Bridge, NY · Co-owner with Bent James L Jr DBAN28285Piper J3C-65 · S/N 4672Palatine Bridge, NY · Co-owner with Bent James L Jr DBAN35081Piper J3L · S/N 6088Palatine Bridge, NY · Co-owner with Bent James L Jr DBAN4539MPiper PA-11 · S/N 11-43Built 1947 · Palatine Bridge, NY · Co-owner with Bent James L JrN4988HPiper PA-18-135 · S/N 18-1955Palatine Bridge, NY · Co-owner with Bent James L Jr DBAN6684HPiper J3C-65 · S/N 19905Palatine Bridge, NY · Co-owner with Bent James L Jr DBAN6873BPiper PA-18A 150 · S/N 18-5053Palatine Bridge, NY · Co-owner with Bent James L Jr DBAN78775Piper PA-11 · S/N 11-1553Palatine Bridge, NY · Co-owner with Bent James L Jr DBAN8190CPiper PA-22-135 · S/N 22-2295Palatine Bridge, NY · Co-owner with Bent James L Jr DBAN8446JCessna 150G · S/N 15066346Palatine Bridge, NY · Co-owner with Bent James L Jr DBA
Back to Wings And Things