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.

N4918UMission Aviation Fellowship · Nampa, IDBuilt 1979 · S/N U20605160N491ACEw Pegasus LLC · Walnut Creek, CAS/N 21063673N491WMRenlim Aviation LLC · Brookhaven, GABuilt 1985 · S/N TJ-491N4922YHowey Aviation LLC · Woodhaven, MIBuilt 1980 · S/N 21064047N4925KAlberts Nelson · Weatherford, TXBuilt 1979 · S/N P21000371N4937JSwirsding David J · Chalfont, PABuilt 1977 · S/N 310R0952N4939YDavidson Dan F · Ozona, TXBuilt 1980 · S/N 21064050N4940KGoves Abram M · Parker, COBuilt 1979 · S/N P21000376N4945MMidland College · Midland, TXBuilt 1978 · S/N TJ-145N4946KOrion Technology Group LLC · San Diego, CABuilt 1979 · S/N P21000378N4948AKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1410N4949ASw Air LLC · Denver, COS/N 310R1505N494TSDeep Creek Lake Ventures LLC · Oakland, MDBuilt 1983 · S/N T30300201N495495htsi LLC · Wilmington, DEBuilt 1980 · S/N 414A0487N4950UAerotech Mapping Inc · Las Vegas, NVBuilt 1979 · S/N U20605174N4951YH & B Aeronautics LLC · Miamisburg, OHBuilt 1980 · S/N 21064057N4957ZGuinasso Kimberly Marsh · Reno, NVS/N U20606059N4959CDoll House Properties Inc · Chesapeake, VABuilt 1979 · S/N 21063689N4960JPonderosa Airtankers LLC · Safford, AZBuilt 1981 · S/N T18803791TN4960KShuck Drilling Co · Edgar, NES/N P21000383N4967KBrown Lawson M II DBA · San Diego, CABuilt 1979 · S/N P21000386N4978UKempf Rodney G · Eugene, ORBuilt 1979 · S/N U20605180N4981CWatson Michael · Dalhart, TXS/N 21063699N4981KCuriel Gabriel · Oakley, CAS/N P21000390N4991MOakview Homes LLC · Sullivan, MOBuilt 1978 · S/N TJ-146N4994KMenefee Jerry V · Carson City, NVBuilt 1979 · S/N P21000392N499CAHyannis Air Service Inc · Hyannis, MABuilt 1985 · S/N 402C1006N499DLCjrr Consulting LLC · Denver, COS/N EA-58N49AJLvml Real Estate Investments LLC · Rio Grande City, TXBuilt 1978 · S/N P21000059N49STHedeen Arnold R · Seattle, WAS/N 21064844N4AHHand Kevin D · Anchorage, AKBuilt 1982 · S/N U20606655N4ARN4ar LLC · Marienthal, KSBuilt 1979 · S/N P21000273N4GKDalessandro Janet E · Park Falls, WIBuilt 1975 · S/N 310R0219N4HAArrington Harold M · Detroit, MIBuilt 1984 · S/N T30300283N4LFMacys Flying Service Inc · Tulelake, CABuilt 1977 · S/N U20603705N4MCCoberly Adrian R · Manhattan, KSBuilt 1984 · S/N TJ-461N4VWPronk Glen R · Crittenden, KYBuilt 1974 · S/N 21060277N4YYWilliams Scott Griffin · Salt Lake City, UTBuilt 1979 · S/N 21063553N5000UMci Air LLC · Wilmington, DEBuilt 1979 · S/N 414A0318N5005JDowding Industries Inc · Eaton Rapids, MIBuilt 1974 · S/N 310R0129N500AWMcnulty Kim E · Tehachapi, CAS/N 310R0077N500BMHawkwell Aviation LLC · Stillwater, OKBuilt 1982 · S/N TJ-418N500CHAchiro David P · Truckee, CABuilt 1976 · S/N 310R0734N500CTLac Aero LLC · Liberal, KSBuilt 1981 · S/N 340A1236N500EBKaizen Aircraft Holdings LLC · Kalispell, MTBuilt 1977 · S/N 340A0287N500QVJands LLC · Broken Arrow, OKBuilt 1979 · S/N 340A0699N500WPWelker Franklin W · Agoura, CAS/N EA-582N501DCExecutive Aviation LLC · Peoria, AZBuilt 1981 · S/N 340A1267N501KPWasson Ronald L · Colleyville, TXBuilt 1974 · S/N TJ-21N501SFNomarco Inc · Woodburn, ORS/N 21061808
Back to AD 89-24-01 R1