Rangeflyers Inc Trustee
Earlier aircraft under this name · 55
Cancelled registrations that named this owner when they ended, newest first.
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'RANGEFLYERS INC TRUSTEE' OR list_contains(d.other_registrant_names, 'RANGEFLYERS INC TRUSTEE') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'RANGEFLYERS INC TRUSTEE' OR list_contains(d.other_registrant_names, 'RANGEFLYERS INC TRUSTEE') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N959SSTextron B300 · S/N FL-1241N10HDLearjet 60 · S/N 377N723SMTextron 208 · S/N 20800723N266PLTextron 525C · S/N 525C0500N604SGates Learjet 35A · S/N 597N710JCTextron 208 · S/N 20800710N502RDTextron 208 · S/N 20800728N479MNTextron 680A · S/N 680A0479N303ATTextron 525 · S/N 525-1414N368MNTextron B300 · S/N FL-1368N2002STextron 208 · S/N 20800724N2008XTextron 208B · S/N 208B5918N165LCBeech 1900C · S/N UC-165N110HTextron 208 · S/N 20800707N834JHTextron 208B · S/N 208B5834N879PMTextron 560XL · S/N 560-6376N921AMBombardier BD-700-1A10 · S/N 9183N10HDCessna 208B · S/N 208B2331N9008STextron 208B · S/N 208B5859N72AGCessna 510 · S/N 510-0309N125KYTextron 208B · S/N 208B5716N311PBBombardier BD-700-1A10 · S/N 9378N117RDTextron B300C · S/N FM-117N724TRTextron B300 · S/N FL-1038N984DCBombardier BD-700-1A10 · S/N 9314N420DBCessna 441 · S/N 441-0129N114HWTextron B300C · S/N FM-114N112HWTextron B300C · S/N FM-112N510RFCessna 510 · S/N 510-0116N3970PTextron B200GT · S/N BY-397N10HDBombardier BD-700-1A10 · S/N 9682N1293KTextron B300 · S/N FL-1293N350PCTextron B300 · S/N FL-1224N948NTTextron 208B · S/N 208B5737N205RARaytheon B200 · S/N BB-1919N9005DTextron 208B · S/N 208B5734N153LTextron B300 · S/N FL-1276N340EKTextron 680A · S/N 680A0340N1258KTextron B300 · S/N FL-1258N328EKTextron 680A · S/N 680A0328N1KQTextron 525C · S/N 525C0269N378CJCessna 525A · S/N 525A0378N111WPBeechcraft B300 · S/N FL-898N638TLTextron 208B · S/N 208B5638N477FLRaytheon 400A · S/N RK-377N901WTTextron 208B · S/N 208B5634N649JRCessna 510 · S/N 510-0247N80PQLearjet 45 · S/N 417N522EXTextron 208B · S/N 208B5522N828AJTextron B300 · S/N FL-1105
Back to Rangeflyers Inc Trustee