Mustang Sally Aviation LLC
Registered aircraft · 66
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 = 'MUSTANG SALLY AVIATION LLC' OR list_contains(g.other_registrant_names, 'MUSTANG SALLY AVIATION 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 = 'MUSTANG SALLY AVIATION LLC' OR list_contains(g.other_registrant_names, 'MUSTANG SALLY AVIATION 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.
N1242BCessna 172S · S/N 172S10307N1318QCessna 172S · S/N 172S10657N1323XCessna 172S · S/N 172S10367N1496MCessna 182P · S/N 18264352N183ERCessna 150L · S/N 15073584N1859UCessna 172S · S/N 172S9927N187ERCessna 150M · S/N 15077004N189ERCessna 150M · S/N 15076412N20957Cessna 172S · S/N 172S9571N210JMCessna T210N · S/N 21064159N2119QCessna 172S · S/N 172S9623N2157HCessna 172S · S/N 172S9536N22467Cessna 172S · S/N 172S10487N2302YCessna 172S · S/N 172S9973N24447Cessna 172S · S/N 172S10122N24671Cessna 172R · S/N 17280925N2472UCessna 172S · S/N 172S10074N269FGCessna 172S · S/N 172S10885N26AATextron 172S · S/N 172S11693N316EPTextron 172S · S/N 172S11682N3265ACessna 172S · S/N 172S9878N401LPCessna 172S · S/N 172S9401N464ERCessna 172S · S/N 172S11598N467DMCessna 421B · S/N 421B0377N469FGCessna 172S · S/N 172S10884N509FGCessna 172S · S/N 172S10270N5114ZCessna 172S · S/N 172S10927N51390Cessna 172S · S/N 172S10892N5181ECessna 172S · S/N 172S9058N52217Cessna 172P · S/N 17274441N52232Cessna 172S · S/N 172S10870N5225DCessna 172N · S/N 17272457N5251ZCessna 172S · S/N 172S10902N52522Cessna 172S · S/N 172S10905N5253CCessna 172S · S/N 172S10906N5275WCessna 172S · S/N 172S10938N5378DCessna 172N · S/N 17272553N53AATextron 172S · S/N 172S11737N54094Cessna 172P · S/N 17274874N562AFCessna 172S · S/N 172S9555N564ATCessna 172S · S/N 172S10020N569FGCessna 172S · S/N 172S10871N60616Cessna 172S · S/N 172S10239N609FJTextron 172S · S/N 172S12398N6185UCessna 172S · S/N 172S10719N6208CCessna 172S · S/N 172S10820N6269QCessna 172S · S/N 172S10715N636SACessna 172S · S/N 172S9636N65311Cessna 172S · S/N 172S9695N65742Cessna 172P · S/N 17275847
Back to Mustang Sally Aviation LLC