AD 75-08-03

Registered aircraft · 10,858

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-08-03')
    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-08-03')
  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.

N1122ACox Abraham · Key West, FLBuilt 1968 · S/N 28-25081N1123WThiel Jonathan Ronald · Billings, MTS/N 28-771N1125TSpruce Tiger Aviation LLC · Dallas, TXBuilt 1976 · S/N 28R-7635448N1125XApm Leasing LLC · Casper, WYBuilt 1975 · S/N 28R-7535251N1126XBolobonoff Alexander G · Kingman, AZBuilt 1975 · S/N 28R-7535253N112JMGuzman John · China Spring, TXBuilt 1975 · S/N 28-7525187N112JRValleau Matthew J · Wallingford, CTBuilt 1973 · S/N 28R-7335341N1138FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 28R35260N1138XPierce Nathaniel Antonio · Magnolia, DEBuilt 1975 · S/N 28R-7535256N113EJIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7715075N113KRIal Corp · Lewes, DEBuilt 1974 · S/N 28-7415211N113WYRyals Barry · Rhine, GABuilt 1974 · S/N 28R-7535055N1144XFly Texas Sky LLC · Arlington, TXFirst renewal noticeBuilt 1975 · S/N 28-7505215N1147XPax Flyers LLC · Hollywood, MDBuilt 1975 · S/N 28R-7535259N114CFAw Chartering LLC · Franklin, TNBuilt 1974 · S/N 28-7505080N1150XVenture North Aviation LLC · Cloquet, MNBuilt 1975 · S/N 28-7515394N1157XAscend Aviation LLC · Bountiful, UTBuilt 1975 · S/N 28-7525294N1158HOs Flight LLC · Double Springs, ALS/N 28-7715311N1159XBarrett Tyler J · Cullman, ALS/N 28-7505217N115DCLong Jerry D · Solvang, CABuilt 1973 · S/N 28R-7335405N115JAFarmer Stephen E · Tullahoma, TNBuilt 1967 · S/N 28-22953N1160XWagner Robert J · Dubuque, IABuilt 1975 · S/N 28R-7535261N1161HEngert Armin L · Kahului, HIBuilt 1976 · S/N 28-7715312N1163XPerry Curtis · Klamath Falls, ORS/N 28-7515396N1164XRegistered aircraftBuilt 1975 · S/N 28R-7535263N1167XHoover Adam A · Sugarloaf, PABuilt 1975 · S/N 28-7525295N1168XJz Air LLC · Brooklyn, NYBuilt 1975 · S/N 28-7505219N1178XN1178x LLC · Dover, DEBuilt 1975 · S/N 28-7505220N1179XDesch Edward J III · Aldie, VABuilt 1975 · S/N 28R-7535267N117DWFerrand Kathy M · Cornelia, GABuilt 1973 · S/N 28-7325669N117MTHinkle Robert J · Caldwell, IDS/N 28-21374N117VRAtmospheric Vehicle & Spacecraft Flght Exploration · Rch Palos Vrd, CABuilt 1968 · S/N 28R-30443N1181HAdams Dustan David Sr · Houma, LAS/N 28-7715313N1184DZwick Noah Geary · Dunkirk, MDBuilt 1967 · S/N 28-23130N1184XLairson Samuel E III · Ocean City, NJBuilt 1975 · S/N 28-7505221N1185HJcaviator LLC · Matthews, NCS/N 28-7715314N1185XWilliamson Flying Club Inc · Williamson, NYBuilt 1975 · S/N 28-7505222N1188TAbrams Jeffrey Scott · Phoenix, AZBuilt 1964 · S/N 28-1883N1188XSteven H Baker Construction Co · Big Bear City, CABuilt 1975 · S/N 28R-7535274N1196XMedic Choppers LLC · Springdale, ARS/N 28-7525279N1198XDiscover Aviation Center LLC · Elyria, OHBuilt 1975 · S/N 28-7505223N119A2is Partners LLC · Vero Beach, FLBuilt 1969 · S/N 28-25947N119HPValiair Limited Company Trustee · Casper, WYBuilt 1966 · S/N 28-21570N119JDUSA Wiltshire LLC · Pembroke Pines, FLBuilt 1969 · S/N 28-25406N11FLBell Christopher K · Ashley, OHBuilt 1968 · S/N 28R-30444N11GERusso James F · Liberty, SCBuilt 1972 · S/N 28-7325081N11GKBaden Michael · Waxhaw, NCS/N 28-23403N11GNHaley James M Trustee · Edmond, OKBuilt 1973 · S/N 28-7305330N11HAVintage Aero Inc · Brandon, FLBuilt 1973 · S/N 28-7305338N11JUPottorff Gregory K · Wayne City, ILBuilt 1973 · S/N 28R-7335374
Back to AD 75-08-03