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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1563Curtiss JN4D · S/N D-51N3865BCurtiss Wright ROBIN · S/N 469N39735Thomas Morse S4C · S/N 39734N40245Curtiss Wright P-40E · S/N 1038N420QNNoorduyn NORSEMAN MK VI · S/N 139N44713Naval Aircraft Factory N3N-3 · S/N 2704N44738Naval Aircraft Factory N3N-3 · S/N 1775N44742Naval Aircraft Factory N3N-3 · S/N 2783N44837Naval Aircraft Factory N3N-3 · S/N 4484N45024Naval Aircraft Factory N3N-3 · S/N 1790N45280Naval Aircraft Factory N3N-3 · S/N 2827N4629VGrumman FM-2 · S/N 86564N46617Cessna T-50 · S/N 5193N51746Beech D17S · S/N 4890N61241Curtiss Wright O-52 · S/N 14302N647WAeronca C-2 · S/N 27N6956Ryan B1 · S/N 141N695MNaval Aircraft Factory N3N-3 · S/N 4480N7024SGrumman HU-16B · S/N 51-7195N718Lockheed P-38L · S/N 8187N729ALockheed F-80-C-10 · S/N 49719N74920North American/Aero Classics P-51D · S/N 44-74910N81575Bell P39 · S/N 42-8740
Back to Nichols Judith A Trustee