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.

N42430Piper J3C-65 · S/N 14694Cancelled Aug 11, 1981 · Built 1945 · Howard W French School Of Aviation IncN5092PCessna 152 · S/N 15284874Cancelled Feb 26, 1981 · Exported to Venezuela · Stephenson Aviation IncN52705Cessna 172P · S/N 17274586Cancelled Feb 17, 1981 · Exported to Dominican Republic · Stephenson Aviation IncN182ATCessna 182P · S/N 18261994Cancelled Sep 22, 1980 · Exported to Canada · Built 1973 · Thieblot Armand J JrN1468WBell 47G-5 · S/N 7934Cancelled May 10, 1979 · Exported to Costa Rica · Chesapeake And Potomac Airways IncN30408Piper J4A · S/N 4-1188Cancelled Mar 14, 1979 · Roskam Milton CN5382LPiper PA-28-180 · S/N 284689Cancelled Mar 10, 1978 · Mills Charles GN60BHHobbs EVANS VP-2 · S/N 1938Cancelled Jan 21, 1977 · Hobbs William MN59825Piper PA-31-350 · S/N 31-7652076Cancelled Jan 12, 1977 · Baltimore Contractors IncN9976LGrumman American Avn. AA-1B · S/N AA1B-0276Cancelled May 28, 1976 · Built 1973 · Friendship Flying Assoc IncN6321LAmerican AA-1B · S/N AA1B-0021Cancelled May 26, 1976 · Friendship Flying Associates IncN5948ZPiper PA-22-108 · S/N 22-9819Cancelled May 25, 1976 · Kasinoff Harvey AN254Stuhl MIDGET MUSTANG-1 · S/N 1Cancelled Jul 21, 1975 · Stuhl John HN3386JCessna 150G · S/N 15066086Cancelled Apr 7, 1975 · Flight Training IncN301HGlasflugel H 301 B LIBELLE · S/N 66Cancelled Jan 8, 1975 · Built 1968 · Chapin Vernon S Et AlN157RCessna 310 · S/N 35196Cancelled Dec 6, 1974 · Flight Training IncN17775Spicer B-8M · S/N 1Cancelled Apr 22, 1974 · Spicer William HN2411BGlobe GC-1B · S/N 3711Cancelled Mar 22, 1974 · Yenelavage Charles TN78985Mooney M20C · S/N 2019Cancelled Mar 12, 1974 · Fuller Perry WilliamN3500GWolf Hirth LO-150 · S/N 15Cancelled Feb 11, 1974 · Built 1959 · Mccray Byron ScottyN1959TPiper PA-28-180 · S/N 28-7105195Cancelled May 29, 1973 · Metropolitan Air IncN2724RDouglas DC3A · S/N 14038Cancelled Sep 15, 1972 · Exported to Canada · Aflc IncN6008DPiper PA-22-150 · S/N 22-4660Cancelled Aug 14, 1972 · Pennock Michael T Mary M PennockN86018Cessna T337D · S/N 337-1053Cancelled Aug 14, 1972 · Alan E Barton IncN1670QCessna 150L · S/N 150-72970Cancelled Jun 17, 1972 · Hinson Airways IncN1253KLuscombe 8A · S/N 3980Cancelled Jun 14, 1972 · Exported to Canada · Built 1946 · Hatfield Paul LN9054YPiper PA-31 · S/N 31-77Cancelled May 8, 1972 · Exported to Canada · Built 1967 · Commercial Credit Industrial CorpN6426FCessna 150F · S/N 15063026Cancelled May 3, 1972 · Maskeroni AlfredN5225SPiper PA-32-260 · S/N 32-18Cancelled Dec 3, 1971 · Arundel Aviation IncN2941RPiper PA-28R-200 · S/N 28R-35335Cancelled Nov 30, 1971 · Built 1969 · Hunter Robert EN58179Laister-Kauffman LK-10A · S/N 130Cancelled Sep 25, 1971 · Brennan Joseph SN6319Dornier DO 28 D-1 · S/N 4019Cancelled Jul 15, 1971 · Exported to Mexico · Built 1968 · Commercial Credit Equipment CorpN4502QCessna 402A · S/N 402A0002Cancelled Jul 13, 1971 · Exported to Indonesia · Commercial Credit Industrial CorpN2575APiper PA-22-135 · S/N 22-867Cancelled Jun 16, 1971 · Exported to Canada · Argue Mary WN993SADehavilland DHC-6 · S/N 199Cancelled Jun 7, 1971 · Exported to France · Built 1969 · Allegheny Leasing & Financial CorpN25DEmons HP-10 · S/N 2Cancelled Mar 22, 1971 · Built 1961 · Wolff Stephen SN73316Fairchild M-62A-3 · S/N FX-170Cancelled Feb 8, 1971 · Packer HelenN911SACessna 402A · S/N 402A0038Cancelled Jan 7, 1971 · Exported to Kenya · Built 1969 · Hinson Airways IncN8149ACessna 170B · S/N 25001Cancelled Dec 31, 1970 · Built 1952 · Greer Joel C JrN3052QCessna 182K · S/N 18258052Cancelled Dec 29, 1970 · Gypsum Haulage IncN42001Piper J5C · S/N 5-1389Cancelled Dec 7, 1970 · Abraham StrongN2696EAeronca 7AC · S/N 7AC-6276Cancelled Oct 16, 1970 · Built 1946 · Bartgis William TN3546UCessna 182F · S/N 18254946Cancelled Sep 8, 1970 · Menhaden Flying Service IncN95812Taylorcraft BC12-D · S/N 8112Cancelled Sep 8, 1970 · Thomas Elmer LeroyN832RBeech 35-33 · S/N CD-4Cancelled Jul 13, 1970 · Hankey RobertN1505YCessna 172C · S/N 172-49205Cancelled Jun 29, 1970 · Built 1962 · N C O Flying Club IncN79852Mooney M20E · S/N 516Cancelled Jun 25, 1970 · Rossville Vending Machine CorpN4524QCessna 402A · S/N 402A0024Cancelled Jun 17, 1970 · Commercial Credit Industrial CorpN5512ACessna 170B · S/N 25234Cancelled Jun 8, 1970 · Marcus LouisN2711AStinson L-5G · S/N 120471Cancelled Jun 5, 1970 · Civil Air Patrol Inc
Back to Baltimore, MD