OpenAirDocs.org
Pittsburgh, PA

Registered aircraft · 145

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'PA' AND g.registrant_city = 'PITTSBURGH'
  ORDER BY g.n_number"

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.

N103XGrob-Werke Gmbh And TWIN ASTIR · S/N 3045Built 1978 · Pittsburgh Soaring AssnN1061QPiper PA-32-260 · S/N 32-7200015Built 1977 · Lbdd Enterprises 61q LLCN10EEBeech V35B · S/N D-9307Built 1971 · Bucci DennisN12055Thorp T-18 · S/N 79Built 1974 · Twigg John MN129WYAB Sportine Aviacija LAK-17A · S/N 114Built 2000 · Harrison Edward IN131LFEurocopter Deutschland MBB-BK 117 C-2 · S/N 9096Built 2006 · West Penn Allegheny Foundation LLCN135ABBeech J35 · S/N D-5399Built 1957 · Shreds Aircraft LLCN13892Cessna 177B · S/N 17702475Built 1976 · Meyers Alexander CN138TWBeech V35B · S/N D-9647Built 1974 · Sulka Andrew MarkN142SSBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1368Built 1976 · Pittsburgh Soaring AssociationN1490DCessna 170A · S/N 20092Cole Daniel GN1525RFirefly Balloons FIREFLY 7-15 · S/N F7-2028Built 2003 · Emerald Shazam IncN15VHSchempp-Hirth DISCUS-2B · S/N 129Built 2002 · Lehmann Lawrence W EN1725TPiper PA-28-140 · S/N 28-7125036Built 1970 · Carrell William GN17350Ryan Aeronautical ST-A SPECIAL · S/N 192Built 1938 · Easudes JesseN1743LCessna 172S · S/N 172S10665Built 2008 · Air Inter LLCN17MQHiller UH-12C · S/N 787Pan Bar Aviation IncN20346Cessna 172M · S/N 17261209Built 1972 · Hendrych Mark GN205TGMooney M20J · S/N 24-3041Built 1987 · Le Garrec Jean-Dominique MN2118TPiper PA-28RT-201T · S/N 28R-7931083Built 1979 · Mein-Bar IncN2125TPiper PA-28R-200 · S/N 28R-7135068Basquit KennethN214PCEmbraer Executive EMB-500 · S/N 50000298Built 2012 · Fly Jpi LLCN2181SCessna T210L · S/N 21061142Built 1975 · Greer Kenneth RN2188RPiper PA-28-180 · S/N 28-5481Built 1969 · N2188r LLCN219DJDJI PHANTOM 3 PROFESSION · S/N P78DC123091996Civil & Environmental Consultants IncN219EBSensefly EBEE · S/N ER-02-13022Civil & Environmental Consultants IncN21GTCirrus Design SR22 · S/N 4450Built 2017 · Design Leasing Group LLCN227DWSchleicher ASW-27 · S/N 27200Built 2002 · Dutka Leslie AN237LPCirrus Design SR22T · S/N 2200Built 2020 · Gallatin Consulting Group LLCN24697Cessna 172S · S/N 172S10068Built 2005 · Ritton Air Company LLCN250BTPiper PA 46-350P · S/N 4636334Built 2002 · Heart Gate Enterprises LLCN2574Waco 9 · S/N 359Built 1926 · Historical Society Of Western PennsylvaniaN273CKJeffrey B Peterson LANCAIR 360 · S/N 525-320-263Built 2013 · Peterson Jeffrey BN2880NPiper PA-28-236 · S/N 28-7911223Roth HarryN28WGSchempp-Hirth DISCUS-2B · S/N 220Built 2006 · Geiger William DN303JFTL Ultralight Sro STINGSPORT · S/N TLUSA125Built 2005 · Becker Air Sales LLCN304MRCessna 560XL · S/N 560-5033Built 1999 · Mirric Entertainment LLCN310HCCessna 310R · S/N 310R0839Built 1976 · Glover David DN312FPCirrus Design SR22 · S/N 4069Built 2014 · Eger Aviation LLCN31VTPiper PA-28-180 · S/N 28-3208Built 1966 · Snediker Daniel GN3240TCessna 177 · S/N 17700540Built 1967 · Frena John AN340GWCessna 340A · S/N 340A0706Built 1979 · Three Rivers Limousine Service IncN3459KPiper PA-28-140 · S/N 28-23566Built 1967 · Carrell David WN3498NMooney M20F · S/N 680075Built 1967 · Bedard Timothy SN3511RCessna 172S · S/N 172S8880Built 2001 · William E Boyle LLCN3512FCessna 182J · S/N 18257512Built 1966 · Nourbakhsh Illah RN3512RStarlett J Garner ULTRALIGHT HELICOPTR · S/N 77777777Garner Starlett JN3626CCessna R182 · S/N R18200284Built 1978 · Cowey Kevin MN3678VCessna 120 · S/N 14952Built 1948 · Cowey Kevin MN3738HBalloon Works FIREFLY 6B · S/N F6B-001Built 1983 · Mccoy Timothy I
Back to Pittsburgh, PA