Nichols Judith A Trustee

Registered aircraft · 23

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 JUDITH A TRUSTEE' OR list_contains(g.other_registrant_names, 'NICHOLS JUDITH A 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.

N1563Curtiss JN4D · S/N D-51Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN3865BCurtiss Wright ROBIN · S/N 469Built 1918 · Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN39735Thomas Morse S4C · S/N 39734Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN40245Curtiss Wright P-40E · S/N 1038Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN420QNNoorduyn NORSEMAN MK VI · S/N 139Built 1943 · Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN44713Naval Aircraft Factory N3N-3 · S/N 2704Built 1944 · Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN44738Naval Aircraft Factory N3N-3 · S/N 1775Built 1940 · Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN44742Naval Aircraft Factory N3N-3 · S/N 2783Built 1961 · Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN44837Naval Aircraft Factory N3N-3 · S/N 4484Built 1941 · Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN45024Naval Aircraft Factory N3N-3 · S/N 1790Built 1940 · Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN45280Naval Aircraft Factory N3N-3 · S/N 2827Built 1941 · Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN4629VGrumman FM-2 · S/N 86564Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN46617Cessna T-50 · S/N 5193Built 1943 · Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN51746Beech D17S · S/N 4890Built 1943 · Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN61241Curtiss Wright O-52 · S/N 14302Built 1941 · Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN647WAeronca C-2 · S/N 27Built 1930 · Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN6956Ryan B1 · S/N 141Built 1928 · Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN695MNaval Aircraft Factory N3N-3 · S/N 4480Built 1943 · Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN7024SGrumman HU-16B · S/N 51-7195Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN718Lockheed P-38L · S/N 8187Built 1944 · Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN729ALockheed F-80-C-10 · S/N 49719Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN74920North American/Aero Classics P-51D · S/N 44-74910Built 1944 · Baldwin Park, CA · Co-owner with Nichols Charles F TrusteeN81575Bell P39 · S/N 42-8740Baldwin Park, CA · Co-owner with Nichols Charles F Trustee
Back to Nichols Judith A Trustee