Lima, OH

Cancelled registrations · 77

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 = 'OH' AND d.registrant_city = 'LIMA'
  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.

N4235TPiper PA-28-180 · S/N 28-7205110Cancelled Jun 22, 1973 · Allen County Aviation IncN2144MPiper J3C-65 · S/N 20930Cancelled Nov 15, 1972 · Shingledecker James AN59360Bensen 8M-KCA · S/N 1Cancelled Dec 7, 1971 · Mccain Charles AN95404Boeing A75L3 · S/N 75-7954Cancelled Jan 4, 1971 · Carey Eldon EN40666Piper J3F-65 · S/N 7425Cancelled Dec 31, 1970 · Carey Eldon EN9040YPiper PA-31-310 · S/N 31-54Cancelled Feb 12, 1968 · Pangles IncN2937MPiper PA-12 · S/N 12-1342Cancelled Mar 7, 1967 · Exported to Canada · Zadra Harry SN36387Taylorcraft DF-65 · S/N 4128Cancelled May 20, 1965 · Built 1942 · Mcclellan C R/Mitchell H T/Sifrit PaulN2461MPiper PA-12 · S/N 12-1544Cancelled Jul 12, 1956 · Floyd A De LongN95022Taylorcraft BC12-D · S/N 9422Cancelled Feb 27, 1956 · Nevergall Jack WN46808Cessna T-50 · S/N 5099Cancelled Nov 18, 1955 · Artkraft Manufacturing CoN9421EAeronca 11AC · S/N 11AC-1058Cancelled Nov 17, 1955 · Built 1946 · Mcdonald Donald SN20028Piper J-2 · S/N 1828Cancelled Oct 19, 1955 · John E PhillipsN9614HConsolidated Vultee BT-13A · S/N 3539Cancelled Oct 18, 1955 · Mcdonald Donald SN53645Fairchild M-62A · S/N T43-7229Cancelled Oct 13, 1955 · Built 1943 · Overmyer BruceN63735Fairchild M-62C(PT-23A) · S/N 2813AECancelled Oct 13, 1955 · Nichols L LN9673HConsolidated Vultee BT-15 · S/N 8986Cancelled Oct 6, 1955 · Moser Carl IN37204Interstate S-1A · S/N 47Cancelled Dec 16, 1954 · Lee Robert EN3357VBeech 35 · S/N D-822Cancelled Apr 22, 1952 · Noll Machinery Sales & ServiceN2089EAeronca 7AC · S/N 7AC-5658Cancelled Mar 4, 1952 · Lima Aviation CorpN3990VCessna 170 · S/N 18309Cancelled Nov 23, 1951 · Lima Aviation CorpN8493KStinson 108-1 · S/N 108-1493Cancelled Nov 21, 1951 · Lima Aviation CorpN54709Fairchild M-62A-3 · S/N T43-7021Cancelled Oct 17, 1951 · Moris Harold LN93554Ercoupe 415-C · S/N 877Cancelled May 5, 1949 · Built 1946 · Pike FredN33434Piper J4A · S/N 1376Cancelled Sep 17, 1948 · Harry G Shook JrN168HBrunner-Winkle BIRD A · S/N 1022Cancelled Jul 11, 1930 · Built 1929 · Thompson Rollie EN663Curtiss JN4D · S/N A-1494Cancelled Jan 19, 1928 · Thompson Re
Back to Lima, OH