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.

N93162Glenn L Martin MARTIN 303 · S/N 9222Cancelled Jan 6, 1948 · The Glenn L Martin CoN91480North American NAVION · S/N NAV-4-281Cancelled Oct 23, 1947 · E M Fleischmann Lumber CorpN24969Piper J3L · S/N 3580Cancelled Sep 29, 1947 · Built 1939 · Gribble M RN824NPitcairn PA-6 · S/N 58Cancelled Apr 13, 1944 · Butler EdwardN33981Taylorcraft BC12-65 · S/N 2833Cancelled May 18, 1943 · Exported to Mexico · Samuel M HechtN17909Piper J-2 · S/N 1509Cancelled Feb 22, 1943 · Robinson Jr John MN12128Stinson JR. S · S/N 8208Cancelled Nov 15, 1939 · Built 1932 · Whipp Robert WhippN10033Driggs SKYLARK 3 · S/N 17Cancelled Mar 15, 1939 · Built 1929 · Smith Charles WN947MDehavilland DH-60G MOTH · S/N 1084Cancelled Sep 15, 1938 · Welsh Michael CN759MCurtiss-Robertson ROBIN C-1 · S/N 662Cancelled Sep 9, 1938 · Built 1929 · Burall W LN16302Piper J-2 · S/N 535Cancelled Apr 15, 1938 · Baltimore Flying Service IncN349MCessna CG-2 · S/N 46Cancelled Feb 1, 1937 · Becker HaroldN10184Aeronca C-2 · S/N A-60Cancelled Dec 1, 1934 · White Edwin HN2392Southern Eable Aviation Club MODEL A · S/N 1Cancelled Aug 31, 1934 · Southern Eagle Aviation ClubN11439Waco QDC · S/N 3501Cancelled Mar 24, 1933 · Exported to Panama · Built 1931 · Carroll John GN9195New Standard D-29A · S/N 1001Cancelled Jan 29, 1932 · Leidner Charles YN4016Travel Air Mfg 2000 · S/N 127Cancelled Nov 1, 1931 · Tidewater Air Lines IncN1154Curtiss JN4C · S/N 1125Cancelled Feb 17, 1931 · The United Flying ClubN9361Doyle 0-2 · S/N A-6Cancelled Jul 18, 1930 · Doyle Aero CorpN2488Doyle 0-2 · S/N A5Cancelled May 7, 1930 · Doyle Aero CorpN2785Curtiss JN-4 (CANADIAN) · S/N BG 2Cancelled May 7, 1930 · Gordon Basil/Monumental Aircraft CoN3004Doyle 0-2 · S/N A-4Cancelled May 7, 1930 · Doyle Aero CorpN1871Aeromarine Plane And Motor 40 · S/N 248Cancelled Apr 30, 1930 · Built 1927 · Alder ChristainN4153Curtiss Wright JN4C · S/N 1134Cancelled Mar 20, 1930 · Leach JohnN653KCessna DC-6A · S/N 230Cancelled Mar 14, 1930 · Curtiss Flying Service Of The East IncN3003Doyle 0-2 · S/N A-3Cancelled Jul 10, 1929 · Doyle Aero CorpN46414Piper J-3 · S/N 10257Cancellation date not recorded · Stecker Merrick CN6993SCessna 150H · S/N 15067693Cancellation date not recorded · Arundel Aviation IncN80756Globe GC-1A · S/N 159Cancellation date not recorded · Mergenthaler Vocational Technical High School
Back to Baltimore, MD