Skip to content

Rapidflight Holdings LLC

Registered aircraft · 46

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

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 = 'RAPIDFLIGHT HOLDINGS LLC' OR list_contains(g.other_registrant_names, 'RAPIDFLIGHT HOLDINGS LLC') ORDER BY g.n_number

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 = 'RAPIDFLIGHT HOLDINGS LLC' OR list_contains(g.other_registrant_names, 'RAPIDFLIGHT HOLDINGS 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 = 'RAPIDFLIGHT HOLDINGS LLC' OR list_contains(g.other_registrant_names, 'RAPIDFLIGHT HOLDINGS 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.

N250GLRapidflight Holdings M1 GLIDER · S/N 001Manassas, VA N251GLRapidflight Holdings M2 GLIDER · S/N 001Manassas, VA N252GLRapidflight Holdings E2 GLIDER · S/N 001Manassas, VA N270RFRapidflight Holdings M2 · S/N 001Manassas, VA N271RFRapidflight Holdings M2 · S/N 002Manassas, VA N272RFRapidflight Holdings E2 · S/N 001Manassas, VA N273RFRapidflight Holdings E2 · S/N 002Manassas, VA N274RFRapidflight Holdings E2 · S/N 003Manassas, VA N275RFRapidflight Holdings E2 · S/N 004Manassas, VA N276RFRapidflight Holdings E2 · S/N 005Manassas, VA N279RFRapidflight Holdings E2 · S/N 006Manassas, VA N280RFRapidflight Holdings E2 · S/N 007Manassas, VA N281RFRapidflight Holdings E2 · S/N 008Manassas, VA N283RFRapidflight Holdings E2 · S/N 009Manassas, VA N285RFRapidflight Holdings E2 · S/N 010Manassas, VA N286RFRapidflight Holdings E2 · S/N 011Manassas, VA N287RFRapidflight Holdings E2 · S/N 012Manassas, VA N288RFRapidflight Holdings E2 · S/N 013Manassas, VA N290RFRapidflight Holdings E2 · S/N 014Manassas, VA N292RFRapidflight Holdings E2 · S/N 015Manassas, VA N294RFRapidflight Holdings M2 · S/N 003Manassas, VA N295RFRapidflight Holdings M2 · S/N 004Manassas, VA N296RFRapidflight Holdings M2 · S/N 005Manassas, VA N298RFRapidflight Holdings M2 · S/N 006Manassas, VA N301RFRapidflight Holdings M2 · S/N 007Manassas, VA N302RFRapidflight Holdings M2 · S/N 008Manassas, VA N304RFRapidflight Holdings M2 · S/N 009Manassas, VA N305RFRapidflight Holdings M2 · S/N 010Manassas, VA N306RFRapidflight Holdings M2 · S/N 011Manassas, VA N307RFRapidflight Holdings M2 · S/N 012Manassas, VA N308RFRapidflight Holdings M2 · S/N 013Manassas, VA N309RFRapidflight Holdings M1 · S/N 001Manassas, VA N318RFRapidflight Holdings M1 · S/N 002Manassas, VA N322RFRapidflight Holdings M1 · S/N 003Manassas, VA N324RFRapidflight Holdings M1 · S/N 004Manassas, VA N327RFRapidflight Holdings M1 · S/N 005Manassas, VA N328RFRapidflight Holdings M1 · S/N 006Manassas, VA N329RFRapidflight Holdings M1 · S/N 007Manassas, VA N336RFRapidflight Holdings VALOR · S/N 001Manassas, VA N337RFRapidflight Holdings VALOR · S/N 002Manassas, VA N338RFRapidflight Holdings SPX · S/N 001Manasas, VA N339RFRapidflight Holdings SPX · S/N 002Manassas, VA N341RFRapidflight Holdings SPX · S/N 003Manassas, VA N342RFRapidflight Holdings VISTA · S/N 001Manassas, VA N343RFRapidflight Holdings VISTA · S/N 002Manassas, VA N344RFRapidflight Holdings VISTA · S/N 003Manassas, VA

Back to Rapidflight Holdings LLC