Missionary Aviation Fellowship
Earlier aircraft under this name · 112
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 = 'MISSIONARY AVIATION FELLOWSHIP' OR list_contains(d.other_registrant_names, 'MISSIONARY AVIATION FELLOWSHIP') 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 = 'MISSIONARY AVIATION FELLOWSHIP' OR list_contains(d.other_registrant_names, 'MISSIONARY AVIATION FELLOWSHIP') 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.
N72054Cessna TU206D · S/N U206-1269N9015NAero Commander 500 S · S/N 184032N4841FCessna U206A · S/N U206-0541N2290TCessna A185E · S/N 1851451N29200Cessna TU206C · S/N U206-1161N29124Cessna U206C · S/N U206-1094N3479YCessna 180H · S/N 18051979N7257TCessna 172A · S/N 46857N3356LCessna A185E · S/N 185-1308N5094UCessna 206 · S/N 206-0094N3847GCessna TU206B · S/N U206-0847N7954VCessna 180H · S/N 18051854N3402LCessna TU206B · S/N U206-0702N2668QCessna 182K · S/N 18257868N2412FCessna 180H · S/N 18051612N1550FCessna 185D · S/N 185-0913N1569FCessna 185D · S/N 185-0946N6390UAero Commander 500-B · S/N 1506-180N5889TCessna 185D · S/N 1850789N5849TCessna 185C · S/N 185-0749N1530FCessna 185D · S/N 185-0873N2911DCessna 170B · S/N 26854N5164HPiper PA-14 · S/N 14-173N7867ACessna 180A · S/N 32764N1521FCessna 185D · S/N 185-0864N4714UCessna 180G · S/N 18051414N4760UCessna 180H · S/N 18051460N5872TCessna 185C · S/N 185-0772N5862TCessna 185C · S/N 185-0762N6483XCessna 180D · S/N 18050983N2685ZCessna 185C · S/N 185-0685N5814TCessna 185C · S/N 185-0714N2699ZCessna 185C · S/N 185-0699N5272ECessna 180B · S/N 50572N2183ZCessna 180F · S/N 180-51283N2114ZCessna 180F · S/N 18051214N2685YCessna 180F · S/N 18051185N2667ZCessna 185C · S/N 185-0667N2692YCessna 180F · S/N 18051192N8667XCessna 180E · S/N 18051067N1697ZCessna 185A · S/N 185-0497N9985XCessna 185 · S/N 1850185N9913XCessna 185 · S/N 1850113N9993XCessna 185 · S/N 1850193N3613ZPiper PA-22-150 · S/N 22-7502N8628XCessna 180D · S/N 18051028N3724ZPiper PA-22-150 · S/N 22-7598N6441XCessna 180D · S/N 18050941N6457XCessna 180D · S/N 18050957N9399TCessna 180C · S/N 50899
Back to Missionary Aviation Fellowship