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.

N8564YGingers Holdings Inc · Jacksonville, FLBuilt 1968 · S/N 30-1711N8566CGamble Cody M · Palmer, AKBuilt 1958 · S/N 18-6398N8566NN8566n LLC · Briarwood, NYBuilt 1970 · S/N 28-11363N8566VBrown Mill Ranch LLC · Lamar, COBuilt 1974 · S/N 140-75N8566YClarke George W III · Sierra Vista, AZBuilt 1968 · S/N 30-1714N8567DBelleau Thomas D · Anchorage, AKBuilt 1959 · S/N 18-6785N8567GRally Rocket LLC · Fort Collins, COS/N 36N8567NWeekend Aviators Ltd · Herndon, VABuilt 1970 · S/N 28-11365N8567VDavey Bernard V · Eagle Lake, MNBuilt 1974 · S/N 1071-75N8567WNielsen Peter K · Bellingham, WABuilt 1963 · S/N 28-10079N8567YJohnson Randy D · Becket, MAS/N 30-1715N8568CCavanaugh Darrel N · Wasilla, AKBuilt 1953 · S/N 18-2723N8569CRudd Wayne G · Basalt, COBuilt 1954 · S/N 18-2720N8569DRegistration Pending · Willow, AKRegistration pendingBuilt 1958 · S/N 18-6223N8569QSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842404N8569VMachen Paul Stewart · Tallulah, LABuilt 1974 · S/N 795-75N8569WColumbia Gorge Community College · The Dalles, ORBuilt 1963 · S/N 28-10081N856AUAuburn University · Auburn, ALBuilt 2017 · S/N 172S12094N856BCGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1987 · S/N C2171N856CSWendorf Bruce L · North Fort Myers, FLBuilt 2015 · S/N 18282397N856DASpanaflight LLC · Puyallup, WABuilt 1980 · S/N 15284377N856DBRobinson Scott J · Menifee, CABuilt 2007 · S/N 81440N856EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12674N856FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13460N856GDByrd Benjamin E · Moab, UTBuilt 2000 · S/N 001N856KWrong Brothers LLC · Sedgwick, KSBuilt 1997 · S/N 9608100N856KWMurphy Michael J · Mendota Heights, MNS/N 188N856LSlack Troy Trustee · New Concord, OHBuilt 1930 · S/N 117N856NDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1989 · S/N 4495001N856PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843944N856PBToman Gregory R · Caledonia, MIBuilt 2008 · S/N 40186N856RHWijma Alexander Sotiri · Cumming, GABuilt 2009 · S/N 22032N856SBWard James · Chattanooga, TNBuilt 2009 · S/N 71541N856SCWooten Patricia · Avinger, TXBuilt 1978 · S/N 32R-7985059N8570CMoos Jacob W · Dillingham, AKBuilt 1953 · S/N 18-2722N8570FIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7790258N8570RSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842405N8570VJ K Air Inc · Chaffee, NYFirst renewal noticeBuilt 1974 · S/N 308-75N8571NSeverance Douglas E · Danville, CABuilt 1970 · S/N 28-11367N8571VFlywyo LLC · Kalispell, MTBuilt 1974 · S/N 1072-75N8571YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842406N8572DRubbert Jan D · Upham, NDBuilt 1958 · S/N 18-6228N8572LSky Soaring Inc · Hampshire, ILBuilt 1969 · S/N 25-4996N8572VEast Rick · Muscle Shoals, ALBuilt 1974 · S/N 1073-75N8572WKoopmans Caleb · Bridgewater, SDBuilt 1963 · S/N 28-10084N8572ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842407N8573COcean Aerial Ads Inc · Ocean City, MDBuilt 1953 · S/N 18-2726N8573JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842408N8573VSchrack Kevin · Loganton, PABuilt 1974 · S/N 796-75N8573WRenner Paul Eric · Parkville, MOBuilt 1963 · S/N 28-10085
Back to AD 81-18-04 R2