Angelina Air Inc
Earlier aircraft under this name · 28
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 = 'ANGELINA AIR INC' OR list_contains(d.other_registrant_names, 'ANGELINA AIR 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 = 'ANGELINA AIR INC' OR list_contains(d.other_registrant_names, 'ANGELINA AIR 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.
N840RCPiper PA-42 · S/N 42-8001025N2QLQuasar Acft 214SL · S/N 002N106ZXMicroleve Comercio E Ind Ltda CORSARIO · S/N 453N1048WBeech 58 · S/N TH-311N204KRRaytheon 400A · S/N RK-204N18452Beech 58 · S/N TH-881N8HWBeech 58 · S/N TH-1158N24452Cessna 152 · S/N 15280263N744KWRaytheon A36 · S/N E-3529N56NJCessna T182T · S/N T18208300N2251SCessna 210L · S/N 21061195N4116QPiper PA-42-720 · S/N 42-5501012N75WAPiper PA-31T1 · S/N 31T-8104101N54118Cessna 172P · S/N 17274882N62612Beech 58 · S/N TH-1329N1257TPiper PA-34-200 · S/N 34-7250273N89136Cessna 152 · S/N 15282644N2306ERaytheon A36 · S/N E-3176N6054ZBeech 58 · S/N TH-1099N143RSRaytheon A36 · S/N E-3141N30VTHawker Beechcraft G36 · S/N E-3832N186MECessna 182S · S/N 18280728N359GPPiper PA-31T2 · S/N 31T1166001N96FPPiper PA-31T1 · S/N 31T7904004N2342WRaytheon A36 · S/N E-3191N804URaytheon C90GT · S/N LJ-1814N354QSCessna 560 · S/N 560-0356N933DGPiper PA-42 · S/N 428001106
Back to Angelina Air Inc