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.

N587BHitterman James D · Metropolis, ILBuilt 1994 · S/N 3185N587KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843928N587KBSwihart Painting LLC · Bolivar, MOBuilt 1978 · S/N 103978N587MALong Island Aviators LLC · Seaford, NYBuilt 2002 · S/N 2843517N587PAVan Hatten Michael Sr · Fairbanks, AKBuilt 1989 · S/N 1809033N587SPPinnacle Aviation Services Inc · Encinitas, CABuilt 2000 · S/N 172S8518N587TPPockrus Pat B · Mineral Wells, TXBuilt 1958 · S/N 22-587N587WPLindner James F · Williamsburg, MIBuilt 2013 · S/N 62-123/124-868N5880ENashville Skyscrapers LLC · Old Hickory, TNBuilt 1978 · S/N 17271950N5880QSeely Scott · Edmond, OKBuilt 1965 · S/N 3148N5880WDurkin Michael T · Sunland, CABuilt 1965 · S/N 28-2570N5881DKanooth Michael L · Washougal, WABuilt 1956 · S/N 18-5305N5881HGazda Jerry V · Granbury, TXBuilt 1949 · S/N 16-501N5881URegistered aircraftBuilt 1970 · S/N 28-26715N5882FGo Fly Mi LLC · Saginaw, MIBuilt 1976 · S/N 28-7790140N5882LBreazeale Peter · Orangeburg, SCBuilt 1972 · S/N AA5-0082N5882PEvans Gene · Henderson, TXBuilt 1959 · S/N 24-967N5882QBean Merton H III · Phoenix, AZBuilt 1965 · S/N 3149N5882UMartinez Guillermo E · Upland, CABuilt 1970 · S/N 28-26716N5883LOst Kenneth Alan · Langhorne, PABuilt 1972 · S/N AA5-0088N5883QSnyder Stephen L · Lebanon, TNBuilt 1965 · S/N 806N5883ZMckernan Thomas H · Gabriels, NYBuilt 1963 · S/N 22-9745N5884DMcmahan Johnny W · Gakona, AKBuilt 1956 · S/N 18-5308N5884QOasis Aero Inc · Willmar, MNS/N 3150N5884UB & R Aircraft LLC · Wadsworth, OHS/N 28-26719N5885DConatser Shawn C · Fairbanks, AKBuilt 1956 · S/N 18-5309N5885PCostanzo Christopher P · Staten Island, NYBuilt 1959 · S/N 24-970N5885ZLewis Vincent E · Oregon, MOBuilt 1963 · S/N 22-9747N5886DAg Solutions Of West Texas LLC · Roby, TXBuilt 1959 · S/N 18-5310N5886FBacktoeden LLC · Casper, WYBuilt 1976 · S/N 28-7790141N5886H86h LLC · Burlington, VTBuilt 1949 · S/N 16-503N5886LCook Charles N · Lakeside, TXBuilt 1975 · S/N 0707N5886PAce Aeromotive Inc · Miami, FLBuilt 1959 · S/N 24-971N5886XPeak Investments LLC · Roanoke, VABuilt 1994 · S/N 1809088N5886ZArgabright Jeremy E · Bloomfield, MTBuilt 1963 · S/N 22-9750N5887DBragdon James O · Monticello, FLBuilt 1956 · S/N 18-5311N5887NBerkshire Commander Air LLC · Pittsfield, MABuilt 1978 · S/N 14502N5887UFretz Richard G · Harrisburg, PABuilt 1970 · S/N 28-26722N5888HGfeller Kent · Winona, KSBuilt 1949 · S/N 16-510N5888PRegistered aircraftS/N 24-973N5888QCross The Line Sales Inc · Lexington, NCBuilt 1965 · S/N 3152N5888ULynch Francis X · Dumont, NJBuilt 1970 · S/N 28-26755N5888ZGoldberg David C · Garner, NCBuilt 1963 · S/N 22-9752N5889L100 Rads Corporation · Omaha, NES/N AA5-0089N5889RPatkotak Crawford A · Barrow, AKS/N 17253558N5889VRegistration Pending · Cherry Hill, NJRegistration pendingBuilt 1977 · S/N 28-7790507N5889WHarrison Joshua · Canyon Country, CABuilt 1965 · S/N 28-2627N588AVAir Ventures Hawaii LLC · Lihue, HIBuilt 2005 · S/N GA8-05-076N588BCSamela Nicholas V · Thomaston, CTS/N 564-2014N588CPTjomsland Bryan · Culver City, CABuilt 1958 · S/N 24-431
Back to AD 81-18-04 R2