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.

N925WMVaughn Aviation LLC · Lowell, ARBuilt 1979 · S/N U20604997N926MTNew London Aviation LLC · Forest, VABuilt 1978 · S/N 421C0625N92711Intergard R&D LLC · Miami, FLBuilt 1973 · S/N 21060024N9275YInternational Air Services Inc Trustee · Carson City, NVS/N 46-8608026N9281YSharp Darren J · Musselshell, MTBuilt 1986 · S/N 46-8608027N928CRCasas De Colores Inc · Santa Fe, NMBuilt 1977 · S/N 340A0434N928KMSchmoker William C · Eden Prairie, MNBuilt 2001 · S/N EA-672N928RSEzskies Air Service LLC · Hayden, IDBuilt 1978 · S/N TJ-138N92903Nalle W B · Austin, TXBuilt 1981 · S/N 310R2140N9295YSln Aviation LLC · Salina, KSBuilt 1986 · S/N 46-8608032N929DCPremier Flight LLC · El Cajon, CABuilt 1979 · S/N 340A0934N929HBSaratoga Transporation LLC · Encino, CAS/N 414-0509N92BMNugent James S · Diamondville, WYS/N P21000557N92CKKingsborough James D · Carlisle, PABuilt 1978 · S/N P21000160N92DLDavis Air LLC · Phoenix, AZBuilt 1976 · S/N 340A0204N92DSBooty Bill · Idaho Falls, IDBuilt 1975 · S/N 21060847N92WH322ee Aviation LLC · Union, KYBuilt 1977 · S/N 340A0271N9307YRader Drew · Avon, COBuilt 1981 · S/N 21064467N9309YYecny Alan K · San Luis Obispo, CABuilt 1981 · S/N 21064469N930DBKropp Christian Trustee · Azle, TXBuilt 1980 · S/N EA-184N93128High Plains Aero Consulting Inc · Pampa, TXBuilt 1974 · S/N 21060273N93129Klca Inc · Warsaw, INS/N 21060274N93186Bates Byron B · Ethel, WABuilt 1974 · S/N 21060299N93262Land Office LLC · Burlington, COBuilt 1974 · S/N 21060324N93274Wltf LLC · Caldwell, IDBuilt 1974 · S/N 21060335N93285Corrie Brent · Vero Beach, FLBuilt 1974 · S/N 21060341N93295Gates Steven · Midlothian, TXBuilt 1974 · S/N 21060347N9330TCrusader 303 LLC · Eugene, ORBuilt 1981 · S/N T30300002N93344Cardinal Headings Ltd · Wilmington, DES/N 21060371N93350Rowe M D Trustee · Bozeman, MTBuilt 1974 · S/N 21060372N93354Utah County Sheriff · Spanish Fork, UTBuilt 1974 · S/N 21060374N93362Bouvier Ellis C · Prineville, ORBuilt 1974 · S/N 21060377N93380Stahla Robert E Trustee · Grand Island, NEBuilt 1974 · S/N 21060384N9338ZBarr Air Patrol LLC · Mesquite, TXBuilt 1981 · S/N U20606404N934CRReygar Investments LLC · Brownsville, TXBuilt 1982 · S/N 414A0856N9353YKovax Aviation LLC · Youngstown, OHBuilt 1981 · S/N 21064482N9356YParsons Bruce W Trustee · Costa Mesa, CABuilt 1981 · S/N 21064483N9369YBk Aviation Services LLC · Yorba Linda, CABuilt 1981 · S/N 21064488N936JBHunt Air LLC · Anderson, SCBuilt 1977 · S/N 340A0263N9379YFitzgerald Aviation LLC · Bluffton, SCBuilt 1981 · S/N 21064491N937WHLakemere Farms LLC · Spirit Lake, IAS/N 46-8508036N93836Clarkson Michael D · Anniston, ALBuilt 1974 · S/N 21060426N93867Sunup Flyers Coop · Moscow, IDBuilt 1974 · S/N 21060440N93APGill Paul E · Port Saint Lucie, FLBuilt 1980 · S/N EA-96N93ETGhatan Farhad · Friday Harbor, WAS/N U20604178N93HPAxe Capitol Inc · Lake City, FLBuilt 1984 · S/N 21064843N93LCCl Max Inc · Wilmington, DEBuilt 1981 · S/N P21000741N94035Husbands David · Bosque, NMBuilt 1974 · S/N 21060487N9403YFlorida Emergency Management Associations Inc · West Palm Beach, FLBuilt 1981 · S/N 21064498N94148Gates Don · Richmond Hill, GABuilt 1974 · S/N 21060519
Back to AD 89-24-01 R1