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.

N6017YTulsa Technology Center School District No 18 · Tulsa, OKS/N 27-3200N6030YReddick Brent · Paragould, ARBuilt 1969 · S/N 27-4370N6034YTan American Corporation · New York, NYRegistration revokedBuilt 1966 · S/N 27-3219N6039YAllen Aviation Inc · Aynor, SCBuilt 1966 · S/N 27-3224N6044YPinnock Charles W · Port St Lucie, FLBuilt 1966 · S/N 27-3230N6046YWells Douglas A · Chino, CAS/N 27-3233N6052YCentral Kentucky Aviation Inc · Bardstown, KYBuilt 1966 · S/N 27-3243N6058YEltgroth Peter G · Livermore, CABuilt 1966 · S/N 27-3251N6062YJahba LLC · Coral Springs, FLBuilt 1966 · S/N 27-3257N6069YAngelman Aviation LLC · Prosper, TXBuilt 1966 · S/N 27-3267N606CACv Wings LLC · Canby, MNBuilt 1972 · S/N 27-4853N6085YPharmair LLC · Jackson, MSBuilt 1966 · S/N 27-3287N6089YAerosavant LLC · Towanda, PABuilt 1966 · S/N 27-3295N6092YClean Waste Solutions LLC · Indianapolis, INBuilt 1966 · S/N 27-3298N60LFNorthwoods Air LLC · Orono, MEBuilt 1978 · S/N 27-7854111N60MBCurry Arnold J · Houston, TXBuilt 1966 · S/N 27-3544N611SGRph Engineering LLC · Lehi, UTBuilt 1979 · S/N 27-8054020N611WWCone S E Jr · Hobbs, NMBuilt 1978 · S/N 277854093N6121YWeaver Scott Allen · North Logan, UTBuilt 1966 · S/N 27-3332N6125YDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-3336N612EHIsland Flyers Inc · Addison, TXBuilt 1976 · S/N 277654161N612MRFladr LLC · Westfield, NJBuilt 1979 · S/N 27-8054008N612WWEhecatl LLC · Fort Wayne, INBuilt 1977 · S/N 27-7754114N613RAKampa Arnold J · Vero Beach, FLBuilt 1966 · S/N 27-3347N613WKKnaust Jerry L · Blue Jay, CABuilt 1966 · S/N 27-3344N6140YSouthern Seaplane Inc · Belle Chasse, LAS/N 27-3353N6149YRobbins Warren N · Chandler, AZBuilt 1966 · S/N 27-3366N6164YStriplin James R Jr · Hartford, ALBuilt 1966 · S/N 27-3383N6169YWiesen Enterprises Ltd · Empire, MIBuilt 1966 · S/N 27-3317N6170YGe Org Advanced Systems LLC · Newton, NJBuilt 1966 · S/N 27-3391N6180YChilton Leonard Jay · Caddo Mills, TXS/N 27-3406N6189YSmith Brian Charles Jr · Lake Mary, FLBuilt 1966 · S/N 27-3415N6193YMatthews Aviation LLC · Hardinsburg, KYBuilt 1966 · S/N 27-3419N6198HLane Aviation Inc · Rosenberg, TXS/N 25-5419N619BLPacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554003N61MGDominion Air Charter Inc · Louisa, VABuilt 1974 · S/N 277405285N61NCNorthwest Florida Flight Services LLC · Jacksonville, FLS/N 27-4184N6205YMarschke Corey A · Stevens Point, WIBuilt 1966 · S/N 27-3432N6219YTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1966 · S/N 27-3446N622KCarr Randal J · Chandler, OKBuilt 1975 · S/N 27-7554088N622TBPacific Fleet Aviation LLC · Rochester, NYBuilt 1978 · S/N 27-7854091N6230YRegistration Pending · Chapmansboro, TNRegistration pendingBuilt 1966 · S/N 27-3459N6235YBeaver Douglas G · Harleysville, PAS/N 27-3467N6238YBarding Steven P · Hogansville, GAS/N 27-3470N62494Pacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7654019N62495Gentrys Flying Service LLC · Prattville, ALBuilt 1976 · S/N 277654020N62498Hogan Michael J · Bonita Springs, FLBuilt 1975 · S/N 27-7654023N6249YPapagni Demetrio G · Madera, CAS/N 27-3487N62508Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7654029N6253YMidwest Air LLC · Hartford, SDS/N 27-3491
Back to AD 81-04-05 R1