Rolim Freight Forward Inc
Earlier aircraft under this name · 54
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 = 'ROLIM FREIGHT FORWARD INC' OR list_contains(d.other_registrant_names, 'ROLIM FREIGHT FORWARD INC') 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 = 'ROLIM FREIGHT FORWARD INC' OR list_contains(d.other_registrant_names, 'ROLIM FREIGHT FORWARD INC') 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.
N282REBellanca 17-30A · S/N 90-301013N11SEChristen Industries PITTS S-2B · S/N 5099N323AJPzl-Swidnik PW-5 · S/N 17.08.022N3872HBurkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3776N989PTCessna 650 · S/N 6500129N89AGIsrael Aircraft Industries GULFSTREAM G150 · S/N 239N868AGPiper PA-31T1 · S/N 31T-8104058N263TBPiper PA46R-350T · S/N 4692197N197STPiper PA46-500TP · S/N 4697555N264BCPiper PA46-500TP · S/N 4697518N57KCPiper PA-31T2 · S/N 31T-8166076N4092PTextron G36 · S/N E-4092N512LPPiper PA-34-220T · S/N 3449184N7054ZPiper PA-25-235 · S/N 25-2823N49MUBeechcraft G58 · S/N TH-2396N781ACCessna 182T · S/N 18281316N808PDCessna 206H · S/N 20608076N777RLBeech E-55 · S/N TE-1042N166ARCessna 206H · S/N 20608349N300JWAmerican Champion 8KCAB · S/N 926-2003N745JBeech F33A · S/N CE-1750N312DSPiper PA 46-350P · S/N 4636455N4383APiper PA-28-181 · S/N 28-8590019N868LLCirrus Design SR20 · S/N 1664N256ADBeech 58 · S/N TH-424N5246BCessna 152 · S/N 15283815N64940Cessna 152 · S/N 15281488N955CDCirrus Design SR20 · S/N 1609N4687QCessna T210L · S/N 21059587N248JPiper PA-31T2 · S/N 31T-8166009N5256YCessna T210N · S/N 21064138N737MHCessna R182 · S/N R18200851N711WRPiper PA-28-161 · S/N 28-7816121N261NDPiper PA-28-161 · S/N 2842060N1519WBeech F33A · S/N CE-372N333LGBeech E-55 · S/N TE-1098N4863HCessna 152 · S/N 15283989N431CCPiper PA-34-220T · S/N 3433138N5072SPiper PA-28R-200 · S/N 28R-7135076N512RRBeech C90 · S/N LJ-832N6751CBeech 58 · S/N TH-1131N6395SBeech E-55 · S/N TE-987N6868APiper PA-23-250 · S/N 27-7954101N1800UBeech 58 · S/N TH-1257N626TAPiper PA46R-350T · S/N 4692033N6121Beech 58 · S/N TH-955N1899WBeech 95-B55 (T42A) · S/N TC-1569N6575UBeech 58 · S/N TH-1370N3306SCessna 210J · S/N 21059106N6644RBeech 58 · S/N TH-544
Back to Rolim Freight Forward Inc