AD 75-09-13

Registered aircraft · 4,787

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-13')
    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-13')
  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.

N5252ALong Harold M · Carson City, NVBuilt 1979 · S/N 21063327N5255CMcintosh Law Corp · Long Beach, CAFirst renewal noticeBuilt 1978 · S/N 310R1528N5256JKamenz Donald R · Mocksville, NCBuilt 1977 · S/N 340A0403N5258ABeta Aviation L L C · Lewes, DEBuilt 1985 · S/N P21000841N525JRPj Flyer LLC · Avondale, AZBuilt 1980 · S/N CE-907N525KWFuller Thomas R · Scottsdale, AZBuilt 1975 · S/N 21060881N525SFPrimrose LLC · Columbus, NEBuilt 1976 · S/N 421C0080N5260AN5260a LLC · Los Angeles, CAS/N 21063333N5261JAc67333 Inc · Wilmington, DEBuilt 1976 · S/N 414-0852N5263VMccullough James M · Monte Vista, COBuilt 1975 · S/N 21060883N5264CCullum Transportation LLC · North Charleston, SCBuilt 1979 · S/N 21063725N5264JBrowne Bryan C · Allen, TXBuilt 1976 · S/N 414-0854N5265JSouthern Machine And Steel Inc · Fort Myers, FLBuilt 1976 · S/N 414-0855N5267VN5267v LLC · Northbrook, ILBuilt 1975 · S/N 21060886N526CHSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N P21000662N5274YMba Sales LLC · Ridgefield, WABuilt 1980 · S/N 21064147N5275VViatrans LLC · Pryor, OKBuilt 1975 · S/N 21060890N5276AOstermeier Brigitte · MaunNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 21063341N5276VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 21060891N5277PBennett Glenn D · Kingwood, TXBuilt 1977 · S/N 21061784N527JHTugende LLC · Montrose, COBuilt 1979 · S/N 340A0782N527TCLeonardo Paul A III · Merced, CABuilt 1991 · S/N EA-527N5287ATax Busters Inc · El Paso, TXBuilt 1979 · S/N 21063349N5287YMorrow Aviation LLC · Midland, TXS/N 21064152N528WARiley David P · South Barrington, ILBuilt 1979 · S/N P21000315N5293JWestsand Aviation LLC · Allegan, MIBuilt 1982 · S/N 414A0857N5296AHobot LLC · Springdale, ARBuilt 1985 · S/N P21000847N529ADDcm Air LLC · Canton, MIBuilt 1980 · S/N P21000603N52CSBombs Away LLC · Elkins, ARBuilt 1974 · S/N 414-0615N52HCOak Bay Aviation LLC · Bellvue, WABuilt 1980 · S/N TJ-274N52JRAg Tech Farm Services · Gamaliel, KYBuilt 1968 · S/N 421-0197N52JVSl Leasing Group LLC · Atlanta, GABuilt 1973 · S/N 421B0459N52PCDitsch Craig · Hondo, TXBuilt 2001 · S/N LIV-152N52QTFly Qts LLC · Oconomowoc, WIBuilt 1973 · S/N 414-0480N52RBHeights Multi Flight Management LLC · Monroeville, NJBuilt 1979 · S/N 414A0302N52SEPryor Jeff · Santa Barbara, CABuilt 1978 · S/N P21000080N52WXGalaxy Drivers LLC · Dover, DEBuilt 1984 · S/N 468508011N5300ARunzel Brothers Aviation LLC · Bensenville, ILBuilt 1979 · S/N 21063356N5302VSniader David J · Miami, FLFirst renewal noticeBuilt 1975 · S/N 21060902N5313USky Quest 210 LLC · Clarksdale, MSBuilt 1984 · S/N 21064862N5314VBurke Sterling M · Olympia Fields, ILBuilt 1975 · S/N 21060905N5314XMoody Bible Institute Of Chicago · Spokane, WAS/N U20605633N5315XAtarah LLC · Tucson, AZBuilt 1980 · S/N U20605634N5316JCocola Gary M · Fresno, CABuilt 1977 · S/N 340A0405N5317ABlue Skies Air LLC · Allen, TXBuilt 1979 · S/N 21063365N5318ABuchanan Harvey · Townsend, MABuilt 1979 · S/N 21063366N531ECBlue Jets LLC · Rialto, CABuilt 1981 · S/N P21000725N531MHigh Cotton Aero LLC · Murray, KYBuilt 1978 · S/N 340A0534N5320JCorporate Air Charter Inc · Wilmington, DEBuilt 1977 · S/N 340A0407N5323URio Farms LLC · King City, CABuilt 1984 · S/N 21064865
Back to AD 75-09-13