OpenAirDocs.org
AD 2009-13-06 R1

Registered aircraft · 2,130

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:2009-13-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-13-06-R1')
  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.

N56ADTifc LLC · Winnsboro, SCBuilt 1971 · S/N 27-4642N56MHB S Aviation LLC · Stuart, FLBuilt 1979 · S/N 31-7952068N56MJBishop Ronald Daniel · Port Orange, FLBuilt 1981 · S/N 31-8152108N56PCValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 31-8052005N5702YLil Dawg Aviation Inc · Wilmington, DES/N 27-2823N5713YAnderson Leroy · San Angelo, TXBuilt 1965 · S/N 27-2835N5714YWild Frederick E Jr · Oklahoma City, OKBuilt 1965 · S/N 27-2836N5740YJts Aero LLC · New Hampton, NYS/N 27-2864N5742YAustin Mario A · Charlotte Amalie, VIBuilt 1965 · S/N 27-2867N5746YM C Flyers Inc · Port Orange, FLBuilt 1965 · S/N 27-2871N5752YShackelford John S Jr · Roanoke, TXS/N 27-2877N57539Registration Pending · Meriden, CTRegistration pendingBuilt 1976 · S/N 31P-7630002N575EHajdukovich Robert M · Fairbanks, AKBuilt 1976 · S/N 31-7652006N5773YMccabe Aero LLC · Grand Haven, MIBuilt 1965 · S/N 27-2902N5787YMarr Steven K · Saint Charles, MOBuilt 1965 · S/N 27-2917N5797YAce Tomato Co LLC · Daytona Beach, FLBuilt 1965 · S/N 27-2927N57APHouston William J · Ellensburg, WABuilt 1957 · S/N 23-1110N57GPFoncho Corp · San Juan, PRBuilt 1982 · S/N 31-8252043N57VEN64fd LLC · Wilmington, DES/N 42-5527027N5806YDan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1965 · S/N 27-2939N580SPWatag Corp Trustee · Wilmington, DEBuilt 1965 · S/N 27-3046N5818YWells John R · Gonzales, TXBuilt 1965 · S/N 27-2965N5824YDonahue Sean M · Fort Lauderdale, FLBuilt 1965 · S/N 27-2972N5825YTalmage John R · Kalispell, MTS/N 27-2945N5833YMyob Group LLC · Ocala, FLS/N 27-2982N5847YC&C Aviation LLC · Amarillo, TXBuilt 1965 · S/N 27-2998N5856YGalett Steven J · Canton, CTS/N 27-2942N585BN585b LLC · Snohomish, WAS/N 27-4819N585NYPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954012N5887YAlmost There Air LLC · Daytona Beach, FLBuilt 1965 · S/N 27-3040N5896YPatentcentral LLC · Hollywood, FLBuilt 1965 · S/N 27-3051N58KMOjito Osvaldo A · Miami, FLBuilt 1974 · S/N 27-7405440N58PGTeterboro School Of Aeronautics Inc · Virginia Beach, VABuilt 1967 · S/N 27-3772N58RJLogan Flyers LLC · Logan, OHBuilt 1968 · S/N 27-3971N5911YDileo Steven J · Gallatin, TNBuilt 1965 · S/N 27-3067N5920YAdvanced Mosquito Control & Technology Inc · Boyle, MSBuilt 1965 · S/N 27-3077N5922YUltimate Air Parts LLC · Strasburg, VABuilt 1965 · S/N 27-3080N5930YHopkins Frank Michael · Wilmington, DEBuilt 1965 · S/N 27-3091N5938YFly For Fun Aircraft LLC · Rockville, MDBuilt 1965 · S/N 27-3103N5948YFbm LLC · Laporte, INS/N 27-3114N5955MMonte'S Flying Circus LLC · Wonder Lake, ILS/N 27-3979N5961YWillis Burlin T · Wasilla, AKBuilt 1965 · S/N 27-3130N5963YS And S Aviation Consulting · Hampshire, ILBuilt 1966 · S/N 27-3132N596LKcc Aero LLC · Guaynabo, PRBuilt 1977 · S/N 31-7712036N5972YBm Aviation LLC · Vinton, VABuilt 1966 · S/N 27-3143N59752Visionaire Enterprises LLC · Statesville, NCBuilt 1975 · S/N 31-7612010N59764Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1975 · S/N 31-7652037N59777Sofisa Airways Corp · Coral Gables, FLBuilt 1976 · S/N 31-7612020N5977YRed State LLC · Daytona Beach, FLBuilt 1966 · S/N 27-3148N59809Lou Dell Aviation LLC · Simpsonville, SCBuilt 1976 · S/N 31-7612037
Back to AD 2009-13-06 R1