OpenAirDocs.org
AD 2012-04-10

Registered aircraft · 175

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

N1000HMumm Scott A · Brodhead, WIBuilt 1948 · S/N 15AC-2N1003HLight Winds Aviation LLC · Bay City, MIBuilt 1948 · S/N 15AC-5N1005HMaier Dennis J · Morristown, SDBuilt 1948 · S/N 15AC7N1009HHardey John R · Wasilla, AKBuilt 1948 · S/N 15AC-11N1010HA2 Aero LLC · Ann Arbor, MIBuilt 1949 · S/N 15AC-347N1011HUlm Gabrielle Nicole · North Pole, AKBuilt 1948 · S/N 15AC-13N1013HWhite Theodore F · Willow, AKBuilt 1948 · S/N 15AC-15N1028HConnell Michael J · Decorah, IABuilt 1948 · S/N 15AC-31N1031HHardy John R · Wasilla, AKBuilt 1948 · S/N 15AC-34N1034HBuergel Sandra J · East Aurora, NYBuilt 1948 · S/N 15AC-37N1035HKnapp Louis L · Fairbanks, AKBuilt 1948 · S/N 15AC-38N1045HFairbanks Paul · Chugiak, AKS/N 15AC51N1048HBeuschel Timothy W · Mount Pleasant, WIS/N 15AC-59N1049HSavage David E · American Falls, IDBuilt 1948 · S/N 15AC-62N1051HPoulter John W · Sharpsburg, GABuilt 1948 · S/N 15AC-66N1052HFay Bernard E · Eagle, AKBuilt 1948 · S/N 15AC-69N1054FGilson Gareth F · Phoenix, AZS/N 15AC-68N1055HReddell Justin · Jasper, ARBuilt 1948 · S/N 15AC-70N1060HJohnston Jeffery A · Eagle River, AKBuilt 1948 · S/N 15AC-76N1067HAmerell Kathryn · Wasilla, AKS/N 15AC-86N1070HGeary Charles L · Wasilla, AKBuilt 1948 · S/N 15AC-89N1071HBeck Douglas J · Bloomington, MNBuilt 1948 · S/N 15AC-90N1072HBeckman Thomas J · Pocahontas, ARBuilt 1948 · S/N 15AC-91N1075HBartholomew Dana C · Madison, WIBuilt 1948 · S/N 15AC-94N1077HHadley Everett F · Dayville, CTBuilt 1948 · S/N 15AC-96N1083HHead Wesley J · Homer, AKBuilt 1948 · S/N 15AC-102N1088HAerotechniques LLC · South Kent, CTBuilt 1948 · S/N 15AC-52N1091HHuber Gregory A · Medina, OHBuilt 1948 · S/N 15AC-112N1096HRegistration Pending · Wasilla, AKRegistration pendingBuilt 1948 · S/N 15AC-116N1097HPoulter Thomas R · Chelsea, MIBuilt 1948 · S/N 15AC-117N1099HTzenis Michael · Lakeville, MNBuilt 1948 · S/N 15AC-119N1105HMaya Aviation LLC · Lee, NHBuilt 1948 · S/N 15AC-125N1114HKendall John · Three Lakes, WIS/N 317N1115HSmitholum Adam O · Tok, AKS/N 15AC-135N1118HNelson Chester C · Little Falls, MNS/N 15AC-134N1122HEdge Derek Thomas · Center Barnstead, NHBuilt 1948 · S/N 15AC-137N1124HNolan Robert C II · Las Vegas, NVBuilt 1948 · S/N 15AC-139N1125HClark David D · Nenana, AKBuilt 1948 · S/N 15AC-140N1131HLeisner David L · Palmer, AKBuilt 1948 · S/N 15AC-146N1132HWallis Frederick W · Healy, AKBuilt 1948 · S/N 15AC-145N1134HFeldhusen Lawrence E · Yankeetown, FLBuilt 1948 · S/N 15AC-148N1135HSale Reported · Fort Smith, ARSale reportedBuilt 1948 · S/N 15AC-151N1136HMusgrove Louis A Jr · Cumming, GABuilt 1948 · S/N 15AC-144N1138HAgaliotis Paul E · San Martin, CABuilt 1948 · S/N 15AC-149N1142HSimmons Donald E · Clifton Park, NYBuilt 1948 · S/N 15AC-153N1148HReed Charles H · Shelbyville, KYBuilt 1948 · S/N 15AC-163N1152HWeiler Coen A · Ashville, OHBuilt 1948 · S/N 15AC-165N1154HLechner Burdette J · Kodiak, AKBuilt 1948 · S/N 15AC-167N1162HRegistered aircraftBuilt 1948 · S/N 15AC-175N1163HMiller William A · Williamson, GABuilt 1948 · S/N 15AC-176
Back to AD 2012-04-10