Old Style Aircraft LLC
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 = 'OLD STYLE AIRCRAFT LLC' OR list_contains(g.other_registrant_names, 'OLD STYLE AIRCRAFT LLC') 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 = 'OLD STYLE AIRCRAFT LLC' OR list_contains(g.other_registrant_names, 'OLD STYLE AIRCRAFT LLC') 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.
N12445Waco PBA · S/N 3598N144YWaco RNF · S/N 3319N17470Waco ZPF-6 · S/N 4383N25894Piper J3L-65 · S/N 3750N261MWaco BSO · S/N A-159N280WWaco CTO · S/N A-3596N369HMonocoupe 90AL-115 · S/N 863N4444Spartan 7W · S/N 18N5533Waco ATO · S/N A-7N631NWaco JYM · S/N J-3183N741EAWaco ATO · S/N A-75N78851Aircraft Manufacturing TEXAS BULLET 205 · S/N 105N906HWaco ATO · S/N A-103N90HWaco AVN-8 · S/N 5114N951BSaint Louis C-2-110 · S/N C-106First renewal noticeN9899YChampion 7GCB · S/N 7GCB-139
Back to Old Style Aircraft LLC