AD 2004-19-01
Registered aircraft · 30,427
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:2004-19-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-19-01')
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:2004-19-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-19-01') 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.
N109HBadke Paul J · Ray, MIN109WYPerala Daniel R · Cheyenne, WYN109YBraun Joshua S · Port Hope, MIN10ARK Airmotive LLC · St Helens, ORN10BFCruz Keoni K · The Woodlands, TXN10CCSmith Kord S · Salmon, IDN10FPLoves Park Air LLC · Loves Park, ILN10GCBanks Keith Allen · Salisbury, MDN10GMAlo Aviation LLC · Titusville, FLN10GSMaye Darren Alvaro · Jacksonville, FLN10KYMckinnon Laughlin Neil Trustee · Carlsbad, CAN10RHGoodson David · Millbrook, ALN10RVKoehn Shane Michael · Scooba, MSN10URXtiri LLC · St George, UTN10WQQuirion Paul J · Fairbanks, AKN1100Souchet Brian · Fleming Island, FLN1100SHagen Johnny D · Claremore, OKN1101CHampton Brock W · Wichita, KSN1102CWakefield Aviation LLC · Mahopac, NYN1102FGrant County State Bank · Carson, NDN1102YSass James Louis Jr · Abilene, TXN1103DOber John A · Candor, NYN1104DRymill Mark R · Belmont, CAN1104FMiller Jonathan A · Apo, APN1105CLandon Jeff · Lancaster, CAN1105DGilman Larry E · Reno, NVN1105FGibbard Donald R · Walla Walla, WAN1106DMurdock Mark F · Ketchikan, AKN1107FMedic Choppers LLC · Springdale, ARN1108DReddout Terry L Trustee · Wichita, KSN1108FAom Aircraft LLC · Wilmington, DEN1109DMcqueen Alan G · Cocoa, FLFirst renewal noticeN1109MPatrick Chris J · Paris, ILN1109YKoller Keith S · Grosse Ile, MIN110FSMaggie L Air Service LLC · Kalispell, MTN110PFUniversity Of Detroit Flying Club Inc · Livonia, MIN110SMPenhall Michael Joseph · Lake Forest, CAN110USZwainz Thomas G · Reardan, WAN110VSbur David A · Vancouver, WAN110XPlayter Bud W DBA · Gowen, MIFirst renewal noticeN11103Hennigan Shellie · Jonesboro, LAN1110FSallade William L · Coudersport, PAN11118Aircraft Partner Holdings Inc Trustee · Fallbrook, CAN1111YAeronautical Technical Service Inc · Collierville, TNN1112DMurray Russell J · Fresno, CAN1112HStrojny Andrew P III · Medina, OHN1112TRegistration Pending · Soldotna, AKRegistration pendingN1113YPrecision Design Inc · Weatherford, OKN1114FRegistration Pending · Florence, SCRegistration pendingN1114TQuellette James L · Plymouth, CT
Back to AD 2004-19-01