Eagle Aviation 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 = 'EAGLE AVIATION INC' OR list_contains(d.other_registrant_names, 'EAGLE AVIATION 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 = 'EAGLE AVIATION INC' OR list_contains(d.other_registrant_names, 'EAGLE AVIATION 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.
N2723XCessna 441 · S/N 441-0180N66466Consolidated Vultee BT-13A · S/N 5010N50391Cessna 172S · S/N 172S8968N35310Cessna T206H · S/N T20608289N74PGCessna 525 · S/N 525-0476N96AXGates Learjet 35A · S/N 35A-608N412TCCirrus Design SR22 · S/N 0316N19369Cessna 150L · S/N 15074371N707EACessna 550 · S/N 5500707N880EACessna 425 · S/N 4250080N671EACessna 550 · S/N 5500671N903WJGates Learjet 35A · S/N 380N3615UCessna 182F · S/N 18255015N2049SCessna T210L · S/N 21061016N98751Cessna 425 · S/N 4250003N969MECessna 425 · S/N 4250189N100JJCessna 500 · S/N 5000192N81798Cessna 425 · S/N 4250151N63572Cessna 150M · S/N 15077402N8621JCessna 150G · S/N 15066521N5349TPiper PA-28R-200 · S/N 28R7235226N6601SBeech 58 · S/N TH-714N18788Beech C23 · S/N M-1944N333KMMitsubishi MU-2B-20 · S/N 165N5254LPiper PA-28-180 · S/N 284551N722DSCessna 172K · S/N 17258923N7142GCessna 172K · S/N 17258842N1753ZCessna 336 · S/N 3360053
Back to Eagle Aviation Inc