Flight World Inc
Registered aircraft · 18
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 = 'FLIGHT WORLD INC' OR list_contains(g.other_registrant_names, 'FLIGHT WORLD INC') 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 = 'FLIGHT WORLD INC' OR list_contains(g.other_registrant_names, 'FLIGHT WORLD INC') 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.
N121DWBritten-Norman BN-2A-8 · S/N 312N124JRCessna 172M · S/N 17262637N1348LCessna 172S · S/N 172S9939N2107UCessna 172S · S/N 172S9603N254MVPiper PA-32-260 · S/N 32-117N31PCPiper PA-23-160 · S/N 23-1349N479CNCessna 172M · S/N 17266007N479NRPiper PA-28-151 · S/N 28-7715063N479NTCessna 172M · S/N 17265279N479RRPiper PA-28RT-201 · S/N 28R-7918065N5035MCessna 172S · S/N 172S8967N5971ZPiper PA-18A 150 · S/N 18-6288N6027ACessna 162 · S/N 16200146N6055RCessna 162 · S/N 16200201N6339MCessna 152 · S/N 15284680N65JXCessna 152 · S/N 15284244N7049CRobinson Helicopter R22 BETA · S/N 2884N9397HCessna 172M · S/N 17266139
Back to Flight World Inc