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.

N4729CSullivan David C · St George, UTBuilt 1979 · S/N 21063604N4735PMarchman & Assosiates Inc · Krum, TXS/N P21000092N4741KCrosswind Solutions Inc · Medford, ORBuilt 1979 · S/N P21000272N4742UProtocol Enterprises LLC · Holdrege, NEBuilt 1983 · S/N 21064810N4743CFour Three Charlie LLC · Andover, MABuilt 1979 · S/N 21063608N4743XAerotech Mapping Inc · Las Vegas, NVBuilt 1980 · S/N U20605530N4744K4744k LLC · Mesa, AZBuilt 1979 · S/N P21000275N4746U4746u LLC · Sherman Oaks, CABuilt 1979 · S/N U20605079N4747CAlfred Joseph T · Pagosa Springs, COBuilt 1979 · S/N 21063611N4747KFloyd Don B · Snohomish, WAFirst renewal noticeBuilt 1979 · S/N P21000278N4752KAraiza Fernando A · Tucson, AZBuilt 1979 · S/N P21000283N4753UTurchan Robert H · Scottsdale, AZBuilt 1983 · S/N 21064811N4754AIndigo Air LLC · Gulf Breeze, FLBuilt 1980 · S/N 340A1024N47557M & M Aircraft LLC · Cresson, TXBuilt 1977 · S/N 34-7770414N4755KPhilmar LLC · Oshkosh, WIBuilt 1979 · S/N P21000286N4756CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 21063613N4757KGirard Gregory M · Tucson, AZBuilt 1979 · S/N P21000288N47589Radke John A · Cedar Falls, IABuilt 1977 · S/N 28R-7703404N4758KRuvo Scott J · Augusta, NJBuilt 1979 · S/N P21000289N4761AAmarel Robert E Jr · Yuba City, CABuilt 1983 · S/N P21000821N4761KLyman Leslie F · Walnut Grove, CABuilt 1979 · S/N P21000292N4763GGamma Transport Solutions Inc · Carrollton, TXFirst renewal noticeBuilt 1977 · S/N 414-0938N47645Arizona Type Ratings LLC · Sedona, AZBuilt 1980 · S/N 340A0992N4765GAircraft Charter And Leasing LLC · El Cerrito, CABuilt 1977 · S/N 414-0940N4768KJohnson Durwood · Beaumont, TXS/N P21000299N4768PBoone Patrick J · San Antonio, TXBuilt 1978 · S/N P21000101N4769KSpirit 210 LLC · Missoula, MTBuilt 1979 · S/N P21000300N4770KPaulk Charles Jr · Naples, FLBuilt 1979 · S/N P21000301N4771KAshby Kenny · Mead, COBuilt 1979 · S/N P21000302N4772ADodson International Parts Inc · Rantoul, KSS/N 414A0095N4773CDickert Daniel · Cross City, FLBuilt 1979 · S/N 21063621N4773KReason Farms · Yuba City, CABuilt 1979 · S/N P21000304N4773PCoeur De Air LLC · Mcminnville, ORBuilt 1978 · S/N P21000102N4774KWingfield John J · Parker, TXBuilt 1979 · S/N P21000305N4775KBas Part Sales LLC · Greeley, COBuilt 1979 · S/N P21000306N4776UHabberstad John L · Rathdrum, IDBuilt 1979 · S/N U20605096N4777UAdair Aviation LLC · Broken Arrow, OKBuilt 1983 · S/N 21064814N477MAThompson Layne A · Pollok, TXBuilt 1981 · S/N 21064291N477MGJuliet Delta Aviation LLC · Bozeman, MTBuilt 1973 · S/N 421B0477N477RSSundbird Airlines Inc · San Juan, PRBuilt 1981 · S/N 402C0477N4783KLandwehr Wayne A · Gill, COBuilt 1979 · S/N P21000314N4785UNew England Vascular Access LLC · Bristol, NHBuilt 1983 · S/N 21064816N4788PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N P21000108N4791UAerialtraders LLC · Fort Myers, FLBuilt 1979 · S/N U20605104N4795CPrecision Design Inc · Wilmington, DEBuilt 1979 · S/N 21063629N4796K96k LLC · Cave Creek, AZBuilt 1979 · S/N P21000323N4797UPhilbrick Rodney C DBA · Bishop, CABuilt 1979 · S/N U20605108N4798CKjv Aviation Inc · Brentwood, CAS/N 414-0012N4798KAmerican Diversified Services LLC · Marietta, GABuilt 1979 · S/N P21000325N4798PShepherd Mike · Amarillo, TXBuilt 1978 · S/N P21000112
Back to AD 75-09-13