Anaheim, CA
Registered aircraft · 65
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 = 'ANAHEIM' 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 = 'ANAHEIM' 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.
N1015EMooney M20D · S/N 255N1035XPiper PA-28R-200 · S/N 28R-7535222N136SKBeechcraft G36 · S/N E-4033N14275Norman G Caruana SQ2000 · S/N 31N1437HPiper PA-32R-300 · S/N 32R-7780160N17399Lockheed 12A · S/N 1271N180BPPiaggio P180 · S/N 1004N1939HPiper PA-28R-201 · S/N 28R-7737018N1966DBeech C35 · S/N D-3249N201TCMooney M20J · S/N 24-0173N2140VPiper PA-28-181 · S/N 28-7990340N2179ZPiper PA-28-236 · S/N 28-7911157N2243MStinson 108-3 · S/N 108-4127N22QEHallam Henry M QUICKLI · S/N 1N26QRBeech A36TC · S/N EA-19N286ALAlan W Scott ZENITH CH750 CRUZER · S/N 10880N286BWPiper PA-34-200T · S/N 34-7970182N29846Stinson L-5 · S/N 76-709N311CTBeech A36 · S/N E-853N312TLLearjet 31A · S/N 172N3273DCessna 337G · S/N 33701491N32773Piper PA-28R-200 · S/N 28R-7535088N34724Porterfield FP-65 · S/N 890N3663VCessna 150M · S/N 15076578N3758VCessna 140 · S/N 15041N37869Porterfield LP-65 · S/N 1016N3862QCessna 172L · S/N 17259962N41055Cessna 421B · S/N 421B0576N41BJAmerican General Acft AG5B · S/N 10036N44VSCessna 525 · S/N 525-0500N451MEMedy P Medel JR TANGO2 · S/N MM001N4798VBoeing E75 · S/N 75-5086N4898BCessna 152 · S/N 15283697N4976FCessna 172N · S/N 172-73113N513MSPiper PA-28-161 · S/N 2841347N520CRTextron 525C · S/N 525C0315N5273UCessna 172S · S/N 172S9193N54599Douglas DC3 · S/N 45-928N54602Douglas DC3 · S/N 43-49819N5536RCessna 172F · S/N 17253118N5586DPiper PA-28R-180 · S/N 28R-30116N5830KBeech S35 · S/N D-7890N596PSStanczyk Paul L RV-6A · S/N 24901N61081Cessna 150J · S/N 15070784N610JKilani Reda LANCAIR IV · S/N LIV-227N627AXPiper PA 46-350P · S/N 4636341N70012Stinson VULTEE V-77 · S/N 77-284N700EZSocata TBM 700 · S/N 307N706SWBoeing 737-7H4 · S/N 27840N72983Cessna 140 · S/N 10184
Back to Anaheim, CA