Cancelled registrations · 26

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 = 'NC' AND d.registrant_city = 'DUNN' 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 = 'NC' AND d.registrant_city = 'DUNN'
  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 = 'NC' AND d.registrant_city = 'DUNN'
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.

N723RMJack Spring SPRING BUTTERFLY · S/N 248JSL70444Cancelled May 27, 2022 · Sale reported, canceled · Built 2014 N78578Piper PA-12 · S/N 12-3954Cancelled Feb 19, 2019 · Revoked, canceled · Built 1947 · Cashwell Patricia N6369VAlon A2 · S/N A-45Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1965 · Avery Robert F N3249SStrickland Kenneth C Q-2 · S/N 2661Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Strickland Kenneth C N7037LLatour Robert B CHALLENGER II · S/N CH204880304Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Vannoy Richard L N2102APiper PA-22-135 · S/N 22-557Cancelled Feb 4, 2017 · Revoked, canceled · Built 1952 · Black Ernest G N81273Fairchild 24W-46 · S/N W46173Cancelled May 30, 2014 · Exported to France · Built 1946 · Byrd Martin D N1079NGinn Ronald T SCORPION TOO · S/N RW2870Cancelled Mar 26, 2013 · Sale reported, canceled · Built 1980 N4860EFlightstar FLIGHTSTAR SPYDER · S/N 819Cancelled Jun 18, 2012 · Built 2006 · Marsh Robert T N496CRRoss Charles J BENSON · S/N 001Cancelled Jun 28, 2011 · Sale reported, canceled · Built 2001 N4449QBeech C90 · S/N LJ-895Cancelled Apr 5, 2010 · Exported to Mexico · Built 1980 · Warren Oil Company Inc N207Beech D18S · S/N A-942Cancelled Jul 13, 2009 · Registration revoked · Built 1953 · Avery Robert N4928QCessna A188B · S/N 18802663TCancelled Aug 3, 1994 · Triennial form not returned · Godwin Raymond A N5558GCessna 150J · S/N 15071058Cancelled Aug 20, 1992 · Triennial form not returned · Custom Mobility Equipment Inc N8983GCessna A188 · S/N 18801337Cancelled Nov 2, 1976 · Godwin Sprayers Inc N6774NMooney M20C · S/N 680084Cancelled Jun 9, 1975 · Est Carolina Construction Co N21773Cessna A188B · S/N 18801024TCancelled Aug 20, 1974 · Godwin Sprayers Inc N49968Fairchild M-62A · S/N T42-3723Cancelled Nov 17, 1971 · Harold Tart N94650Ercoupe 415-CD · S/N 4758Cancelled Jan 4, 1971 · Avery Robert N83364Aeronca 7AC · S/N 7AC-2031Cancelled Oct 12, 1970 · Finch Keith N9166DPiper PA-22-160 · S/N 22-6219Cancelled Sep 3, 1970 · East Carolina Construction Company N82323Aeronca 7AC · S/N 7AC-952Cancelled Jun 5, 1965 · Robert F Avery N3022VBeech 35 · S/N D-426Cancelled Feb 17, 1956 · Worth Stewart N278MWaco GXE · S/N G3033Cancelled Feb 20, 1950 · Leo Haid Tart N33406Piper J5A · S/N 5-496Cancelled Jun 3, 1949 · Dunn Flying Club N2032Waco 9 · S/N 2Cancelled Mar 9, 1948 · Built 1926 · Norris M N

Back to Dunn, NC