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.

N1067XArchey Richard L · Georgetown, KYBuilt 1975 · S/N 28-7505204N1067YMerino Anthony S · Springville, CABuilt 1974 · S/N 287415020N1068HJudd Gary F · Bend, ORBuilt 1976 · S/N 28-7715305N106MSKundel Richard · Cedar Rapids, IABuilt 1974 · S/N 28-7525063N1071XPeter Prince Aviation Center LLC · Milton, FLBuilt 1975 · S/N 28-7525274N1072QCoastal Air Inc · Groton, CTBuilt 1977 · S/N 28-7725180N1072XDemaagd Ross E · Middleville, MIBuilt 1975 · S/N 28-7505206N1073XAustin Arrows Inc · Austin, TXBuilt 1975 · S/N 28R-7535232N1076XMarston Lester J · Ukiah, CABuilt 1975 · S/N 28-7515383N1077XJny LLC · Riverview, FLBuilt 1975 · S/N 28R-7535234N1079HJaremus Kent M · Olathe, KSS/N 28-7725131N1079YBoyer Jerry D · Monument, ORBuilt 1962 · S/N 28-118N10805Hill Ag-Air LLC · Pocatello, IDS/N 28-22677N1080HAll2fly LLC · Atlanta, GAS/N 28-7715306N1080XFlying With Fitch LLC · Porter, TXS/N 28-7525278N1082XWhitmer Ronald N · Ellsworth, KSBuilt 1975 · S/N 28-7505207N1089XCoastal Aviation Partners LLC · Hubert, NCS/N 28R-7535236N108AVDavis Robert S · Keystone Heights, FLBuilt 1974 · S/N 28-7415573N1092TH4s Aviation LLC · Longview, TXS/N 28-25565N1092XNice Curtis A · Fort Myers, FLBuilt 1975 · S/N 28R-7535230N1093XRoseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 28-7515386N1094TGlover Anthony R · Louisville, KYBuilt 1969 · S/N 28R-31116N1095XVillegas Miguel Angel Cuello · Weston, FLBuilt 1975 · S/N 28R-7535239N1096TEvans Charles B · Benbrook, TXS/N 28-26284N1097THorizon Aviation LLC · Brooks, GABuilt 1969 · S/N 28-26287N109RBClark William R · Anchorage, AKBuilt 1965 · S/N 282612N10ASCrewson Gary · East Aurora, NYBuilt 1972 · S/N 28R-7235196N10GHPeters Darvin Leroy · Meservey, IAS/N 28-20482N1102XMarak Enterprises LLC · Galena, MOBuilt 1975 · S/N 28-7505210N1103XHolmgren Joel A · Chisago City, MNBuilt 1975 · S/N 28-7515388N1104HSkydance Aviation LLC · Chesapeake, VAS/N 28-7725132N1107HShurtz William W Jr · Medford, ORBuilt 1977 · S/N 28-7715308N1108HAdk Flying Club Inc · Ballston Spa, NYBuilt 1976 · S/N 28-7715309N1108XThompson Trisha L · Clearwater, KSBuilt 1975 · S/N 28-7515389N1109XBruno Michael J · Pittsburg, CABuilt 1975 · S/N 28-7505211N110JA3mw Farms Inc · Hallock, MNBuilt 1974 · S/N 28-7515135N110MSMcaleer Scott · Scranton, IABuilt 1969 · S/N 28R-35194N110TNMaloney Casey · Placerville, CABuilt 1972 · S/N 28-7305054N1112XArrow Flyers LLC · Englewood, COS/N 28R-7535247N1117XHarshman James M · Washington, PABuilt 1975 · S/N 28R-7535248N1118XKdr Avgroup LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535249N1118ZMoorhouse Mark A · Santa Fe, TNBuilt 1963 · S/N 28-1118N111AEMatthews Timothy I · Belvidere, NJBuilt 1970 · S/N 28R-35809N111CPVelasco Ricardo Rene Jr · Cumming, GABuilt 1969 · S/N 28R-35326N111DJLee Brian A · Riverdale, GABuilt 1972 · S/N 28R-7235038N111FBMccarthy Elaine M · Indianapolis, INBuilt 1973 · S/N 28R-7335310N111FPPhoenix Carolina LLC · Saint Petersburg, FLBuilt 1970 · S/N 28R-35818N111FRAirward Inc · Novato, CABuilt 1972 · S/N 28-7325055N111NPBlackfoot Aviation LLC · Bozeman, MTS/N 28-3046N1121XCrosscheck Ftc LLC · Greeneville, TNBuilt 1975 · S/N 28-7515316
Back to AD 75-08-03