Erie, PA
Registered aircraft · 53
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 = 'ERIE' 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 = 'ERIE' 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.
N10830Cessna 150L · S/N 15075070N1231DJI PHANTOM 4 PRO · S/N OAXCE6U0B30420N1232QCessna 150L · S/N 15072532N162APHunt Jeffrey Scott EXEC 162F · S/N 6616N16621Piper J-2 · S/N 636N184MHHanek Michael J JR PITTS S1S · S/N 1N1894TPiper PA-28-140 · S/N 28-7225023N21ATCessna 172N · S/N 17268907N21GJJasper Gary H VANS RV-6 · S/N 20526N242PJPilatus PC-24 · S/N 242N2806DRaven S55A · S/N S55A-1094N28NFAviat A-1C-180 · S/N 3173N34694Cessna 177B · S/N 17701942N36401Piper PA-32RT-300T · S/N 32R-7887040N3807MPiper PA-12 · S/N 12-2729N3838TPiper PA-28R-180 · S/N 28R-30157N401VRVashon RANGER R7 · S/N 10258Registration pendingN4023GSixchuter SR7 · S/N SR7XL-2661N40FMMooney M20K · S/N 25-2012N42673Cessna 182L · S/N 18259132N432RRCessna 182Q · S/N 18267066N4769XCessna 150G · S/N 15064819N5001WPiper PA-28-160 · S/N 28-2N500DWPilatus PC-12/47E · S/N 1729N5322MPiper PA46-500TP · S/N 4697021N5461WPiper PA-28-160 · S/N 28-541N54FGCostruzioni Aeronautiche Tecna P2010 TDI · S/N 215/USN56705Piper PA-28-140 · S/N 28-7425022N58980Boeing E75 · S/N 75-5800N614TMBeech A36 · S/N E-567N6176UBeech V35B · S/N D-10387N63399Cessna 150M · S/N 15077284N64408Cessna R172E · S/N R1720104N6466CPiper PA-28-181 · S/N 28-7890374N662BFFoster Robert B LONG EZ · S/N RBF01N663BFRobert B Foster PANTHER LS · S/N 034N6769FCessna 150F · S/N 15063369N683DMCirrus Design SR22 · S/N 3427N6914HPiper J3C-65 · S/N 20146N725KLCirrus Design SR22T · S/N 0079N758FBCessna R172K · S/N R1723051N8007SCessna 150F · S/N 15061607N814SCommuter JR. H1-B · S/N CWS-1N8150APiper PA-28-181 · S/N 28-8090228N8223SCessna 150F · S/N 15061823N840JWRockwell International 690C · S/N 11658N868WGTextron 680A · S/N 680A0076N86ETEdward J Tropper E TROPPER WAIEX · S/N 138N8785CPiper PA-18 · S/N 18-2881N87ETTropper Edward J TROPPER-RV-4 · S/N 001
Back to Erie, PA