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.

N901JGWestland Aviation LLC · Lake Havasu City, AZBuilt 1979 · S/N R18201120N901JHScorpion Oil & Gas LLC · Stafford, TXS/N 20159N901JRDriftline LLC · Denton, TXBuilt 2023 · S/N JS-01N901KASpiegel Richard J · Sun City, AZBuilt 1973 · S/N 34-7450045N901KGBeaty Chris · Dothan, ALBuilt 1979 · S/N 593-80N901KSMbk Leasing And Consulting LLC · Lakeland, FLBuilt 1985 · S/N 17276273N901MPMccole Kevin · Brookline, NHS/N 17259565N901RGPrecision Aero Marine Inc · Plymouth, MABuilt 1978 · S/N 61P-0495-203N901RMBusey Technology Company LLC · Vienna, VAS/N 18282285N901RVKyzer William P · Lewisburg, TNBuilt 2003 · S/N 90001N901SDRegistered aircraftS/N 67-16901N901SLLange Helicopters Inc · San Angelo, TXBuilt 2001 · S/N 3174N901TWolgamott Thad D · Weatherford, OKBuilt 2000 · S/N 445-2000N901TGWestland Aviation LLC · Lake Havasu City, AZBuilt 1968 · S/N 17257312N901TQAdirondack Aviation LLC · Saranac Lake, NYBuilt 1977 · S/N 28-7725178N901TTEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2002 · S/N 10024N901VWAviation Business Corp · Saint Louis, MOS/N 27-2101N901WHAlpha Helicopters LLC · Lewes, DEBuilt 2008 · S/N 1921N901XZTaylor James A · Memphis, TNBuilt 1977 · S/N 18-7809044N9020DBaker Donald W · China Spring, TXFirst renewal noticeBuilt 1958 · S/N 22-6169N90214Market Garden Corp · Wilmington, DEBuilt 2005 · S/N 60540N9021LRobert Rees · Jonesboro, ARS/N 214-70N9021WHage Electric And Construction Services Inc · The Dalles, ORBuilt 1966 · S/N 28-10819N9022HTurner Kent B · Addison, TXBuilt 2010 · S/N 18282254N9022JLewis Kristofor M · Sparks, NVBuilt 1966 · S/N 28-3050N9022LSedeyn Beth G · Salem, NJBuilt 1970 · S/N 749-70N9023DCarberry David H · Stockton, UTBuilt 2004 · S/N 5897N9023JCook Richard J II · Princeton, ILBuilt 1966 · S/N 28-3051N9023LLammers David T · Bonney Lake, WABuilt 1970 · S/N 246-70N9023MBrandis Robert J · Taylorville, ILS/N 2020N90249Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0039N9024LVine Grove Airport Inc · Vine Grove, KYBuilt 1970 · S/N 758-70N90253Wood Roger Weaver · Sale Creek, TNBuilt 1972 · S/N 27-4779N9025JAa&R Aviation LLC · Pine Grove, PABuilt 1966 · S/N 28-3053N9025LMcmillan Custom Service Inc · Ulmer, SCBuilt 1970 · S/N 759-70N9025WCarlson Joshua G · Frazee, MNBuilt 1965 · S/N 28-10613N9026DCuthbertson Steven M · Van Alstyne, TXBuilt 1958 · S/N 22-6163N9026JRay Adam W · Stinnett, TXBuilt 1966 · S/N 28-3054N90270Dunn Larry W · Anderson, SCBuilt 1966 · S/N 66-18283N90271Gartman Jerald B · Morehead City, NCBuilt 1965 · S/N 65-18261N9027CElizabeth City State University · Elizabeth City, NCBuilt 2010 · S/N 172S11069N9027EShield Raymond C · Russell, PABuilt 1977 · S/N 7074CN9027FErickson Jon D · Atwater, MNBuilt 1976 · S/N 28-7715299N9027HAdriatic Holdings LLC · Cheyenne, WYS/N 17265908N9027WAg Air Squadron One LLC · Saint Joseph, ILBuilt 1965 · S/N 28-10617N9028JGarcia Pinedo Adolfo · Miami, FLBuilt 1966 · S/N 28-3055N90293Grasshopper Aviation Inc · Geneseo, NYBuilt 1981 · S/N 690N9029LMarracino Services LLC · Deland, FLBuilt 1970 · S/N 258-70N9029YJohnson Scott W · Saline, MIBuilt 1970 · S/N 18-8905N902ALBy Tor Aviation LLC · Phoenix, AZBuilt 2014 · S/N 65-7478
Back to AD 81-18-04 R2