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.

N771BB406 Mountain Air LLC · Bigfork, MTS/N EA619N771EAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0046N771MPFl072 Aviation LLC · Brentwood, TNBuilt 1974 · S/N 340-0368N772MCayle Jonathan · Rochester, MIBuilt 1979 · S/N EA-14N772MDMary Rabbit LLC · Saratoga, CABuilt 1997 · S/N EA-605N7736KValiair Lc Trustee · Casper, WYBuilt 1979 · S/N P21000420N774CSWyo Ventures LLC · Buffalo, WYBuilt 1976 · S/N 21061359N774DCBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 340A0206N774RDDemuth Roger C Trustee · Valley View, TXBuilt 1974 · S/N 21060229N7750QJohnson Gregory L · Orange, CABuilt 1973 · S/N 340-0200N77555Hmc Aero LLC · Ayer, MABuilt 1974 · S/N 340-0359N7758BMiller Jeffrey A Trustee · Tucson, AZBuilt 1982 · S/N TJ-394N775RCAirswiss Inc · Wilmington, DEBuilt 1980 · S/N 402C0311N775ZHundal Medical Corp · Malibu, CABuilt 1980 · S/N TJ283N776DSullivan Dennis · Santa Ana, CABuilt 1969 · S/N D-9063TN776TMAero Performance LLC · Scooba, MSBuilt 1976 · S/N 21061480N7774BAdair Aviation LLC · Broken Arrow, OKBuilt 1981 · S/N U20606224N7776HAcevedo Adriel · San Antonio, TXBuilt 1976 · S/N 21061194N77770Bredder Brett A · Brighton, COS/N 320D0058N777BMJet Air Of South Florida Inc · Deerfield Beach, FLBuilt 1978 · S/N 21063156N777DPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1981 · S/N 340A-1257N777DLShamrock Kelly Energy Inc · Blanco, TXBuilt 1979 · S/N P21000373N777EConner Ernest A · Dallas, TXBuilt 1981 · S/N TJ-347N777FYQualitair LLC Trustee · ChelstadtBuilt 1979 · S/N P21000276N777HSJohnson Erik L · Long Beach, CABuilt 1975 · S/N 21060835N777NHS And S Airlink · Troy, MIBuilt 1978 · S/N 340A-0415N777RPParis Air Conditioning Co · Paris, TXBuilt 1974 · S/N 414-0636N777VMiso Enteprises LLC · Wilmington, DES/N 310R0267N777VBArizona Thunderbolts LLC · Scottsdale, AZBuilt 1992 · S/N EA-539N777VFZammit Flight Resources LLC · Sheridan, WYBuilt 1977 · S/N 414-0946N778CWGarbati Thomas Jr · Waterford, CTBuilt 1981 · S/N U20606184N778MMTapley Aviation LLC · Wilmington, DEBuilt 1986 · S/N 4608012N7798NGebhard John M · Hartland, WIBuilt 1977 · S/N U20603718N779DBAirjohn LLC · Cheyenne, WYBuilt 1985 · S/N TJ-489N77BRInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 340A-0053N77BVRegistered aircraftBuilt 1979 · S/N P21000221N77CDN-J Aviation LLC · Forest, VABuilt 1975 · S/N 414-0646N77CKRaiz Coaching LLC · Fort Worth, TXBuilt 1976 · S/N 20700343N77DEHaag Michael E · Granite Bay, CABuilt 1987 · S/N 4608054N77KRMarsh Aviation LLC · Old Lyme, CTBuilt 1981 · S/N P21000703N77LVAviacion Del Oeste Inc · Mayaguez, PRBuilt 1980 · S/N TJ-287N77NWRizor Justin · Phoenix, AZS/N TK-141N77QBDeauxboys LLC · Menomonee Falls, WIBuilt 1976 · S/N 340A0120N77RASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 21063846N77RTBouchier Thomas B · Post, TXBuilt 1978 · S/N TJ-135N780MBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N 402B-0249N781CBMiller Charles Litle Trustee · Fresno, CABuilt 1977 · S/N 21062235N781DBCooper Roy · Lamesa, TXS/N P21000293N783JR13 Aviation LLC · Chelan, WABuilt 1979 · S/N TJ-231N7841QExigo Capital LLC · Miami Beach, FLBuilt 1973 · S/N 340-0222
Back to AD 89-24-01 R1