Peoria, AZ
Registered aircraft · 157
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 = 'AZ' AND g.registrant_city = 'PEORIA' 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 = 'AZ' AND g.registrant_city = 'PEORIA' 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.
N101YYParadise Aircraft USA P1 · S/N 178N102LLPiper PA-34-200T · S/N 34-7970483N104ABCessna 182S · S/N 18280280N107FMEagle Balloons C-7 · S/N E82729N1097NCessna 172S · S/N 172S9821Sale reportedN116ABBeech E-55 · S/N TE-899N11951Cameron Balloons US A-250 · S/N 6449N126GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 342N128KANorth American T-28B · S/N 137760N13ARBeech E35 · S/N D-3885N1487RGrumman American Avn. AA-1B · S/N AA1B-0587N151BJJohnson Bruce VANS RV 10 · S/N 40606N15454Beech F33A · S/N CE-1489N159CTFlight Design CTSW · S/N 06-03-06N16412Piper PA-28-180 · S/N 28-7305247N1684WBeech V35B · S/N D-9386N16GXRemos REMOS GX · S/N 259N172FGCessna 172N · S/N 17267586N178SWFlight Design CTSW · S/N 07-06-11N181DLRobert M Opperman CHALLENGER · S/N 0913-001-CH1N1839HPiper PA-34-200T · S/N 34-7770152N187KTMaggie VANS RV-7 · S/N 70252N188VECessna 172S · S/N 172S8391N1912DBeech C35 · S/N D-3162N1937TPiper PA-28-140 · S/N 28-7125490N1998MCessna 182P · S/N 18264527N20085Cessna 177B · S/N 17702626N201FSCessna 172S · S/N 172S8453Registration pendingN2026VCessna 140 · S/N 14297N208GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 331N222WTCessna 170B · S/N 20372N2304ACameron Balloons Z-90 · S/N 6546N231VFMooney M20K · S/N 25-0556N24143Cessna 175 · S/N 55436N242CTFlight Design CTSW · S/N 06-06-01N24483Cessna 172R · S/N 17280982N248AJEvolution Kna LANCAIR EVOLUTION · S/N EVO-023N2621KPiper L-21B · S/N 54-2629N2714KLuscombe 11A · S/N 11-110N2866KCessna 180K · S/N 18053104N292CTFlight Design CTSW · S/N 06-07-08N29537Piper PA-28-181 · S/N 28-7990449N30153Cessna 177 · S/N 17701082N3039WPiper PA-28-236 · S/N 28-7911139N314PWPiper PA-28R-201 · S/N 2844031N345ERMoseley E/Moseley R LRG-360 · S/N 359N34FBFantasy Sky Promotions FANTASY EIGHT-90 · S/N 115N35325Cessna 172S · S/N 172S8819N3552ECessna 172N · S/N 17271584N356MWCorey Dartnell Jones S7 SUPER SPORT · S/N KA19274425
Back to Peoria, AZ