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.

N273RRJet Set Aircraft Inc · Van Nuys, CABuilt 1965 · S/N 27-3020N27CYSale Reported · Hastings, FLSale reportedBuilt 1976 · S/N 27-7654118N27FMGogoplex LLC · Wilmington, DEBuilt 1976 · S/N 27-7654087N27HPTrinair Aviation LLC · Hampshire, ILBuilt 1962 · S/N 27-2034N286DDKhag Aviation Inc · Woodbridge, NJS/N 27-7854019N28WRN28wr LLC · Simpsonville, SCBuilt 1971 · S/N 27-4626N290MSurging Skyward Inc · Newtown, PAS/N 27-7554111N290VGAlmy David W · Riverside, CAS/N 23-5N291VPSeacrest Enterprises LLC · Asheville, NCS/N 27-8154025N295SBChagres Aero LLC · Albuquerque, NMBuilt 1979 · S/N 27-7954091N299RMGulf Atlantic Airways Inc · Gainesville, FLBuilt 1979 · S/N 27-8054024N29AHRiseaero LLC · Florence, SCS/N 27-398N2FXPlane Crazy Aviation LLC · Hollywood, SCBuilt 1966 · S/N 27-3147N2HRWertheim Michael S · Fort Pierce, FLBuilt 1974 · S/N 27-7405342N2QWPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754126N2RPFasken Frank Andrew · Paris, TXS/N 27-7754160N3019PNelson Matthew J · Frewsburg, NYBuilt 1957 · S/N 23-928N301SWFly Rite Aviation LLC · Fort Myers, FLS/N 27-195N3024PPrentice Robert D · Ripon, WIBuilt 1957 · S/N 23-935N3032PMenard Charles H · Grand Blanc, MIBuilt 1957 · S/N 23-943N3048PMeginnes Mark A · Tucson, AZBuilt 1957 · S/N 23-959N3049PTaildragger Aero LLC · Saint John, WABuilt 1957 · S/N 23-961N3063PWillis William P Trustee · New Palestine, INS/N 23-981N3066PMatanane Rokie C · Barrigada, GUBuilt 1957 · S/N 23-984N3070PParker Anthony C · New Ipswich, NHBuilt 1957 · S/N 23-988N3073PPerry Edward Glen Trustee · Ozark, ARBuilt 1957 · S/N 23-991N3081PVan Zant Robert E · Salem, WIS/N 23-999N3086HGenesis Aviation Enterprises Inc · Fort Lauderdale, FLS/N 27-7754144N30CPSkyveris LLC · Simi Valley, CABuilt 1973 · S/N 27-7305022N3119PKovacs Thomas A · Nashua, NHBuilt 1957 · S/N 23-1041N311BBCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1966 · S/N 27-3313N311JEJps Aviation LLC · West Chicago, ILS/N 27-7754053N3126PJmc Duryea Investments LLC · Ocala, FLBuilt 1957 · S/N 23-1049N3127PThorn Blake A · Coupeville, WAS/N 23-1050N3129PJudie Bear Air LLC · Bend, ORBuilt 1957 · S/N 23-1052N3132PSarratt Curtis H · Annapolis, MDBuilt 1957 · S/N 23-1056N3133PLumley John J · Delray Beach, FLBuilt 1957 · S/N 23-1057N3134PSchmidt Casey D · Cedar Rapids, IAS/N 23-1059N3144PEurohaus LLC · Phoenix, AZBuilt 1957 · S/N 23-1075N315NYPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754031N3161PEga Aero Specialty Services LLC · Beaufort, SCBuilt 1957 · S/N 23-1093N3165PNordstrand Steven D · Oak Harbor, WABuilt 1957 · S/N 23-1097N317PZFairmont State University · Fairmont, WVBuilt 1980 · S/N 27-8054047N3187PAir Over Ground LLC · Helena, MTS/N 23-1124N318RHN72jp Inc · Annandale, VABuilt 1976 · S/N 27-7654184N31DEBarber Deans Elliott III · Selma, ALBuilt 1961 · S/N 27-504N31FACarlisle Robert · Pensacola, FLBuilt 1960 · S/N 27-215N31RCJoey Os LLC · Darlington, PAS/N 27-2818N31TUKalm Air Inc · Junction, TXBuilt 1973 · S/N 27-7305011N31TVCornea Kevin Troy · Palm City, FLBuilt 1979 · S/N 27-7954054
Back to AD 81-04-05 R1