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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N12144Cessna 310A · S/N 31038118N1232KCessna 340A · S/N 340A1815N132DAeropro CZ S R O A240 · S/N 59120N1392SCessna 182P · S/N 18264953N1DUBeech D50C · S/N DH-262N20274Cessna 177B · S/N 17702653N2104APiper PA-22-135 · S/N 22-560N22307Cessna 150H · S/N 15068207N2XDPittsburgh Inst Of Aeronautics BAKENG DOUBLE DUCE · S/N 78-1N304MEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9097N307MEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9100N3274MBeech E50 · S/N 57-6061N33SBBeech 65-A90 · S/N LJ-252N3402BBert Floyd S BERT BF5 · S/N 5N343JBBrown Jordan REVOLUTION MINI 500 · S/N 375N3743BBeech C-50 · S/N CH-169N430UCessna 172R · S/N 17280121N445MEEurocopter Deutschland EC 135 T2+ · S/N 1045N4514NGulfstream American AA-5B · S/N AA5B1003N507MEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9507N520MEAirbus Helicopters Deutschland EC135T3 · S/N 2020N522MEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9522N523MEAirbus Helicopters EC135T3 · S/N 2323N530MEAirbus Helicopters Deutschland EC135T3 · S/N 2030N533MEAirbus Helicopters Deutschland EC135T3 · S/N 2133N534MEAirbus Helicopters Deutschland EC135T3 · S/N 2134N536MEAirbus Helicopters Deutschland EC135T3 · S/N 2036N537MEAirbus Helicopters Deutschland EC135T3 · S/N 2136N5400ACessna 310B · S/N 35600N544MEAirbus Helicopters Deutschland EC135T3 · S/N 2244N576MEAirbus Helicopters Deutschland EC135T3 · S/N 2276N579MEAirbus Helicopters Deutschland EC135T3 · S/N 2279N589MEAirbus Helicopters Deutschland EC135T3 · S/N 2189N590MEAirbus Helicopters Deutschland EC135T3 · S/N 2190N61692Cessna 172M · S/N 17264734N6183LAmerican AA-1 · S/N AA1-0383N620MEAirbus Helicopters EC135T3 · S/N 2320N641MEAirbus Helicopters Deutschland EC135T3 · S/N 2241N68735Cessna 152 · S/N 15282345N72GHLearjet C-21A · S/N 84-0134N757XWCessna 152 · S/N 15280095N7682TCessna 172C · S/N 17249073N777DCessna 340A · S/N 340A-1257N811MEAirbus Helicopters Deutschland EC135T2+ · S/N 1201N8147EPiper PA-34-200T · S/N 34-8070114N827GAGulfstream Aerospace G-IV · S/N 1391N845MEEurocopter Deutschland EC 135 T2+ · S/N 0845N855MEAirbus Helicopters Deutschland EC135T2+ · S/N 1205N857GAGulfstream Aerospace GV-SP (G550) · S/N 5596N87MEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9603
Back to West Mifflin, PA