AD 94-05-05 R1

Registered aircraft · 26,230

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:94-05-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
  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.

N89952Striegel William H II · Spangle, WABuilt 1946 · S/N 9004N89954Aviation Consulting Management Enterprises LLC · Bryant, ARBuilt 1946 · S/N 9006N89958Frets Jason G · Gainesville, GABuilt 1946 · S/N 9010N89959King Mark R · Oxnard, CABuilt 1946 · S/N 9011N8995BSommerfeld David A · Assaria, KSBuilt 1958 · S/N 36695N8995UKelley Aircraft LLC · Weyers Cave, VABuilt 1976 · S/N 15078045N89965King Aubrey R · Salinas, CABuilt 1946 · S/N 9017N89968Warwick Dakota R · Jupiter, FLS/N 9020N8996BGartrell Kirk W · Amarillo, TXBuilt 1958 · S/N 36697N89973Seward Leasing Inc · Guthrie, OKBuilt 1946 · S/N 9025N89974Mulvania Rodney A · Linn, MOBuilt 1946 · S/N 9026N89977Hampton Stephen L · Culbertson, MTBuilt 1946 · S/N 9029N89978Wilson Keith · Los Lunas, NMBuilt 1946 · S/N 9030N8997SRed Barn Ag & Home Inc · Westville, OKBuilt 1966 · S/N 15062297N89982Kiper Kaleb · Fairbanks, AKBuilt 1946 · S/N 9034N89988Carpentier Michael · Moses Lake, WABuilt 1946 · S/N 9040N8998BValles Rick James · Albuquerque, NMS/N 36698N89990Arbie Melvin J · Lake City, FLBuilt 1946 · S/N 9042N89993Mossman Andrew Douglas · Pickerington, OHS/N 9047N89996Stauffer Bradley E · Milford, NEBuilt 1946 · S/N 9050N89999Moreus Steven P · Sunfish Lake, MNBuilt 1946 · S/N 9053N8999BRacoon Aviation LLC · San Antonio, TXBuilt 1958 · S/N 36699N8999SLewis Darrell K · Morehead, KYBuilt 1965 · S/N 15062299N89EZWinward John · Long Beach, CABuilt 1979 · S/N 1600N89HPMorgan Howard P Jr · Longmont, COBuilt 1975 · S/N 15077395N89RSRutan Aircraft Flying Experience · Brookshire, TXS/N 1341N89RZZimmerman Gregory J · Iowa City, IABuilt 1989 · S/N 2615N89WWAley Jeffrey S II · Granby, COBuilt 1967 · S/N 17255978N89XBScofield Bruce W · Batavia, NYBuilt 1941 · S/N 7031N8BAHoffman Schuyler · Brighton, COBuilt 1964 · S/N 17251805N8CXDinius Jeffrey H · Kaufman, TXBuilt 2005 · S/N TM36N8CZRey Thomas A · Fort Worth, TXBuilt 1961 · S/N 5761N8EDBlueskys Inc · Wilmington, DEBuilt 2001 · S/N 02458N8EWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1982 · S/N 101N8JDClevenger Jim B · Kissimmee, FLBuilt 1949 · S/N 8N8JMOrion Ventures LLC · Kalispell, MTBuilt 2011 · S/N 16200117N8KKEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1953 · S/N 3N8MRSolis Dan A · Fresno, CABuilt 1983 · S/N 001N8NTDegerlund Elmer · Fairbanks, AKBuilt 1953 · S/N 25841N8PWMiranda Alexander · Homestead, FLBuilt 1969 · S/N 15071312N90000White Steven M · Grapevine, TXBuilt 1946 · S/N 9000N90004Forthofer Richard · King Salmon, AKBuilt 1946 · S/N 9058N90007Emerson Byron D · Sisters, ORBuilt 1946 · S/N 9061N9000BHanna Ryan D · Berthold, NDBuilt 1957 · S/N 7EC-623N9000UWhitaker Robbie L · Brooklet, GABuilt 1976 · S/N 15078050N90025Hoffman David G · Givens Hot Springs, IDBuilt 1946 · S/N 9083N90028Seiler Elliott R · Green Bay, WIS/N 9086N9002BWicklander Richard O · Spanaway, WABuilt 1957 · S/N 7FC-99N9002RSmith Terry L · Atoka, TNS/N 28597N90034Hawkins Rayma J · Little Rock, ARBuilt 1946 · S/N 9092
Back to AD 94-05-05 R1