OpenAirDocs.org
AD 81-04-05 R1

Registered aircraft · 1,078

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.

N797VCSantana Carlos A · San Juan, PRBuilt 1966 · S/N 27-3439N79HLIndiana Paging Network Inc · Laporte, INS/N 27-7954046N79MFSkyking Aviation Services LLC · Carson City, NVBuilt 1979 · S/N 27-7954098N7AZDevaney Aviation Inc · Palm City, FLBuilt 1968 · S/N 27-3964N7CBExperimental Aircraft Association · Oshkosh, WIBuilt 1972 · S/N 27-4802N7HWAltieri Frank J · Somerton, AZBuilt 1967 · S/N 27-3718N8006JCrimson Star LLC · Virginia Beach, VABuilt 1981 · S/N 27-8154009N8050YGmm Records · Big Pine Key, FLBuilt 1962 · S/N 27-2098N806RRIsland Flights Inc · Wilmington, DES/N 27-8054052N8075RTahoe Creations Inc · Zephyr Cove, NVS/N 278054004N80FFP A M Aviation LLC · Portsmouth, NHBuilt 1972 · S/N 27-7304958N8124YMatthews Grover C · Hardinsburg, KYBuilt 1966 · S/N 27-3237N81615Heyl Holdings LLC · Orlando, FLBuilt 1953 · S/N 27-2322N817JBBenham James M · College Station, TXS/N 27-4561N818CCFlyit LLC · Camas, WAS/N 27-2977N818MJPika Design Inc · Spring Hill, KSS/N 27-2486N8247GCity Of Stuttgart · Stuttgart, ARBuilt 1973 · S/N 27-7305012N827ECPacific Fleet Aviation LLC · Rochester, NYBuilt 1980 · S/N 27-8154005N82BLSkylens LLC · Hammond, LAS/N 27-7754049N837HBKellum Mark · Belden, MSBuilt 1978 · S/N 27-7954021N83BFHayssen Arthur H · Sebastopol, CABuilt 1976 · S/N 27-7654171N83JWCarpe Diem Aviation LLC · Cleveland Heights, OHBuilt 1979 · S/N 27-7954034N83MHStich Michael A · Malvern, OHBuilt 1969 · S/N 27-4302N83WCRegistered aircraftBuilt 1966 · S/N 27-3281N851PAFlorida Coastal Flying Club LLC · Titusville, FLBuilt 1957 · S/N 23-851N8595BGreene County Vocational School District · Xenia, OHS/N 27-7305127N85RJTechnical Education Services Inc · Virginia Beach, VAS/N 27-7554127N867DCAir Enterprises LLC · Dover, DEBuilt 1961 · S/N 27-62N87AJdkracl Aircraft LLC · Gretna, NEBuilt 1970 · S/N 27-4594N888PEPacific Flight Academy LLC · Honolulu, HIBuilt 1977 · S/N 27-7754066N888RJMongini David · Cottonwood, AZBuilt 1973 · S/N 27-7305139N888TGSkylens LLC · Hammond, LABuilt 1976 · S/N 27-7654032N888WPVantage Point Aviation LLC · Ormond Beach, FLBuilt 1966 · S/N 27-3561N88NPRegistration Pending · Saint Petersburg, FLRegistration pendingBuilt 1976 · S/N 27-7754006N88PZ88pz LLC · Clifton Park, NYS/N 27-7754112N88SHSmith Jeary K · Greenfield, INBuilt 1973 · S/N 27-7304930N88VBBjelland Richard A · Galt, CABuilt 1967 · S/N 27-3609N89BRN89br LLC · Wilmington, DEBuilt 1967 · S/N 27-3618N89SLMclain Scott S · East Troy, WIBuilt 1956 · S/N 23-602N89VVAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1973 · S/N 27-7405254N8APMatthews Aviation LLC · Hardinsburg, KYBuilt 1973 · S/N 27-7305072N8CTOpitz Airways Inc · Belleair, FLBuilt 1973 · S/N 27-7305094N900AMGimli Son LLC · Fort Lauderdale, FLBuilt 1979 · S/N 27-7954014N900TSMidwest Flying Service Inc · Sheldon, IABuilt 1974 · S/N 27-7405429N900WWBucher Burton · North Chicago, ILBuilt 1966 · S/N 27-3372N901APEvanson Scot A · Monroe, TNFirst renewal noticeS/N 27-7405416N901VWAviation Business Corp · Saint Louis, MOS/N 27-2101N90253Wood Roger Weaver · Sale Creek, TNBuilt 1972 · S/N 27-4779N902MTAircraft Trustee Services Inc Trustee · Dover, DES/N 27-8054038N90346Mittelsted John J · Dickinson, TXBuilt 1967 · S/N 27-3604
Back to AD 81-04-05 R1