Nichols Charles F Trustee

Registered aircraft · 67

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

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_name = 'NICHOLS CHARLES F TRUSTEE' OR list_contains(g.other_registrant_names, 'NICHOLS CHARLES F TRUSTEE')
  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 1086Baldwin Park, CAN136ECommand-Aire 3C-3 · S/N 532Built 1928 · Baldwin Park, CAN15287Aeronca C-3 · S/N A-614Baldwin Park, CAN1563Curtiss JN4D · S/N D-51Baldwin Park, CAN17490Porterfield 35-70 · S/N 190Baldwin Park, CAN18877Aeronca K · S/N K-141Built 1937 · Baldwin Park, CAN1937Waco YKS-7 · S/N 4631Built 1937 · Baldwin Park, CAN19518Piper J-2 · S/N 1718Built 1937 · Baldwin Park, CAN2011MNorth American F-100C · S/N 54-2091Baldwin Park, CAN214JStandard J-1 · S/N 214Baldwin Park, CAN230ATDouglas A4D-2N · S/N A-14-1071Baldwin Park, CAN2692Douglas AD-4N · S/N 126924Baldwin Park, CAN2763AConsolidated Vultee 28-5ACF · S/N 21232Built 1947 · Baldwin Park, CAN3152DRepublic P-47D · S/N 45-49346Baldwin Park, CAN329Grumman G-21A · S/N B-140Built 1945 · Baldwin Park, CAN374KCurtiss Wright ROBIN · S/N 538Built 1929 · Baldwin Park, CAN3842HCanadair F-86E MK.6 · S/N 1472Baldwin Park, CAN3865BCurtiss Wright ROBIN · S/N 469Built 1918 · Baldwin Park, CAN39735Thomas Morse S4C · S/N 39734Baldwin Park, CAN40245Curtiss Wright P-40E · S/N 1038Baldwin Park, CAN420QNNoorduyn NORSEMAN MK VI · S/N 139Built 1943 · Baldwin Park, CAN4289American Eagle A-1 · S/N 100Baldwin Park, CAN43771North American AT-6D · S/N 43771Built 1943 · Baldwin Park, CAN4425VConsolidated Vultee BT-13B (SNV-2) · S/N 79-326Baldwin Park, CAN44713Naval Aircraft Factory N3N-3 · S/N 2704Built 1944 · Baldwin Park, CAN44738Naval Aircraft Factory N3N-3 · S/N 1775Built 1940 · Baldwin Park, CAN44742Naval Aircraft Factory N3N-3 · S/N 2783Built 1961 · Baldwin Park, CAN44757Naval Aircraft Factory N3N-3 · S/N 2621Built 1941 · Baldwin Park, CAN44837Naval Aircraft Factory N3N-3 · S/N 4484Built 1941 · Baldwin Park, CAN45024Naval Aircraft Factory N3N-3 · S/N 1790Built 1940 · Baldwin Park, CAN450SRBoeing B75N1 · S/N 75-7016Built 1942 · Baldwin Park, CAN45280Naval Aircraft Factory N3N-3 · S/N 2827Built 1941 · Baldwin Park, CAN4629VGrumman FM-2 · S/N 86564Baldwin Park, CAN46617Cessna T-50 · S/N 5193Built 1943 · Baldwin Park, CAN47248Waco GXE · S/N 1315Built 1928 · Baldwin Park, CAN47991Chance Vought F4U-4 · S/N 97390Baldwin Park, CAN4864JDouglas/Nichols SBD-4 · S/N 10518Baldwin Park, CAN4942VCurtiss Wright TRAVEL AIR A-6000-A · S/N 1040Built 1954 · Baldwin Park, CAN51746Beech D17S · S/N 4890Built 1943 · Baldwin Park, CAN60480Douglas C-47A · S/N 42-23668Baldwin Park, CAN6109PFairchild PT-26 M62A3 · S/N MAN FC 110Baldwin Park, CAN6116XNorth American B-25J · S/N 4486791Built 1944 · Baldwin Park, CAN61241Curtiss Wright O-52 · S/N 14302Built 1941 · Baldwin Park, CAN6217Travel Air Mfg 2000 · S/N 669Built 1928 · Baldwin Park, CAN647WAeronca C-2 · S/N 27Built 1930 · Baldwin Park, CAN648KGreat Lakes 2T-1A · S/N 183Baldwin Park, CAN684MFleet 7 · S/N 234Built 1930 · Baldwin Park, CAN6956Ryan B1 · S/N 141Built 1928 · Baldwin Park, CAN695MNaval Aircraft Factory N3N-3 · S/N 4480Built 1943 · Baldwin Park, CAN7024SGrumman HU-16B · S/N 51-7195Baldwin Park, CA
Back to Nichols Charles F Trustee