West Mifflin, PA

Registered aircraft · 55

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 = 'WEST MIFFLIN'
  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.

N12144Cessna 310A · S/N 31038118Built 1958 · Pittsburgh Institute Of AeronauticsN1232KCessna 340A · S/N 340A1815Built 1984 · Corporate Air LLCN132DAeropro CZ S R O A240 · S/N 59120Built 2020 · Obruba Gerard BN1392SCessna 182P · S/N 18264953Built 1976 · Abc Flying Club IncN1DUBeech D50C · S/N DH-262Built 1960 · Pittsburgh Institute Of AeronauticsN20274Cessna 177B · S/N 17702653Built 1977 · Abc Flying Club IncN2104APiper PA-22-135 · S/N 22-560Built 1952 · Pittsburgh Institute Of AeronauticsN22307Cessna 150H · S/N 15068207Built 1968 · Martin David ON2XDPittsburgh Inst Of Aeronautics BAKENG DOUBLE DUCE · S/N 78-1Built 1979 · Pittsburgh Institute Of AeronauticsN304MEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9097Center For Emergency Medicine Western PennsylvaniaN307MEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9100Center For Emergency Medicine Western PennsylvaniaN3274MBeech E50 · S/N 57-6061Pittsburgh Institute Of AeronauticsN33SBBeech 65-A90 · S/N LJ-252Built 1967 · Pittsburgh Institute Of AeronauticsN3402BBert Floyd S BERT BF5 · S/N 5Pittsburgh Insititute Of AeronauticsN343JBBrown Jordan REVOLUTION MINI 500 · S/N 375Built 1998 · Pittsburgh Institute Of AeronauticsN3743BBeech C-50 · S/N CH-169Built 1955 · Pittsburgh Institute Of AeronauticsN430UCessna 172R · S/N 17280121Built 1997 · Cheyenne LLCN445MEEurocopter Deutschland EC 135 T2+ · S/N 1045Built 2012 · Center For Emergency Medicine Of Western PaN4514NGulfstream American AA-5B · S/N AA5B1003Built 1978 · Abc Flying Club IncN507MEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9507Built 2012 · Center For Emergency Medicine Of Western PaN520MEAirbus Helicopters Deutschland EC135T3 · S/N 2020Built 2017 · Ctr For Emergency Medicine Of Western PaN522MEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9522Built 2012 · Center For Emergency Medicine Of Western PaN523MEAirbus Helicopters EC135T3 · S/N 2323Built 2025 · Center For Emergency Medicine Of Western PaN530MEAirbus Helicopters Deutschland EC135T3 · S/N 2030Built 2017 · Center For Emergency Medicine Of Western PaN533MEAirbus Helicopters Deutschland EC135T3 · S/N 2133Built 2020 · Ctr For Emergency Medicine Of Western PennsylvaniaN534MEAirbus Helicopters Deutschland EC135T3 · S/N 2134Built 2020 · Center For Emergency Medicine Of Western PaN536MEAirbus Helicopters Deutschland EC135T3 · S/N 2036Built 2017 · Center For Emergency Medicine Of Western PaN537MEAirbus Helicopters Deutschland EC135T3 · S/N 2136Built 2020 · Center For Emergency Medicine Of Western PennsylvaN5400ACessna 310B · S/N 35600Built 1957 · Pittsburgh Institute Of AeronauticsN544MEAirbus Helicopters Deutschland EC135T3 · S/N 2244Built 2023 · Center For Emergency Medicine Of Western PaN576MEAirbus Helicopters Deutschland EC135T3 · S/N 2276Built 2024 · Center For Emergency Medicine Of Western PennsylvaN579MEAirbus Helicopters Deutschland EC135T3 · S/N 2279Built 2024 · Center For Emergency Medicine Of Western PennN589MEAirbus Helicopters Deutschland EC135T3 · S/N 2189Built 2022 · Center For Emerg Med Of W Penn Stat Medevac ProgN590MEAirbus Helicopters Deutschland EC135T3 · S/N 2190Built 2022 · Center For Emergency Medicine Of Western PaN61692Cessna 172M · S/N 17264734Built 1975 · Pittsburgh Institute Of AeronauticsN6183LAmerican AA-1 · S/N AA1-0383Pittsburgh Institute Of AeronauticsN620MEAirbus Helicopters EC135T3 · S/N 2320Built 2025 · Center For Emergency Medicine Of Western PaN641MEAirbus Helicopters Deutschland EC135T3 · S/N 2241Built 2023 · Ctr For Emergency Medicine Of Western PennsylvaniaN68735Cessna 152 · S/N 15282345Built 1978 · Pittsburgh Institute Of AeronauticsN72GHLearjet C-21A · S/N 84-0134Pittsburgh Institute Of AeronauticsN757XWCessna 152 · S/N 15280095Built 1977 · Pittsburgh Institute Of AeronauticsN7682TCessna 172C · S/N 17249073Pittsburgh Institute Of AeronauticsN777DCessna 340A · S/N 340A-1257Built 1981 · Pittsburgh Institute Of AeronauticsN811MEAirbus Helicopters Deutschland EC135T2+ · S/N 1201Built 2015 · Center For Emergency Medicine Of Western PaN8147EPiper PA-34-200T · S/N 34-8070114Built 1979 · Touretzky David SN827GAGulfstream Aerospace G-IV · S/N 1391Built 1999 · Ppg Industries IncN845MEEurocopter Deutschland EC 135 T2+ · S/N 0845Built 2009 · Center For Emergency Medicine Of Western PaN855MEAirbus Helicopters Deutschland EC135T2+ · S/N 1205Built 2015 · Center For Emergency Medicine Of Western PaN857GAGulfstream Aerospace GV-SP (G550) · S/N 5596Built 2019 · Ppg Industries IncN87MEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9603Built 2013 · Center For Emergency Medicine Of Western Pa
Back to West Mifflin, PA