Jac USA Inc
Earlier aircraft under this name · 56
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 = 'JAC USA INC' OR list_contains(d.other_registrant_names, 'JAC USA 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 = 'JAC USA INC' OR list_contains(d.other_registrant_names, 'JAC USA 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.
N669PBTextron 208 · S/N 20800669N549BWTextron 208 · S/N 20800676N670PBTextron 208 · S/N 20800670N580ELTextron T206H · S/N T20609576N2012XTextron T206H · S/N T20609543N2017TTextron T206H · S/N T20609508N2040STextron 172S · S/N 172S12067N2042LTextron 172S · S/N 172S12069N7141STextron 172S · S/N 172S11766N2217MCessna 208B · S/N 208B2078N55354Cessna T206H · S/N T20609177N208DTCessna 208B · S/N 208B2261N172VBCessna 172S · S/N 172S11289N9377FCessna T206H · S/N T20609038N6343FCessna 172S · S/N 172S10848N8128RCessna 208B · S/N 208B2385N944MCCessna T206H · S/N T20608941N540KCessna T206H · S/N T20608571N20210Cessna 208 · S/N 20800534N8113QCessna 208B · S/N 208B2349N9239GCessna 172S · S/N 172S11194N633PCCessna 208 · S/N 20800395N30377Cessna 208 · S/N 20800531N288JACessna 680 · S/N 680-0288N846MACessna 560 · S/N 560-0046N91459Cessna 172S · S/N 172S10957N9147HCessna 172S · S/N 172S10959N9147QCessna 172S · S/N 172S10960N52864Cessna 172S · S/N 172S11016N52855Cessna 172S · S/N 172S11014N5286FCessna 172S · S/N 172S11015N5287CCessna 172S · S/N 172S11017N6204QCessna 208B · S/N 208B2144N5150CCessna 172S · S/N 172S10947N5127DCessna 172S · S/N 172S10939N5224YCessna 172S · S/N 172S10877N5224SCessna 172S · S/N 172S10876N1315GCessna 680 · S/N 680-0173N2151QCessna 525A · S/N 525A0391N2040ECessna 525A · S/N 525A0386N1705LCessna 172S · S/N 172S10629N1231GCessna T206H · S/N T20608774N4117ECessna 208B · S/N 208B1282N12742Cessna 525A · S/N 525A0359N1084MCessna 208 · S/N 20800408N712GGCessna 208B · S/N 208B1206N1309FCessna 208B · S/N 208B1176N406DACessna 208B · S/N 208B1185N1317XCessna 525A · S/N 525A0311N4018SCessna 560 · S/N 560-0694
Back to Jac USA Inc