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.

N17901Taylor J-2 · S/N 1501Cancelled Oct 20, 1955 · Built 1937 · Klair Howard PN9483HBoeing N2S-5 · S/N 75-8473Cancelled Oct 19, 1955 · Flying AdsN9490HBoeing N2S-5 · S/N 75-8538Cancelled Oct 19, 1955 · Hale William YN1397VPiper J3C-65 · S/N 13420Cancelled Oct 18, 1955 · Civil Air Patrol IncN1223EAeronca 7AC · S/N 7AC-4781Cancelled Oct 17, 1955 · Howard W French School Of Aviation IncN1666MHoward NH-1 · S/N 29525Cancelled Oct 17, 1955 · Fisher Stanley LN6613KRepublic Aviation Corp USA SEABEE RC-3 · S/N 886Cancelled Oct 17, 1955 · Speer J Ramsay JrN74672Fairchild PT-26B · S/N FZ254Cancelled Oct 12, 1955 · Jack R AtkinsonN4313EAeronca 11CC · S/N 11CC-179Cancelled Oct 5, 1955 · Built 1948 · Diffendall Charles AN6227KRepublic RC-3 · S/N 426Cancelled Aug 11, 1955 · Maryland Wing Civil Air Patrol IncN1393VBoeing E75 · S/N 75-5549Cancelled Jun 27, 1955 · Exported to Mexico · Civil Air PatrolN74385Bellanca 14-13-2 · S/N 1498Cancelled May 23, 1955 · Exported to Ecuador · Holdt Donald HN9145EAeronca 11AC · S/N 11AC-780Cancelled Apr 29, 1955 · Built 1946 · The C W Flying Service CorpN41894Eshelman WINGLET EF 95 · S/N 101Cancelled Mar 4, 1955 · Cheston L EshelmanN46407Fairchild M-62A · S/N T43-5407Cancelled Dec 28, 1954 · Oriole Flying Service IncN18587Cessna T-50 · S/N 3990Cancelled Aug 18, 1954 · Suiter Harold GN46221Ryan Aeronautical ST3KR · S/N 2189Cancelled May 13, 1954 · S & J Of BaltimoreN72048Luscombe 8A · S/N 3475Cancelled Jan 26, 1954 · Aero Flying Club Of BaltimoreN1676EAeronca 7AC · S/N 7AC-5243Cancelled Dec 3, 1953 · Exported to Chile · Built 1946 · The C-W Flying Service CorpN9809KStinson 108-2 · S/N 108-2809Cancelled Nov 27, 1953 · Exported to Chile · John E And Mary K SissonN32453Cessna C-165 · S/N 586Cancelled Jul 29, 1953 · Atlantic Aircraft Dist IncN2298EAeronca 7AC · S/N 7AC-5872Cancelled May 15, 1953 · Atlantic Aircraft Distributors IncN92125Piper J3C-65 · S/N 16564Cancelled Oct 28, 1952 · Herrell Preston LN80335Beech D18S · S/N A-245Cancelled Sep 24, 1952 · Exported to Canada · Built 1946 · Mathieson Chemical CorpN92835Eshelman WINGLET EF 95 · S/N 3Cancelled Sep 12, 1952 · Whiteford John HN55375Boeing A75N1 · S/N 75-2693Cancelled Dec 27, 1951 · Built 1942 · Fitchett Thomas S JrN5110CBeech B35 · S/N D-2393Cancelled Nov 21, 1951 · Harbor Sales Co IncN4843HPiper PA-17 · S/N 17-142Cancelled Nov 15, 1951 · Martin Hiram LindsayN93456Ercoupe 415-C · S/N 779Cancelled Aug 14, 1951 · Silverthorne Jesse WN92993Commonwealth 185 · S/N 1727Cancelled Jun 7, 1951 · Miller SeymourN8529ABeech A35 · S/N D-1951Cancelled May 2, 1951 · G Bernard Fenwick JrN1632VCessna 140 · S/N 13804Cancelled Sep 5, 1950 · Foxwell Russell GN95438Cessna T-50 · S/N 6290Cancelled Jun 1, 1950 · Gaidis Henry VN94HCurtiss Wright ROBIN C-1 · S/N 464Cancelled Mar 13, 1950 · Allen John GN16275Aeronca LB · S/N 2022Cancelled Nov 3, 1949 · Edwards Charles RN98176Piper J3C-65 · S/N 18338Cancelled Aug 30, 1949 · United Flying Service IncN80293Culver V · S/N V-212Cancelled May 25, 1949 · Built 1946 · National Airmotive CorpN91919Piper J3C-65 · S/N 16334Cancelled May 3, 1949 · United Flying Service IncN51704Fairchild M-62A · S/N T42-1504Cancelled Feb 15, 1949 · Jones WalterN54307Cessna T-50 · S/N 2694Cancelled Dec 22, 1948 · Eck William A & Gaidis Henry VN55764Cessna T-50 · S/N 1928Cancelled Dec 16, 1948 · Rydstrom H W JrN51708Ryan Aeronautical PT-22 · S/N 1693Cancelled Nov 24, 1948 · Wagner Hugh E/Schneebeli Endre EN51709Fairchild PT-19A · S/N T42-1916Cancelled Nov 19, 1948 · Built 1942 · Wagner Hugh EN30097Howard NH-1 · S/N 885Cancelled Oct 27, 1948 · National Airmotive CorpN80299Culver V · S/N V-218Cancelled Aug 13, 1948 · Built 1946 · Murphy Thomas O And Farris James LN2062Boyd Brothers BOYD C · S/N 3Cancelled Jul 12, 1948 · Built 1932 · Boyd C M EtalN3666HErco 415-C · S/N 4291Cancelled Jun 22, 1948 · Atlantic Aircraft Distributors IncN8860Travel Air 2000T · S/N 912Cancelled Apr 20, 1948 · Green Robert Green Richard & Walton EugeneN13882Aeronca C-3 · S/N A-304Cancelled Apr 5, 1948 · Moreno NickN10832Stinson JR. S · S/N 8025Cancelled Mar 31, 1948 · Baxter Sr Gladison R
Back to Baltimore, MD