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.
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
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.
N10860Curtiss Wright JR CW1 · S/N 1086N136ECommand-Aire 3C-3 · S/N 532N15287Aeronca C-3 · S/N A-614N1563Curtiss JN4D · S/N D-51N17490Porterfield 35-70 · S/N 190N18877Aeronca K · S/N K-141N1937Waco YKS-7 · S/N 4631N19518Piper J-2 · S/N 1718N2011MNorth American F-100C · S/N 54-2091N214JStandard J-1 · S/N 214N230ATDouglas A4D-2N · S/N A-14-1071N2692Douglas AD-4N · S/N 126924N2763AConsolidated Vultee 28-5ACF · S/N 21232N3152DRepublic P-47D · S/N 45-49346N329Grumman G-21A · S/N B-140N374KCurtiss Wright ROBIN · S/N 538N3842HCanadair F-86E MK.6 · S/N 1472N3865BCurtiss Wright ROBIN · S/N 469N39735Thomas Morse S4C · S/N 39734N40245Curtiss Wright P-40E · S/N 1038N420QNNoorduyn NORSEMAN MK VI · S/N 139N4289American Eagle A-1 · S/N 100N43771North American AT-6D · S/N 43771N4425VConsolidated Vultee BT-13B (SNV-2) · S/N 79-326N44713Naval Aircraft Factory N3N-3 · S/N 2704N44738Naval Aircraft Factory N3N-3 · S/N 1775N44742Naval Aircraft Factory N3N-3 · S/N 2783N44757Naval Aircraft Factory N3N-3 · S/N 2621N44837Naval Aircraft Factory N3N-3 · S/N 4484N45024Naval Aircraft Factory N3N-3 · S/N 1790N450SRBoeing B75N1 · S/N 75-7016N45280Naval Aircraft Factory N3N-3 · S/N 2827N4629VGrumman FM-2 · S/N 86564N46617Cessna T-50 · S/N 5193N47248Waco GXE · S/N 1315N47991Chance Vought F4U-4 · S/N 97390N4864JDouglas/Nichols SBD-4 · S/N 10518N4942VCurtiss Wright TRAVEL AIR A-6000-A · S/N 1040N51746Beech D17S · S/N 4890N60480Douglas C-47A · S/N 42-23668N6109PFairchild PT-26 M62A3 · S/N MAN FC 110N6116XNorth American B-25J · S/N 4486791N61241Curtiss Wright O-52 · S/N 14302N6217Travel Air Mfg 2000 · S/N 669N647WAeronca C-2 · S/N 27N648KGreat Lakes 2T-1A · S/N 183N684MFleet 7 · S/N 234N6956Ryan B1 · S/N 141N695MNaval Aircraft Factory N3N-3 · S/N 4480N7024SGrumman HU-16B · S/N 51-7195
Back to Nichols Charles F Trustee