OpenAirDocs.org
AD 81-04-05 R1

Registered aircraft · 1,079

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:81-04-05-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:81-04-05-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.

N5649YPotenza Austin · Phoenix, AZBuilt 1964 · S/N 27-2764N5671YShore Gerry · Inez, TXBuilt 1965 · S/N 27-2785N5683YCaribbean Flyer LLC · Kinshill, VIBuilt 1965 · S/N 27-2799N5687YBrouse Dan T · Magnolia, TXBuilt 1965 · S/N 27-2805N5688YYates Mary A · Haysi, VABuilt 1965 · S/N 27-2806N5693YAlligator Air Transport LLC · Fort Lauderdale, FLS/N 27-2813N56ADTifc LLC · Winnsboro, SCBuilt 1971 · S/N 27-4642N5702YLil 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-2877N5773YMccabe 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-1110N5806YDan 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-3132N5972YBm Aviation LLC · Vinton, VABuilt 1966 · S/N 27-3143N5977YRed State LLC · Daytona Beach, FLBuilt 1966 · S/N 27-3148N5982YDawkins Karlene A · Coral Springs, FLBuilt 1966 · S/N 27-3155N5986YBlackhawk Holding Corp · Wilmington, DEBuilt 1966 · S/N 27-3159N59EEKern Raymond L · Bedford, INS/N 27-3390N5HMEvans Hayward D · Saint Augustine, FLBuilt 1973 · S/N 27-7305041N600RJRankin Richard · Germantown, TNBuilt 1979 · S/N 27-7954114N6011YTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1966 · S/N 27-3193
Back to AD 81-04-05 R1