OpenAirDocs.org
Baltimore, MD

Cancelled registrations · 379

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 = 'MD' AND d.registrant_city = 'BALTIMORE'
  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.

N1080PPiper PA-23 · S/N 23-89Cancelled Jan 27, 1969 · Exported to Thailand · Built 1955 · Lyon Associates IncN172SBeech G18S · S/N BA-541Cancelled Jun 26, 1968 · D L Peterson TrustN8055ACessna 170B · S/N 20907Cancelled Apr 22, 1968 · Irvington Tool & Die CoN8163SCessna 150F · S/N 150-61763Cancelled Oct 2, 1967 · Exported to Denmark · International Industries IncN7735WPiper PA-28-180 · S/N 28-1743Cancelled Jul 30, 1965 · United Flying Service IncN46036Aeronca L-3 · S/N 058B-11553Cancelled May 22, 1965 · Smith Charles Herman JrN77921Luscombe 8A · S/N 3648Cancelled May 22, 1965 · Fannin Tommy RichardN23030Silvaire LUSCOMBE 8D · S/N 953Cancelled May 21, 1965 · Built 1939 · The Martin Flying Club IncN304EBeech J35 · S/N D-5640Cancelled May 21, 1965 · Built 1958 · Chesapeake Furniture Co IncN4058AConsolidated L5E1 · S/N 44-18167Cancelled May 20, 1965 · Civil Air PatrolN4265EAeronca 11CC · S/N 11CC-148Cancelled May 20, 1965 · Kollinger William F JrN4569HPiper PA-15 · S/N 15-343Cancelled May 20, 1965 · Stirn Louis FN5156BBell 47J · S/N 1716Cancelled May 20, 1965 · Chesapeake Potomac Airways IncN51875Fairchild M-62A · S/N T43-5029Cancelled May 20, 1965 · Built 1945 · Paige John WN7170DPiper PA-18 · S/N 18-5628Cancelled May 20, 1965 · United Flying Service IncN18881Aeronca K · S/N K-143Cancelled May 18, 1965 · Nye Theron GN1098BMooney M20A · S/N 1324Cancelled Mar 15, 1965 · Mary Elizabeth BrewerN40400Martin 202 · S/N 9123ACancelled Feb 12, 1965 · Built 1947 · Martin Marietta CorpN7341YPiper PA-30 · S/N 30-391Cancelled Sep 18, 1964 · Martin FoxN69551Stinson V77 · S/N 77-236Cancelled Mar 10, 1964 · Built 1948 · Garove Francis PN42301Piper J3C-65 · S/N 14551Cancelled Jan 7, 1964 · Lenk Harry AlbertN2853ZPiper PA-22-160 · S/N 22-6849Cancelled Nov 6, 1963 · United Flying Service IncN3959ABeech C-45G · S/N 51-11638ACancelled Oct 1, 1963 · U S Air Force Of The National DefenseN9061RCessna 180B · S/N 50397Cancelled Apr 13, 1962 · Exported to Australia · Smith Robert SN3031EAeronca 7AC · S/N 7AC-6618Cancelled Apr 5, 1962 · Built 1946 · Scribner Walter E JrN1398VPiper J3C-65 · S/N 9419Cancelled Jun 13, 1960 · Civil Air Patrol IncN4733BCessna 180 · S/N 31631Cancelled Apr 28, 1960 · Exported to Mexico · Tinley FrederickN32227Stinson 10A · S/N 7876Cancelled Apr 26, 1960 · Built 1941 · Masters Robert DN42787Piper J3L-65 · S/N 15101Cancelled Apr 26, 1960 · Built 1945 · Martin Air Scouters Club InN4832APiper PA-22-150 · S/N 22-3985Cancelled Apr 26, 1960 · Precision Built Homes IncN1348BLuscombe 8E · S/N 5975Cancelled Aug 27, 1959 · Exported to Canada · Built 1948 · Weaver Chester MN26428Stinson 10 · S/N 7622Cancelled Apr 14, 1959 · Exported to Mexico · Frederick G TinleyN3960ABeech C-45G · S/N 51-11687Cancelled Oct 8, 1958 · US Air Force Of The National DefenseN33258Piper J3C-65S · S/N 5932Cancelled Aug 26, 1957 · Exported to Germany · Weaver Chester HN5352BCessna 182 · S/N 33352Cancelled May 20, 1957 · Austin Packing Co. IncN2075HEngineering & Research 415-C · S/N 2698Cancelled Dec 4, 1956 · Built 1946 · Gastall Thomas EN5413BCessna 182 · S/N 33413Cancelled Jul 25, 1956 · Exported to Liberia · Hinson Aviation CoN3529APiper PA-22 · S/N 22-1801Cancelled Jun 5, 1956 · Rosenstein R EugeneN46303Fairchild M-62A · S/N 8643AECancelled Jun 5, 1956 · Built 1945 · Truett Frank LeonardN913DStinson 108-2 · S/N 108-2913Cancelled Apr 30, 1956 · Charles W Purcell & Colwill Construction Co IncN46254Taylorcraft DCO-65 · S/N 0-4331Cancelled Mar 15, 1956 · Robinson John MurrayN39625Fleet 16B · S/N 643Cancelled Feb 28, 1956 · Built 1943 · Flying Seven ClubN99172Ercoupe 415-C · S/N 1795Cancelled Feb 28, 1956 · Built 1946 · Schulman LouisN36684Aeronca 65-TAL · S/N L1211TACancelled Feb 27, 1956 · White William Thomas EtalN6134KRepublic RC-3 · S/N 320Cancelled Feb 14, 1956 · Siwinski Walter BN72381Cessna 140 · S/N 9567Cancelled Feb 3, 1956 · Carter Richard GriffithN4517VBeech 35 · S/N D-1339Cancelled Dec 12, 1955 · Mclamore J TN22711Piper J3L-65 · S/N 2685Cancelled Nov 25, 1955 · Watkins Alton Lee And Dudley Winfield WN3700HEngineering & Research 415-C · S/N 4325Cancelled Nov 21, 1955 · Built 1946 · Foster Thomas R Et AlN69547Cessna T-50 · S/N 1289Cancelled Nov 15, 1955 · John Susi
Back to Baltimore, MD