OpenAirDocs.org
Welsh, LA

Cancelled registrations · 37

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 = 'LA' AND d.registrant_city = 'WELSH'
  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.

N2538QInfinity Power Parachutes CLASSIC · S/N IPP5-309Cancelled Mar 7, 2026 · Sale reported, canceled · Built 2005N1509EAir Tractor AT-502 · S/N 502-0145Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1991 · Robertson Jack SN2481FMini-Max 1500R SPORT · S/N 18521878Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Leblanc Max WN7203Grumman Acft ENG Cor-Schweizer G-164A · S/N 891Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1972 · Lyon Flying Service IncN17AGRoche Daniel J AEROMASTER · S/N AM 93001Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1993 · Roche Daniel JN501YGrumman G-164 · S/N 218Cancelled Mar 19, 2013 · Registration expired, pending cancellation · Built 1963 · Lyon Flying Svc IncN917XGrumman G-164A · S/N 436Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1967N7954Grumman G-164A · S/N 833Cancelled Nov 6, 2012 · Sale reported, pending cancellation · Built 1971N6632KGrumman Acft ENG Cor-Schweizer G-164C · S/N 12CCancelled Aug 14, 2012 · First renewal notice · Built 1978 · Lyon Flying Service IncN70474Cessna A188B · S/N 18801927TCancelled Aug 18, 2009 · Triennial form not returned · Built 1974 · Lyon Flying Svc IncN4796Grumman Acft ENG Cor-Schweizer G-164A · S/N 1100Cancelled Aug 16, 2007 · Triennial form not returned · Built 1973 · Lyon Flying Service IncN4874ACessna A152 · S/N A1520903Cancelled Sep 2, 1994 · Exported to Australia · Lyon Flying Service IncN21737Cessna A188B · S/N 18800993TCancelled Mar 25, 1991 · Triennial form not returned · Lyon Flying Service IncN94014Wsk-Pzl-Mielec PZL-M-18 · S/N 1Z00704Cancelled Mar 18, 1991 · Exported to Mexico · Lyon Flying Service IncN5085Grumman Acft ENG Cor-Schweizer G-164A · S/N 1120Cancelled Mar 12, 1991 · Exported to Sweden · Lyon Flying Service IncN6714QGrumman Acft ENG Cor-Schweizer G-164A · S/N 1708Cancelled Jan 22, 1986 · Exported to Mexico · Lyon Flying Service IncN6790KGrumman Acft ENG Cor-Schweizer G-164B · S/N 480BCancelled Dec 18, 1985 · Exported to Mexico · Lyon Flying Service IncN6585Grumman G-164A · S/N 668Cancelled Nov 15, 1985 · Exported to Mexico · Lyon Flying Service IncN6635QGrumman G-164A · S/N 1691Cancelled Jun 7, 1985 · Exported to Mexico · Lyon Flying Service IncN4852YPiper PA-25-235 · S/N 25-4652Cancelled Sep 27, 1982 · Built 1968 · Lyon Flying Service IncN9586PPiper PA-25-235 · S/N 25-7405713Cancelled Sep 16, 1982 · Administratively canceled · Lyon Flying Service IncN5352Grumman G-164A · S/N 632Cancelled Aug 10, 1982 · Exported to Mexico · Lyon Flying Service IncN5473Grumman G-164A · S/N 1171Cancelled Aug 15, 1980 · Exported to Uruguay · L & R Flying Service IncN4460QCessna A188B · S/N 18800860Cancelled Jul 28, 1980 · Built 1972 · Lyon Flying Service IncN4985YPiper PA-25-235 · S/N 25-4792Cancelled Apr 12, 1979 · Exported to Australia · Built 1968 · Lyon Flying Service IncN4239Schweizer G164A · S/N 1009Cancelled Aug 22, 1978 · Exported to Nicaragua · Built 1972 · Lyon Flying Service IncN7782ZPiper PA-25-235 · S/N 253984Cancelled Apr 24, 1978 · Exported to France · Lyon Flying Service IncN6549Schweizer G164A · S/N 687Cancelled Sep 16, 1975 · Exported to Nicaragua · Lyon Flying Service IncN5316Grumman G-164A · S/N 602Cancelled Aug 28, 1973 · Exported to Nicaragua · Lyon Flying Service IncN1101CBrantly B-2 · S/N 66Cancelled Apr 25, 1969 · Exported to Canada · Built 1960 · Lyon Flying Service IncN693YGrumman G-164 · S/N 244Cancelled Jul 21, 1967 · Exported to Mexico · Lyon Flying Service IncN4513NBoeing A75 · S/N 75-6843Cancelled Jul 27, 1966 · Ronald D TaylorN624UGrumman G-164 · S/N 360Cancelled Aug 9, 1965 · Exported to Guatemala · Lyon Flying Service IncN601UGrumman G-164 · S/N 330Cancelled Jul 31, 1965 · Exported to Mexico · Lyon Flying Service IncN3694EAeronca 11AC · S/N 11AC-1851Cancelled Nov 27, 1955 · Ralph R LyonN88398Piper J3C-65 · S/N 16016Cancelled Oct 23, 1951 · Hewitt Earl JN2363KLuscombe 8A · S/N 5090Cancelled May 26, 1949 · Welsh Sales And Flying School
Back to Welsh, LA