OpenAirDocs.org
Pasadena, CA

Registered aircraft · 82

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 = 'PASADENA'
  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.

N1201XMooney M20C · S/N 2604Built 1963 · Simmons Herbert H TrusteeN15001Toofon G150 · S/N G150-001-0001Toofon IncN156XLCessna 560XL · S/N 560-6056Built 2010 · J G Boswell CoN1658FCessna 172H · S/N 17255053Built 1966 · Mondo Beyondo Thrill SquadronN1705RCessna R182 · S/N R18200525Built 1978 · Cox Brian AllenN1734UCessna T210N · S/N 21064735Built 1982 · Wing Nutz LLCN1742GBeech 35-B33 · S/N CD-467Built 1962 · Loftus KevinN182FBCessna TR182 · S/N R18201422Built 1979 · Downwind Abeam IncN194BNWatson Robert Lee RV-9A · S/N 90060Built 2003 · Swartz Raymond L JrN194DADiamond Aircraft Ind DA20-A1 · S/N 10102Built 1996 · Shively Orrin JN19760Cessna 172L · S/N 17260729Built 1972 · Aero Assn Of California Institute Of TechnologyN1PRCessna 680 · S/N 680-0340Built 2013 · Prm CorpN2213MPiper PA-28-236 · S/N 28-7911092Built 1979 · Weels Up IncN224KBBell OH-58 · S/N 72-21338Pasadena Police DepartmentN224MHCessna P210N · S/N P21000089Built 1978 · Feely Daniel RN22568Cessna 150H · S/N 15068368Built 1968 · Pina Gabriel BN2281EAeronca 7AC · S/N 7AC-5855Medina Angel ON269AMAircraft Mfg & Development CH 2000 · S/N 20-1036Built 2004 · Bekraoui HichamN29DJHilbert Dahl SLING 2 · S/N 299KBuilt 2020 · Bremer Michael CN3237NChinese A/F Aero Ind Devel CTR PL-1B · S/N 5849Built 1970 · Lee Leo Lea YoungN337WACessna 337G · S/N 33701651Built 1975 · Gyron Eagle LtdN3467APiper PA-22 · S/N 22-1736Ray William RN3540DCessna 170B · S/N 27083Built 1956 · Hardwick James AnthonyN3577RBeech A23 · S/N M-777Built 1965 · Morton Douglas LN3627HErcoupe 415-C · S/N 4252Pina GabrielN36MBBritcliffe Michael J RV-8 · S/N 83764Built 2021 · Britcliffe Michael JN3755HMooney M20J · S/N 24-0927Built 1979 · Weltman Brian GN38GPCostruzioni Aeronautiche Tecna P2010 TDI · S/N 232/USBuilt 2023 · Prm CorpN407LAMooney M20J · S/N 24-1528Built 1984 · Langewisch Gary RN4770APiper PA-22-150 · S/N 22-3918Built 1956 · Robinson EvanN4786ECessna 172N · S/N 17271651Built 1978 · Tu Erik SN49WAGates Lear Jet 25B · S/N 142Built 1973 · Fleet Unlimited IncN501RMMD Helicopters 369E · S/N 0598EBuilt 2009 · City Of PasadenaN502FNToofon G50 · S/N G50-001-0002Toofon IncN54678Cessna 172P · S/N 17275034Built 1981 · Aero Association Of Caltech IncN596WAEurocopter AS 350 BA · S/N 2329Built 1990 · Fleet Unlimited IncN5997VPiper PA-28-181 · S/N 28-7790515Aero Association Of Caltech IncN599PMCirrus Design SR22 · S/N 1246Built 2004 · Cirrus Maximus LLCN602JAAllen John RV6A · S/N 001Built 2001 · Allen John SN618JLCirrus Design SR22 · S/N 8502Built 2022 · Aero Venture LLCN634STPiper PA46-500TP · S/N 4697634Built 2018 · Dc Skies LLCN6397YCessna T210N · S/N 21064363Built 1981 · Asher James AN644SWBoeing 737-3H4 · S/N 28329Built 1997 · Prima Air LLCN683DNSikorsky UH-60A · S/N 8223683Built 1982 · Rogerson KratosN684DNSikorsky UH-60 · S/N 80-23472Built 1981 · Rogerson-KratosN685DNSikorsky UH-60A · S/N 80-23430Built 1980 · Rogerson KratosN687DNSikorsky UH-60L · S/N 84-23981Built 1984 · Rogerson KratosN69522Cessna 340 · S/N 340-0354Built 1974 · Kpk Enterprises IncN6982VMooney M20F · S/N 22-1344Built 1976 · Twardowski PrzemyslawN705SGCessna 560XL · S/N 560-5142Built 2001 · Union Of Operating Engineers
Back to Pasadena, CA