AD 75-18-05
Registered aircraft · 85
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:75-18-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-18-05')
ORDER BY 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 n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:75-18-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-18-05') ORDER BY 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.
N3587TManning Michael W · Chanhassen, MNN3589TChristensen Rande L · Cambridge, MNN3591TRussell William E · Remus, MIN3592TMcnaney David L · Hysham, MTN3612THamill Theo W · Durango, CON3616THam Russell W · Dike, TXN3617TRegistration Pending · Fairbanks, AKRegistration pendingN3666TOlson Ronnie E · Palmer, AKN3668TSchachle Jeremiah K · Houston, AKN3669TGrey Brian S · Walker, MNN3673TDunn Carrie B · Emporia, KSN3678TVeech Shawn M · Big Lake, AKN3679TGks 1 LLC · Dalton, PAN3682TMortenson Allan C · Healy, AKN3684TBrosseau Stephen C · Sonoma, CAN3685THarvath John A Jr · Anchorage, AKN3689TVon Brock David C · Gulf Breeze, FLN3690TDunlap Gary P · Seattle, WAN3692TPitts Lynn L · Webb City, MON3694TSchock Niklas A · Palmer, AKN3696TRegistered aircraftN3697TShannon Christopher Ray · Nome, AKFirst renewal noticeN3698TMccormick Ken C · Indian, AKN3728TSomd Seaplanes LLC · Lexington Park, MDN3756TVan Koevering Douglas · Jenison, MIN3774TMcconnell Andrew D · Palmer, AKN3787TPrewett Jared · Houston, AKN3794TFournier Mark R · Carabaset Vly, MEN37YDSteele Elizabeth · Kalispell, MTN3861TQuast Felix J · Delano, MNN3995TCorlett Thomas I · Clinton, WAN62472Ollmann Matthew P · Poplar Grove, ILN69GGMosher Dustin T · Tehachapi, CAN8216ELevinson Taylor · Anchorage, AKN9587TWeymouth James · Jackson, MI
Back to AD 75-18-05