Baldwin Park, CA

Registered aircraft · 94

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 = 'BALDWIN PARK'
  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.

N10860Curtiss Wright JR CW1 · S/N 1086Nichols Charles F TrusteeN11224Stearman 4E · S/N 4026Built 1931 · Yanks Air MuseumN130TLTL Ultralight Sro STINGSPORT · S/N TLUSA145Built 2006 · Delgado MarioN136ECommand-Aire 3C-3 · S/N 532Built 1928 · Nichols Charles F TrusteeN1515ZBeech N35 · S/N D-6831Built 1961 · Yanks Air MuseumN15287Aeronca C-3 · S/N A-614Nichols Charles F TrusteeN1563Curtiss JN4D · S/N D-51Nichols Charles F TrusteeN17490Porterfield 35-70 · S/N 190Nichols Charles F TrusteeN18613Waco UEC · S/N 3684Built 1933 · Yanks Air MuseumN18877Aeronca K · S/N K-141Built 1937 · Nichols Charles F TrusteeN1937Waco YKS-7 · S/N 4631Built 1937 · Nichols Charles F TrusteeN19518Piper J-2 · S/N 1718Built 1937 · Nichols Charles F TrusteeN2011MNorth American F-100C · S/N 54-2091Nichols Charles F TrusteeN214JStandard J-1 · S/N 214Nichols Charles F TrusteeN230ATDouglas A4D-2N · S/N A-14-1071Nichols Charles F TrusteeN2692Douglas AD-4N · S/N 126924Nichols Charles F TrusteeN27385Republic P-47 · S/N 93-F-12000Built 1944 · Nichols Charles TrusteeN2763AConsolidated Vultee 28-5ACF · S/N 21232Built 1947 · Nichols Charles F TrusteeN2872GConsolidated Vultee P4Y-2 · S/N 66300Yanks Air MuseumN3152DRepublic P-47D · S/N 45-49346Nichols Charles F TrusteeN329Grumman G-21A · S/N B-140Built 1945 · Nichols Charles F TrusteeN33853Aeronca 65-CA · S/N C13871Yanks Air MuseumN33QGrumman G-44 · S/N 1398Yanks Air MuseumN3593HEngineering & Research 415-D · S/N 4218Built 1946 · Yanks Air MuseumN36503Aeronca 65-LB · S/N L-15581Yanks Air MuseumN374KCurtiss Wright ROBIN · S/N 538Built 1929 · Nichols Charles F TrusteeN3842HCanadair F-86E MK.6 · S/N 1472Nichols Charles F TrusteeN3865BCurtiss Wright ROBIN · S/N 469Built 1918 · Nichols Charles F TrusteeN39735Thomas Morse S4C · S/N 39734Nichols Charles F TrusteeN40245Curtiss Wright P-40E · S/N 1038Nichols Charles F TrusteeN40467Grumman Aircraft Engrg F6F-3 · S/N 08831Yanks Air MuseumN420QNNoorduyn NORSEMAN MK VI · S/N 139Built 1943 · Nichols Charles F TrusteeN4289American Eagle A-1 · S/N 100Nichols Charles F TrusteeN43771North American AT-6D · S/N 43771Built 1943 · Nichols Charles F TrusteeN4425VConsolidated Vultee BT-13B (SNV-2) · S/N 79-326Nichols Charles F TrusteeN44713Naval Aircraft Factory N3N-3 · S/N 2704Built 1944 · Nichols Charles F TrusteeN44738Naval Aircraft Factory N3N-3 · S/N 1775Built 1940 · Nichols Charles F TrusteeN44742Naval Aircraft Factory N3N-3 · S/N 2783Built 1961 · Nichols Charles F TrusteeN44757Naval Aircraft Factory N3N-3 · S/N 2621Built 1941 · Nichols Charles F TrusteeN44837Naval Aircraft Factory N3N-3 · S/N 4484Built 1941 · Nichols Charles F TrusteeN45024Naval Aircraft Factory N3N-3 · S/N 1790Built 1940 · Nichols Charles F TrusteeN450SRBoeing B75N1 · S/N 75-7016Built 1942 · Nichols Charles F TrusteeN45280Naval Aircraft Factory N3N-3 · S/N 2827Built 1941 · Nichols Charles F TrusteeN4629VGrumman FM-2 · S/N 86564Nichols Charles F TrusteeN46617Cessna T-50 · S/N 5193Built 1943 · Nichols Charles F TrusteeN47248Waco GXE · S/N 1315Built 1928 · Nichols Charles F TrusteeN47803Fairchild M-62A · S/N 8163AEBuilt 1943 · Yanks Air MuseumN47991Chance Vought F4U-4 · S/N 97390Nichols Charles F TrusteeN4864JDouglas/Nichols SBD-4 · S/N 10518Nichols Charles F TrusteeN48RWColumbia XJL · S/N 31399Built 1954 · Yanks Air Museum
Back to Baldwin Park, CA