OpenAirDocs.org
Laredo, TX

Cancelled registrations · 238

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 = 'LAREDO'
  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.

N26461Hughes 269C · S/N 411048Cancelled Jul 25, 1983 · Exported to Dominican Republic · Air Parts & Development CorpN69321Cessna 402B · S/N 402B0436Cancelled May 12, 1983 · Fiesta Photo Finishing IncN2782DCessna 500 · S/N 500-0152Cancelled Jan 19, 1983 · Exported to Mexico · Built 1974 · Lacey H Douglas TrusteeN6070HPiper PA-28R-201T · S/N 28R-7803084Cancelled Jan 18, 1983 · Douglas Lacey H TrusteeN332KBeech 65-90 · S/N LJ-79Cancelled Oct 1, 1982 · Leyendecker A MN91450Cessna T207 · S/N 20700002Cancelled Mar 29, 1982 · Wood Flying Service IncN2406FPiper PA-38-112 · S/N 38-79A0421Cancelled Nov 6, 1981 · Exported to Mexico · Built 1979 · Aero Center IncN6827APiper PA-23-250 (6PCLM) · S/N 27-7954093Cancelled Sep 30, 1981 · Exported to Mexico · Aero Center IncN79DJPiper PA-28RT-201T · S/N 28R-7931090Cancelled Aug 20, 1981 · Exported to Mexico · Aero Center IncN2574ERockwell International NA-265-25 · S/N 465-55Cancelled Jul 7, 1981 · Exported to Mexico · Aircraft Parts & Development CorpN25394Piper PA-38-112 · S/N 38-80A0109Cancelled Jan 22, 1981 · Exported to Mexico · Aero Center IncN3545BPiper PA-31-325 · S/N 31-8012009Cancelled Nov 25, 1980 · Exported to Mexico · Built 1979 · Setay Aviation IncN8236BPiper PA-32R-301T · S/N 32R8029106Cancelled Nov 19, 1980 · Exported to Mexico · Aero Center IncN2219MPiper PA-28-236 · S/N 28-7911093Cancelled Oct 29, 1980 · Exported to Mexico · Built 1979 · Narvaez Jose Carlos PN734SHCessna TU206G · S/N U20604867Cancelled Sep 23, 1980 · Exported to Mexico · Skytram Aviation IncN6945APiper PA-23-250 · S/N 27-8054003Cancelled Aug 27, 1980 · Exported to Mexico · Aero Center IncN1064BAircraft Parts & Dev. A-9B · S/N 5008Cancelled Aug 19, 1980 · Exported to Mexico · Built 1979 · Aircraft Parts & Development CorpN2268XAircraft Parts & Dev. A-9B · S/N 5003Cancelled Aug 19, 1980 · Exported to Mexico · Built 1978 · Aircraft Parts & Development CorpN9047CAircraft Parts & Dev. A-9B · S/N 5006Cancelled Aug 19, 1980 · Exported to Mexico · Aircraft Parts & Development CorpN27575Piper PA-31-325 · S/N 31-7812057Cancelled Feb 5, 1980 · Exported to Mexico · Built 1978 · Arrow Center IncN2216FPiper PA-32RT-300T · S/N 32R-7987066Cancelled Jan 16, 1980 · Exported to Mexico · Built 1978 · Aero Center IncN6952NCessna T210N · S/N 21063162Cancelled Jan 16, 1980 · Exported to Mexico · Skytram Aviation IncN3544DPiper PA-31-325 · S/N 31-8012003Cancelled Dec 27, 1979 · Exported to Mexico · Built 1979 · Aero Center IncN35329Piper PA-31-350 · S/N 31-7952179Cancelled Dec 10, 1979 · Exported to Mexico · Aero Center IncN4850KCessna P210N · S/N P21000346Cancelled Dec 5, 1979 · Exported to Mexico · Skytram Aviation IncN732YNCessna TU206G · S/N U20604739Cancelled Aug 24, 1979 · Exported to Mexico · Skytram Aviation IncN2153APiper PA-28-181 · S/N 287990109Cancelled Jul 25, 1979 · Exported to Mexico · Built 1978 · Aero Center IncN6561ZPiper PA-25-235 · S/N 25-2107Cancelled Jul 17, 1979 · Exported to Mexico · Wood Flying Service IncN4667UCessna TU206G · S/N U20605041Cancelled Jul 11, 1979 · Exported to Mexico · Aero Center IncN111BYCessna 421B · S/N 421B0596Cancelled May 24, 1979 · Exported to Mexico · Built 1974 · Longair IncN221RJIsrael Aircraft Industries 1123 · S/N 160Cancelled Mar 31, 1979 · Exported to Mexico · Built 1972 · Aero Center IncN31643Piper PA-34-200T · S/N 34-7870247Cancelled Mar 6, 1979 · Exported to Mexico · Aero Center IncN1275HPiper PA-32R-300 · S/N 32R7780149Cancelled Jan 12, 1979 · Exported to Mexico · Built 1977 · Aero Center IncN27270Piper PA-31-325 · S/N 31-7712061Cancelled Oct 31, 1978 · Exported to Mexico · Aero Center IncN8768CPiper PA-32-260 · S/N 32-7600009Cancelled Apr 25, 1978 · Exported to New Zealand · Built 1976N756FACessna TU206G · S/N U20604045Cancelled Jan 13, 1978 · Exported to Mexico · Wood Flying Service IncN7048ZPiper PA-25-235 · S/N 25-2815Cancelled Jan 9, 1978 · Wood Flying Service IncN756FWCessna U206G · S/N U20604065Cancelled Jan 6, 1978 · Exported to Mexico · Wood Flying Service IncN8588QCessna TU206F · S/N U20603444Cancelled Nov 10, 1977 · Exported to Mexico · Aero Center IncN9653ACessna 140A · S/N 15374Cancelled Mar 31, 1977 · JohnsongunnarN3677CCessna 180 · S/N 31176Cancelled May 20, 1976 · Wood Lucille SN9740SBeech B-60 · S/N P-331Cancelled Oct 23, 1975 · Exported to Mexico · Esquino SalvadorN8794RBeech B-60 · S/N P-294Cancelled Aug 15, 1975 · Esquino SalvadorN40582Piper PA-23-250 · S/N 27-7405326Cancelled Nov 25, 1974 · Exported to MexicoN80383Beech D18S · S/N A-283Cancelled Dec 3, 1973 · Gibson George EN1876TPiper PA-28-140 · S/N 28-7225028Cancelled Oct 1, 1973 · Built 1971 · Martinez Juan Mjr/DBA Gateway Aviation CoN8995Stinson 108-3 · S/N 108-3881Cancelled Jun 7, 1973 · Exported to Colombia · Built 1948 · Finke Robert DN40224Piper PA-23-250 · S/N 27-7305023Cancelled Jun 6, 1973 · Exported to Mexico · Martinez Jusn M JrN9671GCessna U206F · S/N U20601871Cancelled Jan 23, 1973 · Exported to Mexico · Built 1972 · International Aero Enterprises IncN51NBeech D18S · S/N A434Cancelled Nov 15, 1972 · Gibson George E
Back to Laredo, TX