OpenAirDocs.org
Reading, PA

Cancelled registrations · 100

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 = 'PA' AND d.registrant_city = 'READING'
  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.

N2570HPiper PA-18-150 · S/N 18-7909199Cancelled Oct 30, 1979 · Exported to Canada · Reading Aviation ServiceN33370Piper PA-28-140 · S/N 28-7525179Cancelled Apr 26, 1978 · Exported to Canada · Built 1975 · Reading Aviation Service IncN9586KPiper PA-32R-300 · S/N 32R-7680231Cancelled Apr 26, 1976 · Exported to Sweden · Reading Aviation Service IncN33109Piper PA-28-140 · S/N 28-7525155Cancelled Apr 22, 1976 · Exported to Canada · Built 1975 · Reading Aviation Service IncN7844CPiper PA-28-140 · S/N 28-7625086Cancelled Apr 15, 1976 · Reading Avaition Service IncN32778Piper PA-28-140 · S/N 28-7525112Cancelled Jan 12, 1976 · Exported to Canada · Built 1974 · Reading Aviation Service IncN40976Piper PA-28-151 · S/N 28-7415124Cancelled Nov 12, 1975 · Exported to Canada · Built 1974 · Reading Aviation Service IncN54448Piper PA-28R-200 · S/N 28R7435106Cancelled Jun 24, 1975 · Exported to Sweden · Reading Aviation Service IncN32009Piper PA-28-180 · S/N 28-7505015Cancelled Jun 5, 1975 · Exported to Sweden · Built 1974 · Reading Aviation Service IncN1478PPiper PA-23 · S/N 23-545Cancelled May 16, 1975 · Public Aviation IncN40762Piper PA-28-140 · S/N 28-7425159Cancelled Nov 8, 1974 · Built 1973 · Reading Aviation Service IncN5779WPiper PA-28-150 · S/N 28-1649Cancelled May 15, 1974 · Steinmeyer William LN30511Piper J3L-65 · S/N 4886Cancelled Jun 21, 1973 · Built 1940 · Behney William BN6965UMooney M20E · S/N 325Cancelled Apr 28, 1972 · Built 1964 · Berks Flight Associates IncN95474Piper PA-28-140 · S/N 28-25982Cancelled Feb 9, 1972 · Reading Aviation Service IncN2965RPiper PA-28R-200 · S/N 28R-35350Cancelled Feb 4, 1972 · Built 1969 · Commercial Credit Equipment CorpN5769LAmerican AA-1 · S/N AA1-0169Cancelled Jan 28, 1972 · Perkiomen Airways LtdN8911JPiper PA-28-180 · S/N 28-2892Cancelled Jun 26, 1970 · Reading Aviation Service IncN5230YPiper PA-23-250 · S/N 27-2282Cancelled Jun 18, 1970 · Reading Aviation Service IncN5368LPiper PA-28-180 · S/N 28-4674Cancelled Jun 18, 1970 · Reading Aviation Service IncN42637Piper J3C-65 · S/N 14928Cancelled Jun 17, 1970 · Reading Aviation Service IncN5869CBeech D18S · S/N A-570Cancelled Feb 6, 1968 · Reading Aviation Service IncN2241HForney 415-C · S/N 2864Cancelled Jul 17, 1967 · Exported to Canada · Ciesla JoeN7451RPiper PA-28-140 · S/N 28-21995Cancelled Jul 11, 1967 · Reading Aviation Service IncN4850KRyan NAVION · S/N NAV-4-1850Cancelled Nov 4, 1963 · Reading Aviation Service IncN8885DPiper PA-18A 150 · S/N 18-6355Cancelled Nov 10, 1959 · Exported to Canada · Reading Aviation ServiceN3687VCessna 140 · S/N 14963Cancelled Oct 10, 1958 · Exported to Canada · Scioli Alfred RN51946Fairchild M-62A · S/N T43-5885Cancelled Jun 23, 1958 · Stickler Associates IncN58170Fairchild M-62A-3 · S/N T42-1965Cancelled Feb 14, 1956 · Holsclaw RobertN9690KStinson 108-2 · S/N 108-2690Cancelled Aug 6, 1953 · Melvin T JamesN90009Cessna 140 · S/N 9063Cancelled Jun 2, 1953 · Reading Aviation Service IncN9015ACessna 170A · S/N 18770Cancelled Mar 6, 1953 · Reading Aviatoin Service IncN91660North American NAVION A · S/N NAV-4-163Cancelled Feb 4, 1953 · Aviation Consultants IncN64512Consolidated Vultee BT-13A · S/N 6417Cancelled Mar 5, 1952 · Reading Aviation Service IncN4809KRyan NAVION · S/N NAV-4-1809Cancelled Jun 3, 1949 · Aviation Consultants IncN91749North American NAVION · S/N NAV-4-177Cancelled Apr 29, 1949 · Exported to Uruguay · Aviation Consultants IncN93500Ercoupe 415-C · S/N 823Cancelled Aug 18, 1948 · Reading Aviation Service IncN4175Travel Air 4000 · S/N 347Cancelled Jul 13, 1948 · Built 1928 · Bennett Joe HN89722Cessna 140 · S/N 8771Cancelled Mar 30, 1948 · Kunzig FredrickN416KFleet 2 · S/N 139Cancelled Feb 2, 1948 · Loose Walter MN649WAeronca C-2 · S/N 29Cancelled May 16, 1941 · Breithaupt R HardingN428MStinson SM-8A · S/N 4026Cancelled Sep 1, 1940 · Mull Leon Et AlN838KGreat Lakes 2T-1A · S/N 99Cancelled Nov 5, 1934 · Henninger John HN2097Waco 9 · S/N 130-4Cancelled Jul 11, 1934 · Built 1926 · Lamm Edwin T JrN9546Waco ASO · S/N A-53Cancelled Apr 8, 1932 · Built 1929 · Smith Oscar P Et AtN1683Curtiss JN4D · S/N I-568Cancelled Apr 30, 1930 · Owen Allen KN6808Waco 10 · S/N 1675Cancelled Jun 7, 1929 · Hain-Spatz Motor CoN2556Curtiss Wright JN4C · S/N 130-ACancelled Oct 22, 1928 · Larm Edwin T JrN1655Pitcairn PA-3 OROWING · S/N 17Cancelled Aug 1, 1928 · Owen Allen KN4534Travel Air 2000 · S/N 389Cancellation date not recorded · Reading Airplane Co
Back to Reading, PA