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.

N10HGGerardy Harlan D · Gruver, TXBuilt 1974 · S/N 21060169N10HLHoyt Robert H Trustee · Canby, ORBuilt 1975 · S/N 21060646N10XCMontgomery Jerry J Jr · Charlotte, NCBuilt 1972 · S/N 17260749N10XEBlaikie Thomas B · Kenner, LAFirst renewal noticeBuilt 1973 · S/N 340-0221N10YSeitz William D · Gordonville, TXBuilt 1972 · S/N 21059697N1101CHampton Brock W · Wichita, KSBuilt 1977 · S/N 17702673N1102CWakefield Aviation LLC · Mahopac, NYS/N 17702674N1102MEls Dennis J · Centralia, ILBuilt 1970 · S/N 17259492N1103MFlying M Enterprises · Loomis, NEBuilt 1970 · S/N 17259493N1104MCarrolls Auto & Aircraft LLC · Muncie, INS/N 17259494N1105CLandon Jeff · Lancaster, CABuilt 1977 · S/N 17702675N1109MPatrick Chris J · Paris, ILBuilt 1970 · S/N 33701309N1109USky Quest Inc · Wilmington, DEBuilt 1976 · S/N 17266849N110AUHernandez-Santiago Ruben A · Ponce, PRBuilt 1975 · S/N 17265538N110BXCk Leasing Services LLC · Wilmington, DEBuilt 1974 · S/N 17263746N110CSFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1972 · S/N 310Q0616N110DHYingling Consultation LLC · Wilmington, DES/N 421B0137N110DWSlater Spray Service Inc · Maddock, NDBuilt 1974 · S/N 177RG0495N110PFUniversity Of Detroit Flying Club Inc · Livonia, MIS/N 17702629N110RLProctor Charles L · Alachua, FLBuilt 1973 · S/N P3370095N110SBCreamer Leon Eugene · West Jefferson, OHS/N 17259488N110TKSchnorf Curt L · Centerview, MOS/N 18262939N110USZwainz Thomas G · Reardan, WABuilt 1970 · S/N 18260234N110YDLloyd Clee · Canby, ORBuilt 1975 · S/N 21060858N11103Hennigan Shellie · Jonesboro, LAS/N 17702325N1110SMob Aviation USA LLC · Kissimmee, FLS/N 21061119N11115Crist Steve · Reno, NVS/N 17262410N1115UAvian Leasing LLC · Bremerton, WABuilt 1976 · S/N 17266851N11172Skaaire Society · Madison, WIBuilt 1975 · S/N 17702327N1117UBhp Aviation · Santa Clara, CABuilt 1976 · S/N 17266852N111BXDonadio Robert F · Amherst, NHBuilt 1972 · S/N 414-0368N111CJRegan Dennis W · Rochester, MNFirst renewal noticeBuilt 1973 · S/N 18262621N111CYSmody Michael S · Neelyville, MOBuilt 1974 · S/N 18263183N111DEPespisa John · Hacienda Heights, CABuilt 1973 · S/N 18262712N111GFHuggins Stephen M · Eagle Creek, ORBuilt 1975 · S/N 18263578N111GTMorgan Gerald W · Hillsboro, TXS/N 340-0188N111KBSale Reported · Mexico D FSale reportedS/N 18261460N111RRCook David C · Orlando, FLBuilt 1973 · S/N 18261539N111SA111sa LLC · Greeley, COBuilt 1972 · S/N 17260937N111TFPacific Aviation Aircraft Management Inc · Ontario, ORBuilt 1974 · S/N 421B0660N111TLNdk Global Holdings Corp · Dover, DEBuilt 1974 · S/N 421B0645N111WLCj Aero LLC · Fort Valley, VABuilt 1973 · S/N 18052407N1120VKodiak Marine Construction · Oakley, IDBuilt 1976 · S/N U20603130N11226Box Jon A · Carrizo Springs, TXBuilt 1975 · S/N 17702329N1123MGrey Robert J · La Madera, NMBuilt 1975 · S/N 18264227N1124MRegistration Pending · West Branch, MIRegistration pendingS/N 17259804N1126MD2 Government Solutions LLC · New Bern, NCBuilt 1971 · S/N 17259803N11271No Coop Cardinal LLC · Sonoma, CABuilt 1975 · S/N 17702330N1128UElw Inc · Bonners Ferry, IDBuilt 1976 · S/N 17266857N1129USchroeder Herbert D · Plano, TXBuilt 1976 · S/N 17266858
Back to AD 74-08-01