OpenAirDocs.org
AD 89-24-01 R1

Registered aircraft · 4,242

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:89-24-01-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:89-24-01-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.

N959TXAhern John · Prosper, TXBuilt 1977 · S/N 414A0011N95BHSale Reported · Lacombe, LASale reported, canceledBuilt 1975 · S/N TJ-29N95JRKaiser Dennis · Portland, MEBuilt 1980 · S/N 18504074N95TFSage Mgmt LLC · Carefree, AZBuilt 1981 · S/N U20606137N95VPVarsity Produce Sales Inc · Bakersfield, CABuilt 1980 · S/N EA-114N95WHPage William R · Bermuda Dunes, CABuilt 1978 · S/N TK-86N9604GRoberts Development Company Inc · Tucson, AZBuilt 1972 · S/N U20601804N9607YIsn Aviation LLC · Loup City, NEBuilt 1981 · S/N 21064559N960DFAir Services International Leasing LLC · Fort Lauderdale, FLBuilt 1979 · S/N 414A0444N9612RBearnose II LLC · Edina, MNBuilt 1985 · S/N U20606901N9613GDavid W Easter Consulting Inc · Libby, MTBuilt 1972 · S/N U20601813N9614KPassmore Stephen B · Lacrosse, WABuilt 1983 · S/N T18803962TN9632ZAngelone Inc · Elkhart, INS/N U20606585N96335Cysewski Roxanne Trustee · Rllng Hls Est, CABuilt 1983 · S/N EA-400N9635CAirmans Aviation Co Ltd · Fort Smith, ARBuilt 1983 · S/N T30300196N9636YCarranza Chris J · Stanfield, AZBuilt 1981 · S/N 21064566N9643ZAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1982 · S/N U20606594N9649GAllen Todd N · Mccall, IDBuilt 1977 · S/N U20603819N966UBTex Ark Air Corp · Melissa, TXBuilt 1977 · S/N TJ-120N9674GN1705r Inc · Cobb, CAS/N U20601874N9691ZSouth America Mission Inc · Fort Mill, SCBuilt 1982 · S/N U20606611N969SRivas Group LLC · Reno, NVBuilt 1975 · S/N 310R0318N969SLWojcik Bart C · Kimberly, IDBuilt 1975 · S/N 21060915N969THMgi Proflight LLC · Las Vegas, NVBuilt 1978 · S/N 310R1379N969TXMowata Farms LLC · Mamou, LAS/N P21000145N96LLHuck-Mag LLC · Plano, TXBuilt 1974 · S/N 21060361N96PTEidson Mark C · Weatherford, TXBuilt 1976 · S/N TJ-31N96RHAtlanta Aircraft Group LLC · Atlanta, GABuilt 1981 · S/N P21000720N9700JCrux Logistics & Consulting Ltd · Las Vegas, NVBuilt 1981 · S/N T18803840TN9707JTop Hand Inc · Laurel, MTBuilt 1981 · S/N T18803842TN973SThompson Peter L · Portales, NMBuilt 2001 · S/N EA-688N9746YAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1981 · S/N 21064585N9748ZKerr Kenneth E · Bakersfield, CAS/N 21060943N974RCRafael Cisneros LLC · Wilmington, DEBuilt 1981 · S/N 21064459N9770MStr Holdings LLC · Lafayette, INBuilt 1978 · S/N U20604564N97AHKw Air LLC · Fallbrook, CABuilt 1980 · S/N EA-107N97DFFlying G Aviation LLC · Elizabeth, COBuilt 1978 · S/N 340A0510N97EKern County Sheriffs Department · Bakersfield, CABuilt 1983 · S/N 21064788N97HCAlpha Whiskey 1 LLC · Brandon, MSBuilt 1976 · S/N 310R0651N97JKAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1978 · S/N 414A0052N97VCSababa Aviation LLC · West Palm Beach, FLBuilt 1985 · S/N TJ-495N980AMC&P Aircraft Holdings LLC · Nacogdoches, TXS/N 340-0518N980SCSky Horse LLC · Santa Cruz, CABuilt 1982 · S/N 21064774N981AKState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606248N981DMMartin David E · Dallas, TXBuilt 1975 · S/N 340A0028N981WBFlying Fortress Of Swfl LLC · Fort Myers, FLS/N U20606221N983DBBunke Jim Bradley · Denver, COBuilt 2000 · S/N EA-657N983JBConstellation Aviation LLC · Rock Springs, WYBuilt 1978 · S/N 340A0453N9843YCavu Solutions LLC · Renton, WABuilt 1981 · S/N 21064616N9848MCovington Aircraft Engines Inc · Okmulgee, OKBuilt 1978 · S/N U20604575
Back to AD 89-24-01 R1