Glendale, CA
Registered aircraft · 46
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 = 'CA' AND g.registrant_city = 'GLENDALE' 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 = 'CA' AND g.registrant_city = 'GLENDALE' 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.
N100CWWhitaker MUSTANG II · S/N 1N1264QCessna 150L · S/N 15072564N161BTTodd Elmer L RV-3 · S/N 161N178ASCessna 750 · S/N 750-0502N17949Schweizer SGS 1-26E · S/N 549N18LBRaceair Designs 'LIL BITTS · S/N 001N211MRCessna 182S · S/N 18280813N219ELCirrus Design SR20 · S/N 1781N231WMCirrus Design SR22 · S/N 0900N23DDPiper PA-28-181 · S/N 2881676N248RGCirrus Design SR20 · S/N 2277N2499Schleicher ASW-24 · S/N 24009N25BBLearjet 31A · S/N 102N2773TBeech 95-C55 · S/N TE-376N308DWCessna 152 · S/N 15285940N313TTDassault MYSTERE FALCON 50EX · S/N 297N3349CCessna R182 · S/N R18200274N346RMPiper PA-24-250 · S/N 24-929N401SYLearjet 60 · S/N 60-256N4178NPiper PA-28-181 · S/N 2843415N430EPCessna 172R · S/N 17280648N4372BPiper PA-46-310P · S/N 46-8408083N520PDMD Helicopters 500N · S/N LN111N53DFBombardier CL-600-2B16 · S/N 5507N5543ECessna 172N · S/N 17271886N5932FPiper PA-28-181 · S/N 28-7790144N63MGCessna A185F · S/N 18504042N65LLExtra Flugzeugbau EA-400 · S/N 14N6SQCessna T310Q · S/N 310Q0625N700PBAerovodochody L-29 DELFIN · S/N 892814N733AMCessna 172N · S/N 17268145N738TJCessna 172N · S/N 17270222N739DXCessna 172N · S/N 17270471Registration pendingN7430ECessna 210 · S/N 57130N744ARDassault MYSTERE-FALCON 50 · S/N 316N74SLSchempp-Hirth NIMBUS 3T · S/N 20N7607ECessna 172N · S/N 17272115N763PPDassault MYSTERE-FALCON 50 · S/N 278N818PDAirbus Helicopters AS350B3 · S/N 9642N8204UCessna 172F · S/N 17252104N89800Cessna 152 · S/N 15282872N91377Cessna 182P · S/N 18261991N9333NPiper PA-28R-200 · S/N 28R-35033N9409PPiper PA-24-260 · S/N 24-4914N9786RBeech M35 · S/N D-6299N99MAAndrews WITTMAN TAILWIND W-8 · S/N CKA2
Back to Glendale, CA