AD 81-18-04 R2

Registered aircraft · 81,733

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-18-04-R2')
    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-18-04-R2')
  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.

N9310NApproach Partners LLC · Franklinton, NCBuilt 1969 · S/N 28R-35010N9310WGb Aviation LLC · Alpine, CABuilt 1967 · S/N 28-10990N93116Wichita Area Technical College · Wichita, KSBuilt 1981 · S/N 15285405N9311DRegistration Pending · Knoxville, TNRegistration pendingBuilt 1958 · S/N 22-6322N9311JSentelle Amanda L · Frederick, MDBuilt 1966 · S/N 28-3404N9311MShamshir LLC · Lake Havasu City, AZBuilt 1966 · S/N 1244N9311NAmendt Joseph J III · Plymouth, MNBuilt 1969 · S/N 28R-35011N9311VRegistration Pending · Queen Creek, AZRegistration pendingBuilt 1969 · S/N 690090N93124Pavco Inc · Gig Harbor, WABuilt 1981 · S/N 15285409N93127Dunn W Eric · Lake Wylie, SCBuilt 1981 · S/N 15285411N9312DMcdonald Steve W · Lino Lakes, MNBuilt 1958 · S/N 22-6323N9312MSteinman Marc J · Frankfort, ILBuilt 1966 · S/N 1245N9313BAirplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1980 · S/N 172RG0788N9313CWright Terrence Richard · Tiffin, OHBuilt 1978 · S/N 28-7816459N9313DSteneker Siardus L · Vashon, WABuilt 1983 · S/N 172RG1117N9313HFlying Ten Flying Club · Phoenix, AZBuilt 1975 · S/N 17266081N9313JLockhart Michael B · Redlands, CABuilt 1966 · S/N 28-3406N9313KStauffer Donald R Jr · Tracy, CABuilt 1976 · S/N 28-7690241N9313LKlutz Stoner W · Bristol, TNBuilt 1971 · S/N AA1A-0201N9313M9313 Mike Inc · New Smyrna Beach, FLBuilt 1966 · S/N 1246N9313WDjb Aviation LLC · Pompano Beach, FLBuilt 1967 · S/N 28-10993N93142Geoffrion Curt J · Kenai, AKS/N 15285415N9314DCallahan Ashton G · Homer, AKBuilt 1958 · S/N 22-6325N9314EHall Kenneth B · Merritt Island, FLBuilt 1979 · S/N 17272220N9314HAzevedo Bradley J · San Francisco, CABuilt 1981 · S/N 18267931N9314LEastern Stearman Inc Trustee · Leesburg, VABuilt 1971 · S/N AA1A-0014N9314PCapoferri Robert · Hammonton, NJBuilt 1998 · S/N 9314N9314TGriffith Stephen P · Merritt Island, FLBuilt 1978 · S/N 38-78A0024N93154H & H Aviation Enterprises LLC · Fairfield, OHBuilt 1981 · S/N 15285422N9315DZoviv Michael · Hollywood, FLBuilt 1982 · S/N 172RG1118N9315ESmith Mark S · Cornville, AZS/N 17272221N9315JKruthoff Bret · Charles City, IABuilt 1966 · S/N 28-3425N9315LWilliams Matt D · Xenia, OHBuilt 1971 · S/N AA1A-0015N9315NDiir County Flying Inc · Sturgeon Bay, WIS/N 28R-35015N9315RChase Steven J · Aubrey, TXBuilt 1978 · S/N R18200686N9315SBradford Alvin L · Northville, MIBuilt 1974 · S/N M-1596N9315VGroff Joseph J · Colfax, CABuilt 1969 · S/N 690092N93166Kelly William W · Springfield, ORBuilt 1981 · S/N 15285428N9316JStennis Aviation Group LLC · Mandeville, LABuilt 1966 · S/N 28-3409N9316MSale Reported · Kalispell, MTSale reportedBuilt 1966 · S/N 670001N9316VBorghi Robert J · Leonia, NJBuilt 1969 · S/N 690071N9316WPrettyman James M · Sykesville, MDBuilt 1967 · S/N 28-10997N9317RLloyd William E Jr · Clinton, TNBuilt 1979 · S/N R18200687N9317VSpaghetti Aviation LLC · Derby, KSBuilt 1969 · S/N 690093N9318BAnderson Daniel R · Venus, TXS/N 172RG0790N9318CTarakji Mohamad Hani A · Van Nuys, CABuilt 1978 · S/N 28-7890398N9318JJohnson Matt · Eugene, ORBuilt 1966 · S/N 28-3411N9318TGuerra Eduardo · Polk City, FLS/N 38-78A0028N93196Registration Pending · Lafayette, LARegistration pendingBuilt 1981 · S/N 15285439N9319DCloud Buster LLC · Bloomfield, IABuilt 1958 · S/N 22-6332
Back to AD 81-18-04 R2