Aircraft Facilities Intl Inc
Earlier aircraft under this name · 35
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 = 'AIRCRAFT FACILITIES INTL INC' OR list_contains(d.other_registrant_names, 'AIRCRAFT FACILITIES INTL 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 = 'AIRCRAFT FACILITIES INTL INC' OR list_contains(d.other_registrant_names, 'AIRCRAFT FACILITIES INTL 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.
N18401Beech 76 · S/N ME-430N1841NBeech A36 · S/N E-1942N18395Beech A36 · S/N E-1928N5110YCessna 210N · S/N 21064078N5470CCessna 210N · S/N 21063762N6082CCessna R182 · S/N R18200373N60659Beech C90 · S/N LJ-880N6067UBeech A36 · S/N E-1620N6067EBeech A36TC · S/N EA-44N6065UBeech 76 · S/N ME-290N6064FBeech F33A · S/N CE-879N6064UBeech V35B · S/N D-10292N6062RBeech A36 · S/N E-1566N6062MBeech 58 · S/N TH-1062N7848LBeech 65-B80 · S/N LD-384N6062XBeech C90 · S/N LJ-855N60493Beech F33A · S/N CE-865N88036Helio H-295 · S/N 1465N5475GCessna 421C · S/N 421C0222N1558LBeech 58 · S/N TH-770N6750SBeech A36 · S/N E-792N6751SBeech 58 · S/N TH-705N6715SBeech F33C · S/N CJ-100N6716SBeech F33C · S/N CJ-101N8184RBeech B-60 · S/N P-297N7331RBeech B-80 · S/N LD-489N7393RBeech 58 · S/N TH-499N7320RBeech 65-B80 · S/N LD-478N7343RBeech B-60 · S/N P-281N7399RBeech C23 · S/N M-1540N3006WBeech B-80 · S/N LD-471N79465Cessna 182P · S/N 18261827N28890Cessna U206F · S/N U206-01904N22320Cessna 210L · S/N 21059736N9637GCessna U206F · S/N U20601837
Back to Aircraft Facilities Intl Inc