Lawrence, KS

Cancelled registrations · 70

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 = 'KS' AND d.registrant_city = 'LAWRENCE'
  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.

N9552MMooney M20F · S/N 670129Cancelled Jun 18, 1968 · Erhart Flying Service IncN83447Aeronca 7AC · S/N 7AC-2114Cancelled Jun 5, 1965 · Erhart Spraying Service IncN84953Aeronca 7AC · S/N 7AC-3676Cancelled Jun 5, 1965 · Erhart Spraying Service IncN89945Cessna 140 · S/N 8997Cancelled Jun 5, 1965 · Erhart Delbert FN2846ACessna 180 · S/N 30046Cancelled May 22, 1965 · Erhart Flying ServiceN9413ZBeech C-45H · S/N 52-10909RCancelled May 21, 1965 · University Of KansasN61284Sikorsky R-6A · S/N 43-45406ACancelled May 20, 1965 · Kansas UniversityN7970TCessna 175A · S/N 56670Cancelled May 20, 1965 · Erhart Flying Service IncN5920BCessna 182A · S/N 33920Cancelled Nov 7, 1963 · Bodle John AN54598Taylorcraft L-2M · S/N L-5791Cancelled May 11, 1960 · Wegner Vinson LN8712KStinson 108-1 · S/N 108-1712Cancelled Jun 23, 1958 · Built 1947 · Lipp Marvin LN1943MConsolidated Vultee L-13 · S/N 47-301Cancelled Jun 6, 1955 · Built 1953 · University Of Kansas Aeronautical Engineering DeptN1785DCessna 170B · S/N 20351Cancelled Apr 8, 1955 · Exported to New Zealand · Erhart Delbert FN50484Cessna T-50 · S/N 5070Cancelled Feb 3, 1949 · Morgan Mack Motor CoN48461Ryan Aeronautical ST3KR · S/N 1921Cancelled Oct 27, 1948 · Morgan Mack Motor CoN10039American Eagle 101 · S/N 320Cancelled Aug 1, 1939 · George T HarrisN931Allison LAIRD COMMERCIAL · S/N 101Cancelled Feb 15, 1937 · Built 1927 · Allison L MN964HMoth 60-GM · S/N 64Cancelled Jul 17, 1935 · Built 1929 · Allison L MN4704Bird Wing Commercial Acft BIRD WING · S/N 2Cancelled Jun 9, 1932 · Built 1928 · Hahn DonaldN5840American Eagle 101 · S/N 231Cancelled Feb 9, 1932 · Built 1928 · Wells William H
Back to Lawrence, KS