AD 75-09-08

Registered aircraft · 3,035

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

N124JKLewis Fred · Houston, TXBuilt 1966 · S/N 1046N1251XStephens Donald W · Social Circle, GABuilt 1963 · S/N 124N1255XThomas Russell Robert · Alhambra, CABuilt 1963 · S/N 128N1257XGoodman Archie · Mart, TXBuilt 1963 · S/N 130N1258XCompton Nathaniel Brandon · Fredericksburg, VABuilt 1963 · S/N 131N1259XSpencer H Brandon · Tampa, FLBuilt 1963 · S/N 132N1260XCross Paul D · Cowan, TNBuilt 1963 · S/N 133N1262XHawley Christopher M · Chandler, AZBuilt 1963 · S/N 135N1264XAnderson Kyle S · Portland, ORBuilt 1963 · S/N 137N1270XFox Aviation Holdings LLC · Leesburg, INBuilt 1963 · S/N 143N1272XUrban Norman A · Ray, MIBuilt 1963 · S/N 145N1277XDuke City Mooney LLC · Lakewood, COBuilt 1963 · S/N 150N1279XRegistered aircraftBuilt 1963 · S/N 152N1280XErlandson Michael D · Salt Lake City, UTS/N 153N1289XConner James B · Mishawaka, INBuilt 1963 · S/N 162N128ESturges John A · Hayden, IDBuilt 1966 · S/N 1190N128PBHayes Thomas G · Kerrville, TXBuilt 1966 · S/N 1283N1290XJr Aviation LLC · Benton, KSBuilt 1963 · S/N 163N1292XBurns Barry D · Amarillo, TXBuilt 1963 · S/N 165N1294XMcglynn Brian · Friday Harbor, WABuilt 1963 · S/N 167N1295XOz Aviation Inc · Cottonwood Falls, KSBuilt 1963 · S/N 168N1296XFox Judy · Ridgefield, WAS/N 169N1297XScott Benjamin D · Grove City, OHS/N 170N1299XMunoz David · Corona, CAS/N 2680N12YKinslow Eugene C Jr · Prospect, KYBuilt 1965 · S/N 562N1300AMann Lee S · Euless, TXBuilt 1966 · S/N 1064N1303WPowell Steven J · Fairview, TXBuilt 1963 · S/N 191N1304WBrihn Rhonda J · Waterford, WIBuilt 1963 · S/N 192N1306W06 Whiskey Partners · Centennial, COBuilt 1963 · S/N 194N1309WSanford Mark J · Ithaca, NYBuilt 1963 · S/N 197N130LAInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 21-1175N1312WKing Scott W · Tampa, FLBuilt 1963 · S/N 200N1314WNeches Air Inc · Silsbee, TXBuilt 1963 · S/N 202N1316WKurek Daniel L · Garden City, UTBuilt 1963 · S/N 204N1317WMorgenfeld Thomas A · Camarillo, CABuilt 1963 · S/N 205N1320WBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 208N1324WKcantarano LLC · Mukilteo, WABuilt 1964 · S/N 2682N1327WHexom Nathan R · Bozeman, MTBuilt 1963 · S/N 215N1329WKasowski Frank Jr · Becker, MNBuilt 1963 · S/N 217N1330WPepke Mark · Memphis, TNBuilt 1963 · S/N 218N1332WRegistered aircraftBuilt 1963 · S/N 220N1333WJamieson Robert A · Titusville, FLBuilt 1963 · S/N 221N1334WTwo Way Communications LLC · Graham, TXBuilt 1963 · S/N 222N1335WCastanon Salvador L · Rancho Cucamonga, CABuilt 1963 · S/N 223N1336WThree Six Whiskey LLC · Billings, MTS/N 224N1337WTriple Tree Aerodrome Inc · Woodruff, SCBuilt 1963 · S/N 225N1339W39 Whiskey LLC · Clovis, NMBuilt 1963 · S/N 227N133CLDukes Grant M · Horseshoe Bay, TXBuilt 1970 · S/N 700004N1340WJohnson Jon · El Paso, TXBuilt 1963 · S/N 228N1343WInfinity Aviation LLC · Piedmont, SDBuilt 1964 · S/N 2693
Back to AD 75-09-08