OpenAirDocs.org
AD 75-23-08 R5

Registered aircraft · 999

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:75-23-08-R5')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-23-08-R5')
  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.

N220XPOleary Patrick G · Lake Tapps, WAS/N T310Q01020N2211QHill Jeffrey A · Bridgeport, WVBuilt 1968 · S/N 421A0011N2214Q421 Partners · Delphi, INBuilt 1968 · S/N 421A0014N2221QAviation Sales And Charter LLC · Dover, DEBuilt 1968 · S/N 421A0021N222MDElx Aviation LLC · Hartford, MIBuilt 1974 · S/N 310Q1013N222STEau Claire Aviation LLC · Eau Claire, WIBuilt 1976 · S/N 310R0679N2235QSparx Logistics USA Ltd · Charlotte, NCBuilt 1968 · S/N 421A0035N2236QWoods Leland W · Klamath Falls, ORBuilt 1968 · S/N 421A0036N228JHBuzzed Landing LLC · Ocean Springs, MSBuilt 1980 · S/N 421C-1006N22AMJays Aircraft Maintenance Inc · Costa Mesa, CABuilt 1979 · S/N 310R1634N22GBHolland Kenneth F Trustee · Santa Clarita, CABuilt 1977 · S/N 310R1237N230MWGot Wings LLC · Woodbury, NYS/N 421C0671N232ASGuggenair LLC · Carbondale, COBuilt 1978 · S/N 310R1369N2345AAeolus Gold LLC · Wilmington, DEBuilt 1974 · S/N 421B0636N2349SAjs Aviation LLC · Warroad, MNS/N 421C1209N234DADestination Management LLC · Tulsa, OKBuilt 1971 · S/N 421B0122N234TCAg N234tc LLC · South Salt Lake, UTBuilt 1974 · S/N 310R0050N237SMWestern Rivers Aircraft LLC · Paducah, KYBuilt 1976 · S/N 421C0237N238FALetourmeau University · Longview, TXBuilt 1972 · S/N 421B0238N239SERiley Charles Sweeney · Highlands Ranch, COBuilt 1972 · S/N 421B0315N23DTAlastrom Aviation LLC · Wilmington, DEBuilt 1975 · S/N 421B0852N23RLCaljet Inc · Van Nuys, CABuilt 1981 · S/N 421C1094N240RTAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1975 · S/N 421B0863N240SQMigster LLC · Miami, FLBuilt 1975 · S/N 310R0273N241EWFort Carlos LLC · Fort Worth, TXBuilt 1978 · S/N 421C-0496N241MWAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 421C0030N241TSGrey Matter Inc · Valley Springs, CAS/N 421B0110N242HB2hb Airways LLC · Saint Louis, MOBuilt 1970 · S/N 421B0049N245THigh Country Aero Ltd · Berthoud, COS/N 421C1104N24GBSmith Loren · Great Falls, MTS/N 421C0287N251JLGolden Eagle 421 LLC · Alsip, ILBuilt 1977 · S/N 421C0311N260RAUpward Aviation LLC · Tulsa, OKBuilt 1980 · S/N 421C1004N262MCAerospace Trust Management LLC Trustee · Wilmington, DES/N 421C0140N2635XN2635x LLC · Eau Claire, WIS/N 310R1642N2638XSoftware 2000 Inc · Arroyo Grande, CABuilt 1979 · S/N 310R1666N2641PChandler David G · Phoenix, AZBuilt 1979 · S/N 310R1679N2642ACronin LLC · Jacksonville, FLBuilt 1979 · S/N 310R1682N2642YStallings Ted W · Seldovia, AKS/N 310R1684N2644VCrosby David · Potomac, MDBuilt 1979 · S/N 310R1812N264DCAirdvm LLC · Rcho Sta Marg, CABuilt 1982 · S/N 421C1248N26533Txoperation LLC · Fort Scott, KSBuilt 1979 · S/N 421C0686N26560Rockslide Analytics Inc · Livermore, CAS/N 421C0802N2657GB & K Leasing Inc · Nantucket, MAS/N 421C0809N2657NLoreto Aviation LLC · Wahoo, NES/N 421C0811N26588Golden Aero LLC · Tarpon Springs, FLBuilt 1980 · S/N 421C0835N2658ZVirtue Genetics LLC · Cedar Rapids, IAS/N 421C0827N265RGHerron Aviation Group LLC · Dexter, MIS/N 421C0833N2660UUnited Front Holdings LLC · Laguna Hills, CABuilt 1981 · S/N 421C1210N2664Lcj Holdings LLC · Youngsville, LAS/N 310R0195N2668ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 421C1216
Back to AD 75-23-08 R5