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.

N709RVOliveira John S · Port Townsend, WABuilt 2012 · S/N 90054N709RWHogan David G · Urbandale, IABuilt 2017 · S/N 22213N709SCRunamuck LLC · New Orleans, LABuilt 2023 · S/N 2881624N709WBBowman Stephen L · Palm Bay, FLBuilt 1972 · S/N 1N70ABVastola Alex G · Conroe, TXBuilt 2020 · S/N 70225N70AHForden Noah P · Saunderstown, RIBuilt 2011 · S/N 71099N70ASInternational Air Services Inc Trustee · Carson City, NVBuilt 2019 · S/N 2314N70BBKidd Howard C · Sawyer, OKBuilt 1963 · S/N 28-10198N70BDRegistration Pending · El Paso, TXRegistration pendingBuilt 1970 · S/N BD-01N70BMAatw LLC · Conway, ARBuilt 1984 · S/N 429N70BTBurg Robert L · Fairbanks, AKBuilt 1974 · S/N 18-7409098N70BZFaibisoff Isaac J · Caseyville, ILBuilt 2005 · S/N 1325N70CDLewis Cherrie · Hampton, CTBuilt 1969 · S/N 28-26542N70CEBandit Soaring LLC · Gig Harbor, WABuilt 1997 · S/N GA0058N70CKAlbatross Air Inc · Beaver, WVBuilt 1972 · S/N 32-7200043N70EF720 Degrees Inc · Santa Monica, CABuilt 1972 · S/N 28R-7335064N70EPMccain William A · Jackson, MSBuilt 1996 · S/N 20809N70FGPears Aviation Corp · Kissimmee, FLS/N 28-7890410N70GBVinter Mooney LLC · Philadelphia, PABuilt 1976 · S/N 20-1196N70GDBig Bend Soaring Inc · Port Orange, FLBuilt 1976 · S/N AA5B-0338N70GKScott Archer LLC · Scott City, KSBuilt 1977 · S/N 28-7790590N70GLShillieto Gordon W · Burlington Flats, NYBuilt 1970 · S/N 37N70GSDavis Jeffrey W · Thomasville, NCBuilt 1992 · S/N 2057N70GTTaylor Gary T · Ontario, ORBuilt 1985 · S/N 8-0157N70GVWeidner Melvin · Elk Grove, CAS/N 24-482N70HALong David A · Yamhill, ORBuilt 1998 · S/N 19250N70HFCavorite Aviation LLC · West Jordan, UTBuilt 1977 · S/N 28-7890248N70HUHexom Nathan · Bozeman, MTBuilt 1996 · S/N 1322N70HYHigher Powered Racing LLC · Port Saint Lucie, FLBuilt 2004 · S/N 2257N70JFFuller Eddy A · Madras, ORBuilt 2012 · S/N 004N70JHBlythe Anne T · Paso Robles, CABuilt 1970 · S/N JH-2N70JXRunway Optional LLC · Fergus Falls, MNBuilt 1973 · S/N 545N70KAEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2001 · S/N 1058N70KDN70kd Research & Development LLC · Keller, TXBuilt 2000 · S/N 60282N70KPPrichard Kevin L · Enterprise, KSBuilt 1969 · S/N 17257954N70LLMonke Farm And Cattle Co · Fontanelle, NEBuilt 2020 · S/N 3341N70LMIrving Mark S · Cordova, AKBuilt 1946 · S/N 12-490N70MAThornton Shawn W · Cheyenne, WYBuilt 2014 · S/N 3223N70MHN70mh LLC · Wilmington, DEBuilt 1976 · S/N 28R-7635390N70MPWhitewater River Runners LLC · Wilmington, DEFirst renewal noticeBuilt 1994 · S/N 21338N70NCB2 Aero Corp · Jamestown, NCBuilt 1978 · S/N 28-7911077N70NGGriffin Bernard · Peckville, PABuilt 2002 · S/N 70N70NTTaylor Margaret L Trustee · Ontario, ORFirst renewal noticeS/N 94-0129N70PFSwaz Aviation LLC · Mesa, AZBuilt 1981 · S/N 28-8116264N70PWStoner Tommy E · Kennesaw, GABuilt 1976 · S/N AA5B-0265N70REHendricks Field Aviation LLC · Sebring, FLBuilt 2012 · S/N 70238N70RPPulis John · Willis, TXBuilt 2023 · S/N 1010AN70RVDonovan Gerald A · Los Lunas, NMBuilt 1991 · S/N 2139N70RWHines Thomas J · Anchorage, AKBuilt 1975 · S/N 150N70SFFred Stuart L · Houston, TXBuilt 2005 · S/N 493-2005
Back to AD 81-18-04 R2