OpenAirDocs.org
AD 82-23-01 R1

Registered aircraft · 3,118

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:82-23-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:82-23-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.

N44WDDemray William S · Northville, MIBuilt 1969 · S/N 30-1860N4563VMercer Alexander David · San Diego, CABuilt 1958 · S/N 24-129N456PBooth Donald V · Denison, TXS/N 24-3276N45888D-Five Holdings Group LLC · Vidor, TXBuilt 1963 · S/N 24-3453N45JLBows Investments LLC · Bend, ORS/N 39-148N45MBWright Kelly A · Spokane, WABuilt 1959 · S/N 24-1445N46EAEssential Aviation LLC · Meridianville, ALBuilt 1970 · S/N 39-79N46MJones Gregory D · Pueblo, COBuilt 1958 · S/N 24-411N46PHarrison Donna J · Eau Claire, MIBuilt 1966 · S/N 24-4470N4743MMcbride Paul · Dallas, TXBuilt 1969 · S/N 301848N475TVPaine Twin Comanche LLC · Redmond, WABuilt 1966 · S/N 30-1366N478WTBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 24-4634N47BBRogers Joseph O III · Fernandina Beach, FLBuilt 1960 · S/N 24-1889N48086Spohrer Wilner And Maxwell P A · Jacksonville, FLS/N 30-1421N487SCRegistered aircraftBuilt 1959 · S/N 24-1346N48ARGacey Inc Trustee · Wilmington, DEBuilt 1966 · S/N 30-1328N4949YPearce Richard Henry · Moses Lake, WAS/N 30-648N494NJT And B Flying Adventures LLC · Middletown, DES/N 30-494N4960250 Inc · Washington, DCS/N 24-4025N4995BStobbe Marlin L · Granada Hills, CAS/N 24-4501N49WSJohnson Matthew N · Redgranite, WIBuilt 1966 · S/N 30-1393N4CBDream Catcher Company LLC · Center, COBuilt 1964 · S/N 24-3607N4CKLorenzo Walker Institute Of Technology · Naples, FLBuilt 1967 · S/N 30-1645N4PLJuliet Kilo Aviation LLC · Palos Heights, ILBuilt 1961 · S/N 24-2400N4XNMiller Donald W · Harrisonburg, VABuilt 1971 · S/N 244990N4YASoaring Eagle Southwest LLC · Fort Mohave, AZS/N 30-365N5002POrtman Bernard · Deer Park, TXBuilt 1957 · S/N 24-5N5003PLouwagie Bradley J · Marshall, MNBuilt 1957 · S/N 24-6N5005PRackley William R Jr · Grand Island, FLBuilt 1957 · S/N 24-8N5006PWright William · Cleveland, OKBuilt 1957 · S/N 24-9N5008PThree Chicks Aviation LLC · Benton, LAS/N 24-11N500AVInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 24-4805N500PFord Charles D · Clifton, TNS/N 24-341N5014PSky Valley Aviation LLC · Waverly, IAS/N 24-17N5017PPineapple Air LLC · Wilmington, DEBuilt 1957 · S/N 24-20N501REIndependence Aerospace LLC · Kennesaw, GABuilt 1963 · S/N 30-194N5020PThurston Steven C · Salisbury, NCBuilt 1958 · S/N 24-23N5029PJordan Walter B · Chehalis, WABuilt 1958 · S/N 2432N502DWSolamich Aviation LLC · Huntley, ILBuilt 1971 · S/N 39-124N5034PNeufeld William J · Bostwick, FLBuilt 1958 · S/N 24-37N503JALiem David H · Brea, CABuilt 1965 · S/N 24-4165N5045PMccarty Paul S · Wichita, KSBuilt 1958 · S/N 24-49N5048PBrown Mark E · Charlotte, NCBuilt 1958 · S/N 24-52N5050PBoucher Bobbi · Fredericksburg, VAS/N 24-54N5051PGrorud James R · Milbank, SDBuilt 1958 · S/N 24-55N5058PBakeman Michael G · Sturgis, MIBuilt 1958 · S/N 24-507N505BJLa Beau Lawrence O · San Angelo, TXBuilt 1961 · S/N 24-2331N505GAlford Robert S · Columbus, GARegistration revokedBuilt 1964 · S/N 30-251N5065PVeal Ted W · Homer, AKS/N 24-71N5066PDelaware Aviation LLC · Sidney, NYBuilt 1958 · S/N 24-72
Back to AD 82-23-01 R1