Euroflight Inc
Earlier aircraft under this name · 73
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 = 'EUROFLIGHT INC' OR list_contains(d.other_registrant_names, 'EUROFLIGHT 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 = 'EUROFLIGHT INC' OR list_contains(d.other_registrant_names, 'EUROFLIGHT 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.
N94999Cessna 152 · S/N 15285834N44RNBeech B36TC · S/N EA-584N78XJRaytheon C90A · S/N LJ-1524N500HLLancair LC-40-550FG · S/N 40006N30538Raytheon 1900D · S/N UE-369N30511Raytheon 1900D · S/N UE-366N31685Raytheon 1900D · S/N UE-365N3205MRaytheon B300 · S/N FL-255N23610Raytheon 1900D · S/N UE-358N23538Raytheon 1900D · S/N UE355N3156FRaytheon C90A · S/N LJ-1556N2341RRaytheon B300 · S/N FL238N23493Raytheon HAWKER 800XP · S/N 258389N2345MRaytheon B200 · S/N BB-1633N2820BRaytheon 1900D · S/N UE-331N2849VCessna 150M · S/N 15076301N8270RBeech B300 · S/N FL73N205JTBeech B200 · S/N BB1564N11024Raytheon 1900D · S/N UE270N1113JRaytheon A36 · S/N E3013N821SABeech A36 · S/N E3003N1109QBeech A36 · S/N E3009N3267QRaytheon A36 · S/N E3023N1062TBeech 58 · S/N TH1762N1063GBeech 58 · S/N TH1763N3256LBeech 58 · S/N TH1756N10575Beech A36 · S/N E3012N3218GBeech A36 · S/N E2990N3217VBeech B200 · S/N BB1517N8180QBeech 400A · S/N RK80N1560UBeech C90A · S/N LJ1360N15229Beech F33A · S/N CE1770N1565FBeech A36 · S/N E2913N1551NBeech F33A · S/N CE1774N8138MBeech 400A · S/N RK84N8273LBeech 300 · S/N FA222N81418Beech 300 · S/N FA227N8202PBeech B300 · S/N FL102N8297LBeech B300 · S/N FL97N8274UBeech B300 · S/N FL76N8227PBeech C90A · S/N LJ1327N8225ZBeech B200 · S/N BB1470N80617Beech F33A · S/N CE1732N8216ZBeech B200 · S/N BB1466N8214TBeech B200 · S/N BB1465N80639Beech F33A · S/N CE1758N8097YBeech B300 · S/N FL75N8163RBeech B200 · S/N BB1459N8164GBeech B200 · S/N BB1460N200KABeech B200 · S/N BB1449
Back to Euroflight Inc