Skip to content

Cancelled registrations · 2,333

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_state = 'TX' AND d.registrant_city = 'DALLAS' 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_state = 'TX' AND d.registrant_city = 'DALLAS'
  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_state = 'TX' AND d.registrant_city = 'DALLAS'
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.

N662QQDJI PHANTOM 3 PROFESSION · S/N P76DCG08013751Cancelled Jul 2, 2019 · Registration expired, pending cancellation · Nance Joseph W N974AZEmbraer S A ERJ 190-100 LR · S/N 19000074Cancelled Jun 21, 2019 · Exported to Germany · E190 Msn074 LLC N27PGPiper PA 46-350P · S/N 4622104Cancelled Jun 17, 2019 · Exported to Canada · Built 1990 · Holmes Brian J N77286Bombardier CL-600-2B19 · S/N 7286Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1999 · Beautech Power Systems LLC N1050DCessna 195A · S/N 7662Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1951 · Butcher Tom Electrical Constr Co N22NFBritish Aerospace BAE 125 SERIES 800A · S/N NA0432Cancelled Apr 30, 2019 · Sunwest Aero LLC N7192YPiper PA-30 · S/N 30-216Cancelled Apr 25, 2019 · Sale reported, canceled · Built 1963 N6178HPiper J3C-65 · S/N 19342Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Built 1940 · Scott Thomas W N631RPBombardier BD-100-1A10 · S/N 20603Cancelled Mar 20, 2019 · Exported to Canada · Built 2015 · Bombardier Aerospace Corp N3829VCessna 170 · S/N 18687Cancelled Feb 19, 2019 · Revoked, canceled · Built 1948 · Sheets John S Jr N103BTEmbraer Empresa Brasileira De ERJ 190-100 IGW · S/N 19000052Cancelled Feb 11, 2019 · Beautech Power Systems LLC N103CAEmbraer Empresa Brasileira De ERJ 190-100 IGW · S/N 19000044Cancelled Feb 11, 2019 · Beautech Power Systems LLC N137CAEmbraer Empresa Brasileira De ERJ 190-100 IGW · S/N 19000094Cancelled Feb 11, 2019 · Beautech Power Systems LLC N702BTEmbraer ERJ 170-100 LR · S/N 17000002Cancelled Feb 11, 2019 · Beautech Power Systems LLC N857CCEmbraer Empresa Brasileira De ERJ 190-100 IGW · S/N 19000046Cancelled Feb 11, 2019 · Beautech Power Systems LLC N1276KLuscombe 8A · S/N 4003Cancelled Feb 8, 2019 · Revoked, canceled · Built 1946 · Baumgartner Edward H N315LCBeech 1900C · S/N UC115Cancelled Jan 23, 2019 · Exported to Sweden · Aircraft Finance Partners I LLC N2DJJohnson PITTS S-1C · S/N 764-HCancelled Jan 14, 2019 · Registration expired, pending cancellation · Built 1974 · Johnson Delmo L Jr N568AFDJI PHANTOM VISION 2+ · S/N PH645496192Cancelled Jan 8, 2019 · Registration expired, pending cancellation · Flightgraphix LLC N352SWBoeing 737-3H4 · S/N 24888Cancelled Jan 2, 2019 · Built 1990 · Southwest Airlines Co N511SWBoeing 737-5H4 · S/N 24188Cancelled Jan 2, 2019 · Built 1991 · Southwest Airlines Co N520SWBoeing 737-5H4 · S/N 25319Cancelled Jan 2, 2019 · Built 1991 · Southwest Airlines Co N613SWBoeing 737-3H4 · S/N 27931Cancelled Jan 2, 2019 · Built 1995 · Southwest Airlines Co N614SWBoeing 737-3H4 · S/N 28033Cancelled Jan 2, 2019 · Built 1995 · Southwest Airlines Co N615SWBoeing 737-3H4 · S/N 27698Cancelled Jan 2, 2019 · Built 1995 · Southwest Airlines Co N616SWBoeing 737-3H4 · S/N 27699Cancelled Jan 2, 2019 · Built 1995 · Southwest Airlines Co N687SWBoeing 737-3Q8 · S/N 23388Cancelled Jan 2, 2019 · Built 1986 · Southwest Airlines Co N577VTDJI INSPIRE 1 · S/N W13DCB04020201Cancelled Dec 11, 2018 · Registration expired, pending cancellation · Thompson William Clay N577WTDJI INSPIRE 1 · S/N W13DBL21020058Cancelled Dec 11, 2018 · Registration expired, pending cancellation · Thompson William Clay N42MJCessna 551 · S/N 551-0007Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Built 1978 · Marklyn Jet Parts LLC N74577Mooney M20B · S/N 1888Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Built 1961 · Edelstein Brian N736AEmbraer ERJ 170-100 LR · S/N 17000320Cancelled Sep 27, 2018 · Built 2010 · Beautech Power Systems LLC N6803QBeech 65-80 · S/N LD-36Cancelled Sep 7, 2018 · Revoked, canceled · Built 1962 · B & G Co N24LFBeech A36 · S/N E-1665Cancelled Aug 31, 2018 · Sale reported, pending cancellation · Built 1980 N574EHSikorsky S-76A · S/N 760369Cancelled Aug 18, 2018 · Registration pending, canceled · Built 1990 N2ANAntonov AN-2 · S/N 43798Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1984 · American Airpower Heritage Flying Museum N4441NConsolidated Vultee BT-15 · S/N 1297Cancelled Jul 19, 2018 · Revoked, canceled · Millot A E N148MCIsrael Aircraft Industries GULFSTREAM 200 · S/N 175Cancelled Jul 16, 2018 · Exported to Mexico · Built 2007 N1513LBell OH-58A · S/N 72-21388Cancelled Jul 12, 2018 · Registration expired, pending cancellation · City Of Dallas N888ZZBritish Aerospace BAE 125 SERIES 800A · S/N 258017Cancelled Jun 1, 2018 · Sale reported, canceled N67764Cessna 152 · S/N 15282004Cancelled May 31, 2018 · Sale reported, canceled · Built 1978 N22073Luscombe 8A · S/N 899Cancelled May 18, 2018 · Revoked, canceled · Built 1939 · Gamon Alec N2926CCessna 180 · S/N 30826Cancelled May 18, 2018 · Revoked, canceled · Built 1954 · Leversee Richard N691WNBoeing 737-3G7 · S/N 23781Cancelled May 4, 2018 · Registration expired, pending cancellation · Built 1988 · Southwest Airlines Co N349SWBoeing 737-3H4 · S/N 24408Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 1989 · Southwest Airlines Co N508SWBoeing 737-5H4 · S/N 24185Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1990 · Southwest Airlines Co N81815Aeronca 7AC · S/N 7AC438Cancelled Apr 6, 2018 · Revoked, canceled · Built 1945 · Jappinen J H N3598KPiper J3C-65 · S/N 22290Cancelled Apr 5, 2018 · Revoked, canceled · Built 1946 · A And M Dusting Svc N4479NConsolidated Vultee BT-15 · S/N 10720Cancelled Apr 5, 2018 · Revoked, canceled · Chase Harry M Inc N6714XCessna 310F · S/N 310F-0014Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Pilotstar Inc

Back to Dallas, TX