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.
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
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.
N55TPRobinson Helicopter R22 BETA · S/N 2215N2552ZBellanca 8KCAB · S/N 348-77N5381HPiper PA-16 · S/N 16188N95627Cessna 152 · S/N 15285944N96TDCessna 550 · S/N 5500596N747FPiper PA-23 · S/N 23116N64819Beech RC-45J · S/N 523762N6539ECessna 172N · S/N 17272032N9213FHughes 369HS · S/N 840630SN4714WRockwell International 114 · S/N 14044N781VCBeech F90 · S/N LA76N19965Cameron Balloons US N-90 · S/N 5326N154YPflasterer Thomas W ULTRA-LIGHT · S/N 80721N6155ZErwin John D TAYLOR MONOPLANE · S/N 1993N6539JPiper PA-28-180 · S/N 284981N5775YAerospatiale AS 355F1 · S/N 5029N4DMCessna 310J · S/N 310J0026N1411PCessna 210M · S/N 21062080N20783Cameron Balloons US N-90 · S/N 5441N91867Schweizer SGS 1-23 · S/N 2N9378TPiper PA-38-112 · S/N 3878A0080N25155Piper PA-38-112 · S/N 3879A1032N201YSMooney M20J · S/N 240524N739MAMitsubishi MU-2B-26A · S/N 354SAN23AZSwearingen SA226TC · S/N TC260N39645Johnson William I KR-2 · S/N 1N401RABeech 1900C · S/N UB58N1976BLuscombe 8A · S/N 6403N8188LCessna 172H · S/N 17256388N509PALockheed L-1011-385-3 · S/N 193Y1188N508PALockheed L-1011-385-3 · S/N 193Y1186N5464GCessna 404 · S/N 404-0081N481JWelley-Cherokee RM A1 · S/N GAW 1N32PAAerospatiale SA341G GAZELLE · S/N 1136N780ALearjet 25 · S/N 056N17151Sikorsky HO3S-1 · S/N 123132N2639JCessna 150G · S/N 15065639N5500ECessna 320A · S/N 320A0001N82271Piper PA-31T · S/N 31T-7820044N2363JBeech 23 · S/N M-321N4963EGlen-Co. RAG-1 · S/N 1N86NRAgusta A109A · S/N 7123N7423Vickers VISCOUNT 797 · S/N 121N8433JCessna 150G · S/N 15066333N4500PBeech TC-45J · S/N 51192N4509PBeech UC-45J · S/N 23839N4513PBeech UC-45J · S/N 89479N44RBoeing 727-30C · S/N 18366N1545VBell 206A · S/N 326N9261VMooney M20F · S/N 690072
Back to Pittsburgh, PA