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.

N444BZWilliams Allen G Jr · Fort Worth, TXBuilt 1974 · S/N 414-0490N444DMGosnell Josh W · Richards, TXBuilt 1974 · S/N 414-0522N444DTBagdasarian Walter DBA · El Cajon, CAS/N 4608008N444FRegistration Pending · Auburn, CARegistration pendingBuilt 1977 · S/N 21061686N444FCCentric It Resources LLC · Loomis, CABuilt 1981 · S/N EA-257N444HTTaktos Ltd · Corvallis, ORBuilt 1973 · S/N 310Q0739N444JMPeck Joseph A · Pound Ridge, NYBuilt 1976 · S/N 340A0280N444KTHangar G-1 Aviation Partners LLC · Los Olivos, CABuilt 1981 · S/N 340A1235N444KWRaw Racing Inc · Puyallup, WAS/N 340A0241N444LSTaa Property LLC · Lake Wales, FLBuilt 1973 · S/N 414-0460N444RWBackus Gary Carl · Chesapeake, VABuilt 1979 · S/N 21063465N444SRr&D Lp · Fayetteville, NCBuilt 1985 · S/N TJ-490N444VPBalzer Joseph W · Sevierville, TNBuilt 1962 · S/N NAV-4-2432N4458SCn Aviation LLC · Mesa, AZBuilt 1976 · S/N TJ-58N445HPChopra Family Lp · Tulare, CABuilt 1985 · S/N EA-445N446MMInternational Air Services Inc Trustee · Carson City, NVS/N 4608006N4474MN4474m Inc · Camarillo, CABuilt 2001 · S/N EA-674N4486WReynolds Eric Eugene · Weatherford, TXBuilt 1969 · S/N D-9070N448BBHawkflight LLC · Sugar Land, TXBuilt 1979 · S/N 21063563N448JDavenport James A · San Antonio, TXBuilt 1966 · S/N D-8127N449LLPlane Fun Inc Tr Trustee · Snellville, GABuilt 1982 · S/N EA-332N44CCoyne Greg · Hondo, TXBuilt 1979 · S/N P21000311N44ECN44ec LLC · Caddo Mills, TXBuilt 1980 · S/N 21063972N44EEEchemann Thomas A · Sidney, OHBuilt 1979 · S/N 21063723N44GAFly Qts LLC · Oconomowoc, WIBuilt 1978 · S/N 414A0036N44HALaps LLC · Elkhorn, WIBuilt 1984 · S/N 46-8408026N44HRCardinal Aviation Services LLC · Castle Rock, COBuilt 1978 · S/N 21062685N44KFEbert Construction Co Inc · Wamego, KSBuilt 1974 · S/N 421B0598N44KRMcilhenny Edward A · Clayton, GABuilt 1983 · S/N EA-358N44NTTucker Nicholas B · La Canada, CABuilt 1981 · S/N 21064531N44SAGniks LLC · Nevada, MOBuilt 1978 · S/N TJ-167N44WHKelly Sean R · Bozeman, MTS/N 21061316N44XJRegistered aircraftBuilt 1984 · S/N TJ-478N4500KEaston Gregory D · Montrose, COBuilt 1978 · S/N P21000201N4509JHill Curtis E · Bancroft, IDBuilt 1981 · S/N T18803741TN450CSCbcb Aircraft LLC · Colfax, WABuilt 1979 · S/N P21000214N4522KGoodman Jack A · Memphis, TNBuilt 1979 · S/N P21000209N4528JRobertson Crop Dusting Service Inc · South Haven, MIBuilt 1980 · S/N T18803744TN4533JStevens Investment Group LLC · Elsie, MIBuilt 1980 · S/N T18803745TN4537QInstant Security Service Inc · Wilmington, DEBuilt 1972 · S/N 402B0343N4547SLorentz Aviation LLC · Canadian, TXBuilt 1976 · S/N TJ-81N454SPSps Investment Properties LLC · Macon, GABuilt 1980 · S/N 414A0626N4557NWestra Aviation LLC · Beaver Dam, WIBuilt 1978 · S/N 340A0547N455JRHinaa Hidaa LLC · Chino Valley, AZS/N EA-124N455SDJ&L Aviation LLC · Malta, NYS/N TJ-405N455TBSmith Loren D · Great Falls, MTS/N 310R1860N4560KRegistered aircraftBuilt 1948 · S/N NAV-4-1560N4566MPalacios Luis A · El Paso, TXBuilt 1978 · S/N TJ-182N4568NBergren Scott W Trustee · Walnut Creek, CABuilt 1978 · S/N 340A0549N456ATBonanza Aircraft Lc · Steamboat Springs, COS/N EA-252
Back to AD 89-24-01 R1