Pittsburgh, PA

Cancelled registrations · 380

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 = 'PA' AND d.registrant_city = 'PITTSBURGH'
  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.

N29647Taylorcraft BF · S/N 2488Cancelled Mar 23, 2018 · Revoked, canceled · Built 1940 · Burkhart Gilbert B JrN89176Cessna 140 · S/N 8190Cancelled Mar 16, 2018 · Revoked, canceled · Built 1946 · Szemanski Lawrence WN62PTWaters Peter T AVID BANDIT · S/N 1509ECancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1998 · Novodran Igor AN84834Aeronca 7AC · S/N 7AC-3550Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1946 · Dengler Joseph CN9200SBeech B24R · S/N MC-372Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1975 · Hall Brian FN6BFSchleicher ASW-20C · S/N 20832Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1985 · Dutka Leslie AN95MSHughes 369HS · S/N 1130536SCancelled Jan 24, 2018 · Registration expired, pending cancellation · Caribbean Fishing Co IncN447JRRocca John C 1600R · S/N 001Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Rocca John CN2750ALafean Earle B JR LOEHLE · S/N 001Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Lafean Earle B JrN99022Engineering & Research ERCOUPE 415-C · S/N 1645Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Parrish YancyN51346Fairchild M-62A · S/N T40-174Cancelled Nov 18, 2017 · Revoked, canceled · Built 1940 · Weigand RichardN30811Piper J4A · S/N 41234Cancelled Oct 28, 2017 · Revoked, canceled · Built 1940 · Pavlik George MN4476NHoward DGA-15P · S/N 710Cancelled Jul 10, 2017 · First renewal notice · Pittsburgh Institute Of AeronauticsN89625Cessna 152 · S/N 15282804Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1978 · Doyle ColinN172DGCessna 172N · S/N 17272124Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1978 · Hill Randall SN25TZGates Learjet 25D · S/N 364Cancelled May 16, 2017 · Exported to Venezuela · Built 1983 · Dolegowski AdamN52745Boeing A75 · S/N 75194Cancelled Feb 4, 2017 · Revoked, canceled · Built 1940 · Kanoza Edward HN8562GCessna 150F · S/N 15062662Cancelled Feb 4, 2017 · Revoked, canceled · Built 1966 · Stoecklein Carl TN9508YBeech 35-B33 · S/N CD-544Cancelled Sep 23, 2015 · First renewal notice · Built 1962 · Hoffman William JN43342Taylorcraft BC12-D · S/N 7001Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1946 · Kirin Peter P JN500CQGates Learjet 35A · S/N 620Cancelled Feb 9, 2015 · Exported to Mexico · Built 1986 · Cg Aviation LLCN711SGAero Commander 560-F · S/N 1054-21Cancelled Dec 2, 2014 · Revoked, canceled · Built 1961 · Gullo JosephN9768TPiper PA-38-112 · S/N 38-78A0197Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1978 · Lang Robert HN74NLPiper PA-31T · S/N 31T-7720010Cancelled Nov 18, 2014 · Registration expired, pending cancellation · National Leasing CorporationN757FNCessna 152 · S/N 15279706Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1977 · Monroeville Flyers IncN45PAExperimental Aircraft Assn EVANS VP-1 · S/N 258Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Experimental Acft Gtr Pitts Ch 45N4046WBalloon Works FIREFLY 5 · S/N 512Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1979 · Baldo James AN3722WPiper PA-32-260 · S/N 32-634Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1966 · Love Paul AN1103ZHughes 369C · S/N 900809DCancelled Sep 8, 2014 · Registration expired, pending cancellation · Built 1980 · Douglas Forrest WN1534WBalloon Works FIREFLY 7 · S/N 10209Cancelled Sep 8, 2014 · Sale reported, canceledN11RZZiesmer VOLKSPLANE · S/N VP222Cancelled Aug 28, 2014 · Registration expired, pending cancellation · Built 1972 · Ziesmer RichardN6676BCessna 310C · S/N 35776Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1958 · Fritz Robert HN8203RFalgiani Wayne E FA-1 · S/N FA-1Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Falgiani Wayne EN3822WPiper PA-32-260 · S/N 32-754Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1966 · Krotz Paul WN97594Cessna 172P · S/N 17276214Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1984 · Q Enterprises IncN6612BCessna 310B · S/N 35712Cancelled Aug 14, 2013 · Revoked, canceled · Built 1958 · Aghassy JacobN10506Cessna 150L · S/N 15074895Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1973 · Benkovich Joseph MN34NBBenson Donald G BENSON 791 · S/N 79001Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Benson Donald GN136GFColt Balloons 105-A · S/N 1060Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1987 · Aeronautic Ad Ventures IncN37166Balloon Works FIREFLY 7 · S/N F7-322Cancelled Jul 2, 2013 · Registration expired, pending cancellation · 181 IncN5661NMaule MX-7-235 · S/N 10019CCancelled Jul 1, 2013 · Registration expired, pending cancellation · Bryan Anthony J AN65700Lake LA-4-200 · S/N 605Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1974N8830ZCessna 172H · S/N 17255480Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1966 · Yuhaschek JoeN4055CCessna 310R · S/N 310R1359Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1978 · C William Berger & AssociatesN2783CRaven S-60A · S/N S60A-357Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1984 · WwjN59MDCessna 441 · S/N 441-0177Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1980 · Hyflight AssociatesN99TCLearjet 23 · S/N 098Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1966 · National Leasing CorporationN6518RBeech B19 · S/N MB-708Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1974 · Dickey & Davidson CorporationN6531QAlon A2 · S/N A-131Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1966 · Carrell William GN5720DPiper PA-22-150 · S/N 22-4418Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1956 · Dechambeau Richard E
Back to Pittsburgh, PA