Day James H
Earlier aircraft under this name · 290
Cancelled registrations that named this owner when they ended, newest first.
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'DAY JAMES H' OR list_contains(d.other_registrant_names, 'DAY JAMES H') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'DAY JAMES H' OR list_contains(d.other_registrant_names, 'DAY JAMES H') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N300RFBeech B24R · S/N MC-162N30298Piper PA-32RT-300 · S/N 32R-7885084N3150UCessna 182F · S/N 18254550N32329Piper PA-28-140 · S/N 28-7525051N36782Piper PA-32RT-300T · S/N 32R-7887077N36946Cessna 414A · S/N 414A0489N3953MPiper PA-12 · S/N 12-2596N4047NMooney M20F · S/N 680165N8052BHarvell V/Harvell R PDQ-D · S/N VRHN8168QPiper PA-28RT-201T · S/N 28R-8031072N8436GCessna 150F · S/N 15062536N8548TCessna 182C · S/N 52448N8633LPiper PA-25-235 · S/N 25-5068N90435Hughes 369HS · S/N 340575SN30162Cessna 177 · S/N 17701090N3027ZPiper PA-22-160 · S/N 22-6981N3053BCessna 195B · S/N 7936N29HTCessna 340A · S/N 340A0515N40160Ayres S2R-R3S · S/N R3S-007N41783Cessna 172 · S/N 610N80110Cessna 172M · S/N 17266375N83917Aeronca 7AC · S/N 7AC-2597N27028Balloon Works FIREFLY 6B · S/N 6642N30755Cessna 177B · S/N 17701445N3181Eaa BIPLANE · S/N BR-1N33KCCessna 421 · S/N 421-0026N3820FGreat Lakes 2T-1A-2 · S/N 0788N3862HErcoupe 415-CD · S/N 4563N41022Cessna 421B · S/N 421B0402N82091Piper PA-18-150 · S/N 18-7909060N8227CPiper PA-28-140 · S/N 28-7625089N1363Smith MINIPLANE · S/N L.N.2N13876Newman Waldo L B-8M · S/N WLN-1N3024Beech UC-45J · S/N 67234N34370Cessna 177B · S/N 17701782N3713JCessna 150G · S/N 15065013N2702VCessna 177RG · S/N 177RG0662N29033Piper PA-28RT-201T · S/N 28R-7931190N29391Cessna 172M · S/N 17264116N3062JCessna 150E · S/N 15061162N32750Piper PA-32-260 · S/N 32-7500008N35206Piper PA-31-350 · S/N 31-7952193N8229KUniversal Stinson 108-1 · S/N 1229N3572WPiper PA-32-260 · S/N 32-464N831PCPiper PA-31T · S/N 31T-8020001N28255Williams RALLY 3 · S/N 64602N8300GCessna 150F · S/N 15062400N3043LCessna 310J · S/N 310J0043N8227MCessna T210K · S/N 21059227N8232GCessna 177RG · S/N 177RG0132
Back to Day James H