OpenAirDocs.org
Addison, TX

Cancelled registrations · 219

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

N27866Piper PA-31-350 · S/N 31-7952009Cancelled Feb 22, 1980 · Exported to Uruguay · Built 1978 · Addison Piper IncN45AJGates Lear Jet 24D · S/N 317Cancelled Dec 4, 1979 · Exported to Mexico · Built 1975 · InterjetN756RLCessna TU206G · S/N U20604295Cancelled Oct 10, 1979 · Exported to Bolivia · Griffin Investments IncN626JTButler AEROSTAR 600 · S/N 60-0035-78Cancelled Sep 25, 1979 · Henderson HaroldN9CNGates Lear Jet 25C · S/N 061Cancelled Mar 30, 1978 · Exported to Venezuela · Interjet IncN1460QCessna 150L · S/N 150-72760Cancelled Jan 24, 1978 · Dallas Skyways IncN4736XCessna 150G · S/N 150-64786Cancelled Feb 24, 1977 · Pat Jetton IncN54293Piper PA-31-350 · S/N 31-7405230Cancelled Dec 9, 1976 · Exported to Canada · Built 1974N8405XCessna 172C · S/N 17248905Cancelled Apr 7, 1976 · Exported to Canada · Built 1962 · Web Thomas Aircraft Sales IncN9911ZBeech C-45H · S/N AF-476Cancelled Sep 15, 1975 · Falcon Airways IncN1479GBeech P35 · S/N D-6929Cancelled Nov 27, 1973 · Pat Jetton IncN67000Douglas DC3 · S/N 1498Cancelled Aug 8, 1973 · Exported to South Africa · Air Services IncN239BBeech M35 · S/N D6225Cancelled Jun 8, 1973 · Pat Jetton IncN8371JCessna 150G · S/N 15066271Cancelled Jan 5, 1971 · Dallas Aeronautical Center IncN4171TCessna 320D · S/N 320D-0071Cancelled Jun 23, 1970 · Aviation & General Leasing CoN48EBeech D50A · S/N DH-171Cancelled Nov 25, 1969 · Sluyter Howard RN8529TCessna 182C · S/N 52429Cancelled Feb 28, 1964 · Exported to Australia · Ted Cooper & Associates IncN4801DCessna 182A · S/N 34901Cancelled Jan 22, 1964 · Exported to Australia · Ted Cooper & Assoc IncN9155FHughes 369HS · S/N 1030522SCancellation date not recorded · Johnson Aviation Inc
Back to Addison, TX