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.

N109HBadke Paul J · Ray, MIBuilt 1962 · S/N 21057921N109WYPerala Daniel R · Cheyenne, WYBuilt 1969 · S/N 18260131N109YBraun Joshua S · Port Hope, MIBuilt 1962 · S/N 18253513N10ARK Airmotive LLC · St Helens, ORBuilt 1966 · S/N U206-0738N10BFCruz Keoni K · The Woodlands, TXBuilt 1958 · S/N 36672N10CCSmith Kord S · Salmon, IDBuilt 1964 · S/N 206-0166N10FPLoves Park Air LLC · Loves Park, ILS/N 15068636N10GCBanks Keith Allen · Salisbury, MDBuilt 1953 · S/N 30159N10GMAlo Aviation LLC · Titusville, FLS/N T210-0151N10GSMaye Darren Alvaro · Jacksonville, FLBuilt 1964 · S/N 15060587N10KYMckinnon Laughlin Neil Trustee · Carlsbad, CABuilt 1971 · S/N 18501898N10RHGoodson David · Millbrook, ALBuilt 1967 · S/N 15066306N10RVKoehn Shane Michael · Scooba, MSBuilt 1964 · S/N 21058418N10URXtiri LLC · St George, UTBuilt 1955 · S/N 32184N10WQQuirion Paul J · Fairbanks, AKBuilt 1956 · S/N 33310N1100Souchet Brian · Fleming Island, FLBuilt 1956 · S/N 29178N1100SHagen Johnny D · Claremore, OKBuilt 1958 · S/N 55410N1101CHampton Brock W · Wichita, KSBuilt 1977 · S/N 17702673N1102CWakefield Aviation LLC · Mahopac, NYS/N 17702674N1102FGrant County State Bank · Carson, NDBuilt 1966 · S/N 17254697N1102YSass James Louis Jr · Abilene, TXBuilt 1962 · S/N 15059502N1103DOber John A · Candor, NYBuilt 1950 · S/N 15663N1104DRymill Mark R · Belmont, CABuilt 1950 · S/N 15664N1104FMiller Jonathan A · Apo, APBuilt 1966 · S/N 17254699N1105CLandon Jeff · Lancaster, CABuilt 1977 · S/N 17702675N1105DGilman Larry E · Reno, NVBuilt 1950 · S/N 15665N1105FGibbard Donald R · Walla Walla, WABuilt 1966 · S/N 17254700N1106DMurdock Mark F · Ketchikan, AKBuilt 1950 · S/N 15666N1107FMedic Choppers LLC · Springdale, ARS/N 17254702N1108DReddout Terry L Trustee · Wichita, KSS/N 15668N1108FAom Aircraft LLC · Wilmington, DES/N 17254703N1109DMcqueen Alan G · Cocoa, FLFirst renewal noticeBuilt 1950 · S/N 15669N1109MPatrick Chris J · Paris, ILBuilt 1970 · S/N 33701309N1109YKoller Keith S · Grosse Ile, MIBuilt 1962 · S/N 15059509N110FSMaggie L Air Service LLC · Kalispell, MTS/N 18256604N110PFUniversity Of Detroit Flying Club Inc · Livonia, MIS/N 17702629N110SMPenhall Michael Joseph · Lake Forest, CABuilt 1964 · S/N 337-0023N110USZwainz Thomas G · Reardan, WABuilt 1970 · S/N 18260234N110VSbur David A · Vancouver, WABuilt 1946 · S/N 8748N110XPlayter Bud W DBA · Gowen, MIFirst renewal noticeBuilt 1946 · S/N 10449N11103Hennigan Shellie · Jonesboro, LAS/N 17702325N1110FSallade William L · Coudersport, PABuilt 1966 · S/N 17254705N11118Aircraft Partner Holdings Inc Trustee · Fallbrook, CABuilt 1963 · S/N 18051230N1111YAeronautical Technical Service Inc · Collierville, TNBuilt 1962 · S/N 15059511N1112DMurray Russell J · Fresno, CAS/N 15676N1112HStrojny Andrew P III · Medina, OHS/N 56188N1112TRegistration Pending · Soldotna, AKRegistration pendingBuilt 1964 · S/N 50713N1113YPrecision Design Inc · Weatherford, OKS/N 15059513N1114FRegistration Pending · Florence, SCRegistration pendingBuilt 1966 · S/N 17254709N1114TQuellette James L · Plymouth, CTBuilt 1965 · S/N 15061846
Back to AD 2004-19-01