Flexjet LLC
Registered aircraft · 241
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 = 'FLEXJET LLC' OR list_contains(g.other_registrant_names, 'FLEXJET 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 = 'FLEXJET LLC' OR list_contains(g.other_registrant_names, 'FLEXJET 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.
N102FXGulfstream Aerospace GVIII-G700 · S/N 87007N103FXGulfstream Aerospace GVIII-G700 · S/N 87039N172FXCessna 172N · S/N 17271381N1836LBeech A36 · S/N E-1111N200FXGulfstream Aerospace GVII-G500 · S/N 72136N223FXBombardier BD-100-1A10 · S/N 21102N224FXBombardier BD-100-1A10 · S/N 21118N227FXBombardier BD-100-1A10 · S/N 21134N233FXEmbraer Executive EMB-505 · S/N 50500938N234FXEmbraer Executive EMB-505 · S/N 50500949N235FXEmbraer Executive EMB-505 · S/N 50500972N265FXEmbraer S A EMB-545 · S/N 55010178N267FXEmbraer S A EMB-545 · S/N 55010185N274FXEmbraer S A EMB-545 · S/N 55010208N275FXEmbraer S A EMB-545 · S/N 55010210N279FXEmbraer S A EMB-545 · S/N 55010213N281FXEmbraer S A EMB-545 · S/N 55010214N282FXEmbraer S A EMB-545 · S/N 55010217N283FXEmbraer S A EMB-545 · S/N 55010218N304FXEmbraer Executive EMB-505 · S/N 50500875N305FXEmbraer Executive EMB-505 · S/N 50500881N306FXEmbraer Executive EMB-505 · S/N 50500895N308FXEmbraer Executive EMB-505 · S/N 50500910N309FXEmbraer Executive EMB-505 · S/N 50500913N310FXEmbraer S A EMB-505 · S/N 50500366N311FXEmbraer Executive EMB-505 · S/N 50500955N312FXEmbraer Executive EMB-505 · S/N 50500963N314FXEmbraer Executive EMB-505 · S/N 50500978N316FXEmbraer S A EMB-545 · S/N 55010154N318FXEmbraer S A EMB-545 · S/N 55010151N319FXEmbraer S A EMB-545 · S/N 55010150N325FXEmbraer S A EMB-545 · S/N 55010137N331FXEmbraer-Empresa Brasileira De EMB-505 · S/N 50500032N333FXEmbraer-Empresa Brasileira De EMB-505 · S/N 50500034N335FXEmbraer S A EMB-545 · S/N 55010119N336FXEmbraer S A EMB-545 · S/N 55010118N338FXEmbraer S A EMB-545 · S/N 55010114N340FXEmbraer S A EMB-545 · S/N 55010111N341FXEmbraer S A EMB-505 · S/N 50500047N343FXEmbraer S A EMB-545 · S/N 55010107N344FXEmbraer S A EMB-505 · S/N 50500050N345FXEmbraer S A EMB-545 · S/N 55010105N346FXEmbraer S A EMB-505 · S/N 50500090N347FXEmbraer S A EMB-505 · S/N 50500094N348FXEmbraer S A EMB-505 · S/N 50500097N349FXEmbraer S A EMB-505 · S/N 50500100N351FXEmbraer S A EMB-505 · S/N 50500105N352FXEmbraer S A EMB-505 · S/N 50500109N353FXEmbraer S A EMB-505 · S/N 50500115N354FXEmbraer S A EMB-505 · S/N 50500135
Back to Flexjet LLC