OpenAirDocs.org
AD 89-24-01 R1

Registered aircraft · 4,243

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.

N38CMSale Reported · Fay-Aux-LogesSale reportedBuilt 1979 · S/N 340A0901N38GJMonahan Jeffrey L Trustee · Long Beach, CABuilt 1982 · S/N 414A0829N38LPN38lp LLC · Jacksonville, FLBuilt 1977 · S/N 414-0960N38NTYorkavitz James B · Valley City, OHBuilt 1980 · S/N TJ-270N38PFSycan Corp DBA · Paso Robles, CABuilt 1980 · S/N 21063979N38PKDeininger Robert · Apopka, FLS/N EA-467N390RSSchoene Edward C · Springfield Center, NYBuilt 1976 · S/N 21061514N3912PRegistered aircraftBuilt 1978 · S/N P21000074N391PT7640 Drilling LLC · Amarillo, TXBuilt 1973 · S/N 21060097N3936GBaker George G · Junction City, ORBuilt 1976 · S/N 340A0237N393DW3 Delta Whiskey LLC · Superior, WIBuilt 1979 · S/N U20605261N39501Registration Pending · Phoenix, AZRegistration pendingBuilt 1982 · S/N U206-06452N3959POmaha Aircraft LLC · Blair, NES/N P21000075N3968QTundra Wings Ministries · Wasilla, AKBuilt 1975 · S/N U20603037N396BSpring Creek Financial Inc · Lewistown, MTBuilt 1992 · S/N EA-537N397AWPapa Tango Aviation LLC · Kalispell, MTBuilt 1980 · S/N TJ-207N3983GBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N 340A0255N398LJDakota Heavy Equipment · Fargo, NDBuilt 1988 · S/N EA-471N3992GFlat Earth LLC · Kalispell, MTS/N U2060992N3995GCutting Edge Design & Contracting-Sc Inc · Elgin, SCBuilt 1968 · S/N U206-0995N399CAHoman Mark A · Wake Forest, NCBuilt 1988 · S/N EA-478N399KMCustodio Olga · San Antonio, TXBuilt 1973 · S/N 21059982N39BTMidwest Aerial Photography · Galloway, OHBuilt 1974 · S/N 310Q1137N39DDLarson Danny O · Palmer, AKBuilt 1973 · S/N 340-0246N39HCTherapy Air LLC · Midland, TXS/N 414-0469N39TKCold Water Aviation LLC · Wabasso, MNBuilt 1983 · S/N EA-394N3CYSchultz Daniel A · Tipp City, OHBuilt 1972 · S/N P3370022N3DQCrescent Aviation LLC · Rllng Hls Est, CAFirst renewal noticeBuilt 1970 · S/N 414-0056N3ELTwo If Buy LLC · Nashua, NHBuilt 1978 · S/N 340A0525N3EM3em LLC · Karnack, TXBuilt 1981 · S/N P21000722N3HKInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 340-0538N3KKKraussman Daniel J · San Antonio, TXBuilt 1978 · S/N 21062752N3KPAllied Asset Management LLC · Oklahoma City, OKBuilt 1981 · S/N P21000653N3LNAllen Jeffrey W · Crestwood, KYBuilt 1973 · S/N 340-0301N3QASg&F LLC · Riverside, CABuilt 1984 · S/N EA-427N3UCYahraus Andrew · Phoenix, AZBuilt 1981 · S/N TJ-337N3VACook Marvin R · Portales, NMS/N 414-0258N3VBHarrison Ted W · Grapevine, TXBuilt 1965 · S/N 320D0044N3WFFolk Wolfgang · Fairfield, CABuilt 1975 · S/N 414-0617N400APZoie Air LLC · Fort Lauderdale, FLBuilt 1974 · S/N 340-0345N400ATAlpha Tango Aviation Inc · Middletown, DEBuilt 1981 · S/N 402C0510N400GMN400gm LLC · Salisbury, MDBuilt 1974 · S/N 310Q1000N400WTArtspret Aviation LLC · Sugar Grove, ILBuilt 2001 · S/N EA-690N401AZTre Aviation Corp · Wilmington, DEBuilt 1969 · S/N 401B-0018N401CAGlenn Roger H · Pacifica, CABuilt 1969 · S/N 401A-0025N401MPFriend Ships · Lake Charles, LABuilt 1979 · S/N P21000280N401MROk Av8r LLC · Iowa Park, TXBuilt 1967 · S/N 401-0159N401SXHyannis Air Service Inc · Hyannis, MAS/N 402C0447N401TJHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0109N401WMMrd Aero LLC · Manheim, PABuilt 1972 · S/N 401B0219
Back to AD 89-24-01 R1