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.

N26161Piper J3L · S/N 4084Cancelled Oct 3, 2020 · Revoked, canceled · Built 1940 · Carl Rena MN212PVDJI PHANTOM 4 PRO · S/N 07DDD750B12196Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Producers Video CorpN46412Fairchild M-62A · S/N T435479Cancelled May 15, 2020 · Revoked, canceled · Built 1943 · Hart Thomas EN55770Consolidated Vultee SNV-1 · S/N 5636Cancelled Apr 27, 2020 · Revoked, canceled · Built 1942 · Barnes Allen DN46417Piper J3C-65 · S/N 10257Cancelled Nov 19, 2019 · Revoked, pending cancellation · Built 1943 · Carl Harry RN708WBDJI PHANTOM 3 PROFESSION · S/N P76DCH27010355Cancelled Nov 4, 2019 · Registration expired, pending cancellation · University Of BaltimoreN88198Piper J3C-65S · S/N 15815Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Carl Rena MN9113EAeronca 11AC · S/N 11AC746Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Clark James AlbertN92366Piper J3C-65 · S/N 16825Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Hinson Avia CoN93986Engineering & Research ERCOUPE 415-C · S/N 1309Cancelled Jul 11, 2019 · Registration expired, pending cancellation · Built 1946 · Polski Randy BenedictN636TSDJI PHANTOM 3 PROFESSION · S/N P77DCD1-8010613Cancelled May 2, 2019 · Registration expired, pending cancellation · Spartana Stephen JN96MDEurocopter AS365N3 · S/N 6321Cancelled Mar 7, 2019 · Registration expired, pending cancellation · Built 1989 · Maryland State PoliceN46049Aeronca 0-58B · S/N 058B13694Cancelled Jan 24, 2019 · Revoked, canceled · Built 1944 · Hall Edwin HN9856WPiper PA-28-140 · S/N 28-23370Cancelled Jan 14, 2019 · Revoked, canceled · Built 1967 · Baltimore MotorsN97083Stinson 108-2 · S/N 1081083Cancelled Nov 17, 2018 · Revoked, canceled · Built 1946 · Packer TheodoreN690RUAero Commander 112 · S/N 33Cancelled Oct 27, 2018 · First renewal notice · Built 1973 · Shelton StevenN2156KLuscombe 8A · S/N 4883Cancelled Aug 24, 2018 · Second renewal notice · Built 1947 · Walker James CN666SAGrumman G-1159 · S/N 130Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1973 · Lowcountry Trading II LLCN510AGGrumman G-1159 · S/N 159Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1975 · Lowcountry Trading LLCN51583Fairchild M-62A · S/N T423756Cancelled May 18, 2018 · Revoked, canceled · Built 1942 · Hensley Everett PN724HTBell 214ST · S/N 28123Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1983 · US Leaseco IncN37927Piper J3C-65 · S/N 6712Cancelled Apr 5, 2018 · Revoked, canceled · Built 1941 · Strauss KennardN157STBarnard Stephen B RV-6 · S/N 20075Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 1991 · Kayberg Systems IncN6064KRepublic RC-3 · S/N 239Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1946 · Neubert Herman LN111JXBritish BAC 1-11 414/EG · S/N 163Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1969 · Northrop Grumman Systems CorpN10553Koenigsberg Douglas D SKY RANGER II · S/N SKR674Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Kayberg Systems IncN7439XCessna 172B · S/N 17247939Cancelled Nov 21, 2017 · Revoked, canceled · Built 1960 · Hopkin William RN84200Aeronca 7AC · S/N 7AC2891Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Taylor ClintonN89329Cessna 140 · S/N 8357Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Hollander Albert GN34507Aeronca 65-CA · S/N L14831Cancelled Nov 18, 2017 · Revoked, canceled · Built 1941 · Johnson Robert DN35757Piper J5A · S/N 5748Cancelled Nov 18, 2017 · Revoked, canceled · Built 1941 · Martin Flying ClubN3783VCessna 140A · S/N 15204Cancelled Nov 18, 2017 · Revoked, canceled · Built 1949 · Smith Robert SN23124Piper J3C-65 · S/N 2916Cancelled Oct 28, 2017 · Revoked, canceled · Built 1939 · Skylarks Flying Club IncN3024GForney F-1A · S/N 5718Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1960 · Polski Randy BN4246RSullivan L M / Franklin D W FST 1 · S/N 01Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1991 · Sullivan Larry MN135GBCessna 152 · S/N 15284103Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1979 · Buchanan Larry TerrenceN7480JPiper PA-28R-180 · S/N 28R-30838Cancelled Feb 4, 2017 · Revoked, canceled · Built 1968 · Flight Training IncN9975FPiper J-3 · S/N 42-9398Cancelled Jan 24, 2017 · Revoked, pending cancellation · Built 1942 · Marshall Clarence CN79MDEurocopter AS365N3 · S/N 6352Cancelled Jul 21, 2016 · Exported to Germany · Built 1990 · Maryland State PoliceN5806ACessna 172 · S/N 28406Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1956 · Ellis Clifford EN8651BCessna 172 · S/N 36351Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1957 · Jordan Werner LN20422Straub James S ROTORWAY EXEC · S/N 1823Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Abromavick Larry JN91560North American NAVION · S/N NAV-4-337Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1946 · Seymore Robert BN329LMMccahan Lawrence E NIEUPORT 24 · S/N 135Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1984 · Mccahan Lawrence EN70900Piper J3C-65 · S/N 17920Cancelled Dec 2, 2014 · Revoked, canceled · Howard W French Sch Of Avn IncN99743Ercoupe 415-C · S/N 2366Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1946 · Lemmer Geoffrey MichaelN908LCanadair CL-44D4 · S/N 17Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1962 · Wrangler Aviation IncN5021NGodfrey-Carl KR-2 · S/N CG-1Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Godfrey Carl GN4562WRockwell International 112TC · S/N 13052Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1976 · Amber Wings IncN4195YBellanca 8KCAB · S/N 291-77Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1977 · Harvey Nelson Charles
Back to Baltimore, MD