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.

N103DLDunwoody Duane E D · Savage, MNS/N 55913N103PBBentley Jeffrey W · Kenmore, WABuilt 1957 · S/N 34372N103SGJared William C · Valparaiso, INBuilt 1958 · S/N 17004N10410Clark George A · Worcester, MABuilt 1975 · S/N 17702321N10420Kinney Powell Mcvay · Coppell, TXBuilt 1975 · S/N 17702324N1042GPorter David G · Stuart, FLS/N 36704N10433Sodak Angus Inc · Reva, SDBuilt 1951 · S/N 20128N1044DMcadam Charles T · Wichita, KSBuilt 1951 · S/N 7656N1044GVoelkerding William Michael · Fairbanks, AKS/N 14403N1044SHubbell Wallis E · Tucson, AZS/N 52829N104AFNance David B · Quinton, VABuilt 1967 · S/N 17700238N104BU1984k LLC · Gypsum, COS/N 18254352N104FDDippolito Michael M · Norristown, PABuilt 1968 · S/N 15068727N104JVPryor Michael C · Riverview, FLBuilt 1967 · S/N 15066392N104KJb Aircraft LLC · Anchorage, AKBuilt 1969 · S/N 20700122N104NRMiller Dale D · Eagle River, AKBuilt 1966 · S/N 18051693N104PMPats Offroad Inc · Mitchell, SDS/N 18258085N104RCChan Ronald G · Anchorage, AKBuilt 1966 · S/N 1851098N104SKAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1969 · S/N 15071907N1050VState Of Wisconsin · Madison, WIBuilt 1968 · S/N 18051966N10534Shergi Nikolai W · Franklin, INS/N 15697N1058DMorley Philip · Manhattan Beach, CABuilt 1951 · S/N 7670N1058MAir Combat Museum · Springfield, ILBuilt 1969 · S/N 15070998N1059RDoyle Brian G · Windsor, MABuilt 1958 · S/N 55629N105DPPulscher Brian J · Sand Springs, OKBuilt 1968 · S/N 15068960N105RDSunny Slope Aviation LLC · Adams, TNBuilt 1967 · S/N 17256221N1067MShore Enterprises Of Gainesville LLC · Gainesville, FLBuilt 1970 · S/N 21059367N1069LWilson Michael A · Everett, WABuilt 1956 · S/N 33633N106RGCadena Edward R Jr · Houston, TXBuilt 1966 · S/N 18257535N106UMiha LLC · Dover, DEBuilt 1956 · S/N 32325N1071MJesperson Kenneth R · Ekalaka, MTBuilt 1969 · S/N T210-0451N1073YGoedicke Walter H Jr · Bay Head, NJBuilt 1956 · S/N 28277N1074DBarron Aviation LLC · Perry, MOBuilt 1951 · S/N 7686N10769Waddingham William B · Rancho Cucamonga, CAS/N 17557025N1077DBarron Aviation LLC · Perry, MOS/N 7689N107PSLadies In Aviation LLC · Mocksville, NCBuilt 1965 · S/N 17253618N107SKFitzpatrick William M · Cleveland, GABuilt 1973 · S/N 17702004N107WFWilcox Farms Inc · Roy, WABuilt 1961 · S/N 18253149N1080DLindsey Paul Robert · Quinlan, TXBuilt 1951 · S/N 7692N1081DMilton William H · Amsterdam, NYBuilt 1951 · S/N 7693N1081WPeck Alan W · Chattanooga, TNBuilt 1964 · S/N 15060338N1082PGarrett James D Jr Trustee · Coolidge, AZBuilt 1968 · S/N 18258855N1086LLade Burton G · Bemidji, MNBuilt 1959 · S/N 50564N108CCFlaugher Jonathan S · Poquoson, VABuilt 1965 · S/N 3370202N108EENorthwood Services Inc · Skwentna, AKBuilt 1956 · S/N 32505N108GWPope James D · Clarkston, WAS/N 32683N108SPDale County Sheriffs Office · Ozark, ALS/N 18260052N108TSHesser Dale W · Cardington, OHBuilt 1952 · S/N 20328N1096DDaugherty Lowell E · Adelanto, CAS/N 7720N1098DDoyle Terry · Grapevine, TXS/N 7710
Back to AD 2004-19-01