Skip to content

Earlier aircraft under this name · 58

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

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 = 'DUFF J W DBA' OR list_contains(d.other_registrant_names, 'DUFF J W DBA') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'DUFF J W DBA' OR list_contains(d.other_registrant_names, 'DUFF J W DBA')
  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 = 'DUFF J W DBA' OR list_contains(d.other_registrant_names, 'DUFF J W DBA')
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.

N8664ENavion NAVION A · S/N NAV-4-1703Cancelled Feb 21, 2018 · Registration expired, pending cancellation · Built 1948 · Denver, CO N334VBeech E18S · S/N BA-327Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Denver, CO N138USBell UH-1L · S/N 154944Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1967 · Denver, CO N17415Beech C-45H · S/N 52-10664ACancelled Feb 9, 2018 · Registration expired, pending cancellation · Denver, CO N947MGPiper / Duke PA-11 · S/N ED-002Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1991 · Denver, CO N6895Cessna 305A · S/N 51-12729Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1951 · Denver, CO N5543Beech T-34B · S/N 144098Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Denver, CO N6159CCallair A-4 · S/N 172Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1957 · Denver, CO N6263XBeech E50 · S/N LH-143Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Denver, CO N6265UBeech E50 · S/N LH-153Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Denver, CO N29835Taylorcraft BC12-65 · S/N 2686Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1941 · Denver, CO N44969Naval Aircraft Factory N3N-3 · S/N 4462Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1941 · Denver, CO N5580VPiper PA-18-125 · S/N 18-878Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Denver, CO N710BKLockheed 18-08 · S/N 2096Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1941 · Denver, CO N87609Stinson 108 · S/N 108-10Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1945 · Denver, CO N5765EPiper PA-16 · S/N 16-378Cancelled Oct 24, 2017 · Registration expired, pending cancellation · Denver, CO N63802Beech AT-11 · S/N 42-37276Cancelled Oct 23, 2017 · Registration expired, pending cancellation · Denver, CO N74344Bellanca 14-13-2 · S/N 1457Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1947 · Denver, CO N2496VCessna 140 · S/N 14765Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1948 · Denver, CO N38007Hiller H-23D · S/N 61-3190Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1972 · Denver, CO N38008Hiller H-23D · S/N 61-3191Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1972 · Denver, CO N6063DPiper PA-18-125 · S/N 18-590Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Denver, CO N77966Beech E50 · S/N 57-6041Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Denver, CO N96HDouglas DC3C-S1C3G · S/N 19224Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1943 · Denver, CO N566LDMooney M20E · S/N 689Cancelled Sep 28, 2017 · Registration expired, pending cancellation · Built 1965 · Denver, CO N5077BCessna 310 · S/N 38065Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Denver, CO N66210Mooney M20E · S/N 871Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Denver, CO N9132EAeronca 11AC · S/N 11AC-765Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1946 · Denver, CO N2208XCessna 337 · S/N 337-0108Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1965 · Denver, CO N60552Cessna O-2A · S/N 69-7630Cancelled May 15, 2015 · Registration expired, pending cancellation · Denver, CO N6530SCessna O-2A · S/N 68-11048Cancelled May 5, 2015 · Registration expired, pending cancellation · Denver, CO N6641BCessna 310B · S/N 35741Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1958 · Denver, CO N7326CBeech AT-11 · S/N 42-36949Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1957 · Denver, CO N6KLAir Tractor AT-301 · S/N 301-0044Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Denver, CO N10746Cessna 170B · S/N 25125Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Denver, CO N89086Beech E50 · S/N 57-6051Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Denver, CO N91782Navion NAVION F · S/N NAV4488Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Denver, CO N7248NCessna 182P · S/N 18263039Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1974 · Denver, CO N5782Cessna 305A · S/N 23324Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1954 · Denver, CO N5330CCessna 140A · S/N 15450Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1950 · Denver, CO N5370GDehavilland DHC-3 · S/N 343Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1959 · Denver, CO N6200APiper L-21A · S/N 18-918Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Denver, CO N444QBeech TC-45H · S/N AF-62Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Denver, CO N8749JCessna O-2A · S/N 68-10976Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Denver, CO N342DBeech D18S · S/N A-353Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1947 · Denver, CO N440JGNorth American SNJ-5 · S/N 44014Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1958 · Denver, CO N87652Cessna O-2A · S/N 67-21352Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Denver, CO N567AADehavilland DHC-3 · S/N 327Cancelled Sep 8, 2014 · Registration expired, pending cancellation · Built 1959 · Denver, CO N70MDouglas DC3 · S/N 4912Cancelled Sep 3, 2014 · Revoked, canceled · Built 1942 · Denver, CO N1182CBeech C-45H · S/N AF-18Cancelled Aug 28, 2014 · Registration expired, pending cancellation · Built 1951 · Denver, CO

Back to Duff J W DBA