OpenAirDocs.org
Pacoima, CA

Registered aircraft · 55

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

N110LABell 412EP · S/N 36392Built 2005 · Consolidated Fire ProtectionN120LABell Helicopter Textron Canada 412EP · S/N 36455Built 2007 · County Of Los Angeles Fire DeptN1231AEurocopter AS 350 B2 · S/N 3682Built 2003 · Tiny Bubbles Aviation IncN12YJAmerican Eurocopter AS350B2 · S/N 4443Built 2008 · Tiny Bubbles Aviation IncN133LABell Textron Canada 412EP · S/N 39136Consolidated Fire ProtectionN13HKCessna 177B · S/N 17701810Built 1972 · Skycombers Flying Club IncN14LABell 412EP · S/N 36393Built 2005 · County Of Los AngelesN15LASikorsky S-70A · S/N 702846County Of Los AngelesN160LASikorsky S-70A · S/N 702453County Of Los Angeles Fire Dept Air OperationsN1695HPiper PA-28-140 · S/N 28-7725155Built 1977 · Vista Air IncN16KKBell 430 · S/N 49100S & S Aviation Services IncN18LABell 412 · S/N 36043Built 1992 · County Of Los Angeles Fire DepartmentN190LASikorsky S-70A · S/N 702479County Of Los Angeles Fire DepartmentN19688Cessna 172L · S/N 17260671Built 1972 · Vista Air IncN2081HErcoupe 415-C · S/N 2704Built 1946 · Gutierrez Ryan YN2126FCessna 172S · S/N 172S10458Built 2007 · Vista Aviation IncN214GHEurocopter AS 350 B2 · S/N 2537Built 1991 · Cobalt Holdings IncN21SZCessna 172R · S/N 17280653Built 1998 · Vista Air IncN240WMScrivener Les LANCAIR 360 · S/N 534-320-272FBBuilt 1995 · Smith Alan DN26504Cessna 172R · S/N 17280601Built 1998 · Vista Aviation IncN29LWAmerican Eurocopter AS350B2 · S/N 4485Built 2008 · Tiny Bubbles Aviation IncN30265Cessna 162 · S/N 16200093Corsair Aviation LLCN323LAEurocopter AS 350 B2 · S/N 3278Built 2000 · Western Summit Enterprises IncN326LPCessna 172S · S/N 172S9326Built 2003 · Vista Aviation IncN358TVEurocopter AS 350 B2 · S/N 3788Built 2004 · Tiny Bubbles Aviation IncN407REBell Helicopter Textron Canada 407 · S/N 53930Built 2009 · S & S Aviation Services IncN4285DBeech G35 · S/N D-4512Urbina Mario AN4702VBellanca 17-30 · S/N 30053Built 1967 · Brown AnthonyN48EFCessna 172S · S/N 172S9629Built 2004 · Vista Air IncN501ERCessna 172S · S/N 172S8947Built 2001 · Vista Air IncN508NDCessna 172S · S/N 172S11061Built 2010 · Corsair Aviation LLCN5216LCessna 162 · S/N 16200046Built 2011 · Corsair Aviation LLCN530TGMD Helicopters 369FF · S/N 0174FFSummit Helicopter IncN55DKCessna 310C · S/N 35878Built 1959 · Urbina Mario AntonioN6050ACessna 162 · S/N 16200186Built 2011 · Corsair Aviation LLCN618DHCessna 172S · S/N 172S11186Built 2012 · Corsair Aviation LLCN61HLAerospatiale AS350BA · S/N 2298Tiny Bubbles Aviation IncN623XC3D Robotics IRIS+ · S/N IRS1502200622Cobalt Holdings IncN624QCIntuitive Aerial IA3 AERIGON · S/N IA3-01-0000-0037Cobalt Holdings IncN6403VCessna 172RG · S/N 172RG0665Built 1980 · Vista Aviation IncN67FFMcdonnell Douglas Heli 369FF · S/N 0067FFBuilt 1989 · Summit Helicopter IncN7744SCessna 172S · S/N 172S8274Built 1999 · Vista Air IncN77EZFontaine-English VARIEZE · S/N 1087Smith Alan DN81927Aeronca 7DC · S/N 7AC-552Built 1946 · Elliott Joel CN821LASikorsky S-70I · S/N 704023Built 2017 · Consolidated Fire Protection District Of La CountyN828SPCessna 172S · S/N 172S8741Built 2001 · Vista Aviation IncN84CCessna T337G · S/N P3370115Built 1973 · Western Summit Enterprises IncN8818HNorth American NAVION · S/N NAV-4-818Built 1947 · Roth Sebastin AN89USDJI INSPIRE 1 · S/N W13DCC17020143Corsair Aviation LLCN9172Spezio Sport DAL 1 · S/N MG10214Built 1969 · Eggett John D
Back to Pacoima, CA