AD 74-08-01

Registered aircraft · 10,878

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:74-08-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:74-08-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.

N112APAerospace Trust Management LLC Trustee · Wilmington, DES/N 17262038N112GCSkywagon Ventures LLC · Chapel Hill, NCBuilt 1973 · S/N 18052387N112NCFrance Jay D · Colbert, GABuilt 1970 · S/N 17701598N112SSOlsen John · Wasilla, AKS/N 18052510N1130UTc Aviation LLC · Denham Springs, LAS/N 17266859N1131MWhite Tom · South Charleston, WVBuilt 1975 · S/N 18264228N1131WPrice Steven D · Healdsburg, CABuilt 1976 · S/N 18264584N11330Leikala Douglas A · Fairport Harbor, OHBuilt 1975 · S/N 17702332N1133UMustachio Donald · East Stroudsburg, PABuilt 1976 · S/N 17266862N1134UWells William L · Santa Cruz, CABuilt 1976 · S/N 17266863N11368Adkins Ian B · Dahlonega, GABuilt 1975 · S/N 17702333N11378Registered aircraftBuilt 1975 · S/N 17702335N1137UFoscap Air LLC · Las Vegas, NVBuilt 1976 · S/N 17266866N1139MMarshall J B · Talbott, TNBuilt 1975 · S/N 18264230N1139UFettig Peter J · Bismarck, NDBuilt 1976 · S/N 17266868N113BAPreston Richard R Trustee · Albuquerque, NMBuilt 1975 · S/N 17266046N113BHBighorn Airways Inc · Sheridan, WYBuilt 1967 · S/N 18051844N113DRCalifornia In Nice Inc · San Jose, CABuilt 1975 · S/N 17265961N113FSHallahan Robert J · Central Square, NYBuilt 1974 · S/N 17262996N113SGRac Global Aircraft Consulting LLC · San Marcos, CABuilt 1976 · S/N 18264758N1141MSunshine Flyers · Auburn, CAS/N 17260152N1141UFlight School Inc · Spring, TXBuilt 1976 · S/N 17266870N11429Schwartz David J · Bellaire, MIBuilt 1975 · S/N 17702338N1143MCastelletti Mark Anthony Trustee · Casa Grande, AZBuilt 1970 · S/N 17259443N1144MCcr Aviation LLC · Kalispell, MTS/N 17259444N1146MMitchell Kenneth A · Uniontown, PABuilt 1972 · S/N 33701446N11476Shannon Kenneth H · Washington, DCBuilt 1975 · S/N 17702340N114HVAerowerks LLC · Georgetown, TXBuilt 1973 · S/N 421B0371N11500Semmes James · El Centro, CABuilt 1975 · S/N 17702342N11506Fidk Inc · Warrenton, VABuilt 1975 · S/N 17702343N1152MRst Aviation LLC · Vero Beach, FLBuilt 1970 · S/N 17259452N11564Ajw Management LLC · Scottsdale, AZBuilt 1975 · S/N 17702347N11566Monterrosa Frank J · Lincoln, CABuilt 1975 · S/N 17702348N1157MWhf Aviation LLC · Jamestown, OHBuilt 1975 · S/N 18264235N1157QRrc Inc · Madison, MSBuilt 1975 · S/N U20602848N1157WAdams Chad D · Dayton, ORBuilt 1970 · S/N U20601578N11585Registered aircraftS/N 17702349N11596Tagart Charles · Senoia, GAS/N 17702352N115CWWhitlock Gary D · Melbourne, FLBuilt 1974 · S/N 21060520N115KVKva Electric Inc · Arlington, WAS/N 18261214N11600Nolan James B · Chandler, AZBuilt 1975 · S/N 17702354N11608Aircraft Trade Group LLC · Scandia, MNBuilt 1975 · S/N 17702357N11625Oil Region Aviators LLC · Titusville, PABuilt 1975 · S/N 17702360N1162CReemts Randy G · Alexandria, MNBuilt 1977 · S/N 17702678N1165MArsene Eddy R · Lynnwood, WAS/N 18264237N1165UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17266872N1166MWarren Gregory C · Redmond, ORBuilt 1975 · S/N 18264238N116AKLucas Kelly W · Wasilla, AKBuilt 1965 · S/N 18051469N116CRConti Christine M · Plantation, FLBuilt 1976 · S/N 17266985N116EALewistown Aviation Inc · Lewistown, PABuilt 1979 · S/N 340A0750
Back to AD 74-08-01