AD 75-12-06

Registered aircraft · 2,232

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

N400WLHammer Construction Corp · Miami, FLBuilt 1965 · S/N 26-148N400YKarschney Rich · Seattle, WABuilt 1965 · S/N 26-101N40193Rearden Logic Inc · Denver, COBuilt 1959 · S/N 24-1239N409LAAnderson Wilma (Lori) · Blue Mound, ILS/N 24-1494N40JSAir Flight Enterprises Inc · South Daytona, FLS/N 24-3269N40RSSaul Gregory D Jr · Glenrock, WYBuilt 1960 · S/N 24-2031N40VKSimply Living LLC · Fort Myers, FLBuilt 1966 · S/N 24-4473N417BHHugel Bohdan · Selma, NCBuilt 1962 · S/N 24-3108N41AEBowen Haldor S · Sandpoint, IDS/N 24-637N41LPulliam Oscar E Jr · Moscow, TNBuilt 1958 · S/N 24-351N4236PRegistration Pending · Chandler, AZRegistration pendingS/N 24-1260N4250Leafgreen Jeff A Trustee · Lander, WYBuilt 1959 · S/N 24-894N4284Clements Eric C · Sheridan, WYBuilt 1965 · S/N 24-4284N430MMMersereau Iden H · Goodyear, AZBuilt 1966 · S/N 24-4525N431ABAirtrust LLC - 18 - Series 18 Trustee · Sheridan, WYS/N 24-4156N434BBElgin Engineering LLC · Arlington, TXBuilt 1966 · S/N 24-4536N43TLT M L Aircraft Inc · Narrowsburg, NYBuilt 1971 · S/N 24-5001N4483CRich Aden Gene · Sequim, WABuilt 1959 · S/N 24-1257N44PCGenocchio Anthony F · New Port Richey, FLBuilt 1965 · S/N 24-4124N4563VMercer Alexander David · San Diego, CABuilt 1958 · S/N 24-129N456PBooth Donald V · Denison, TXS/N 24-3276N45888D-Five Holdings Group LLC · Vidor, TXBuilt 1963 · S/N 24-3453N45MBWright Kelly A · Spokane, WABuilt 1959 · S/N 24-1445N46MJones Gregory D · Pueblo, COBuilt 1958 · S/N 24-411N46PHarrison Donna J · Eau Claire, MIBuilt 1966 · S/N 24-4470N478WTBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 24-4634N47BBRogers Joseph O III · Fernandina Beach, FLBuilt 1960 · S/N 24-1889N487SCRegistered aircraftBuilt 1959 · S/N 24-1346N4960250 Inc · Washington, DCS/N 24-4025N4995BStobbe Marlin L · Granada Hills, CAS/N 24-4501N4CBDream Catcher Company LLC · Center, COBuilt 1964 · S/N 24-3607N4PLJuliet Kilo Aviation LLC · Palos Heights, ILBuilt 1961 · S/N 24-2400N4XNMiller Donald W · Harrisonburg, VABuilt 1971 · S/N 244990N5002POrtman Bernard · Deer Park, TXBuilt 1957 · S/N 24-5N5003PLouwagie Bradley J · Marshall, MNFirst renewal noticeBuilt 1957 · S/N 24-6N5005PRackley William R Jr · Grand Island, FLBuilt 1957 · S/N 24-8N5006PWright William · Cleveland, OKBuilt 1957 · S/N 24-9N5008PThree Chicks Aviation LLC · Benton, LAS/N 24-11N500AVInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 24-4805N500PFord Charles D · Clifton, TNS/N 24-341N5014PSky Valley Aviation LLC · Waverly, IAS/N 24-17N5017PPineapple Air LLC · Wilmington, DEBuilt 1957 · S/N 24-20N5020PThurston Steven C · Salisbury, NCBuilt 1958 · S/N 24-23N5029PJordan Walter B · Chehalis, WABuilt 1958 · S/N 2432N5034PNeufeld William J · Bostwick, FLBuilt 1958 · S/N 24-37N503JALiem David H · Brea, CABuilt 1965 · S/N 24-4165N5045PMccarty Paul S · Wichita, KSBuilt 1958 · S/N 24-49N5048PBrown Mark E · Charlotte, NCBuilt 1958 · S/N 24-52N5050PBoucher Bobbi · Fredericksburg, VAS/N 24-54N5051PGrorud James R · Milbank, SDBuilt 1958 · S/N 24-55
Back to AD 75-12-06