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.

N907CUDenny Roger A Jr · Eagle River, AKBuilt 2016 · S/N 02-1988N907DTLanni Douglas W · Fairbanks, AKBuilt 2022 · S/N 0001N907EEmbley Tommy Jene · Anchorage, AKS/N 12-3921N907EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12916N907FVGuthrie Richard A · Anchorage, AKBuilt 1955 · S/N 18-4387N907GDAir Charter Inc DBA · Culebra, PRBuilt 1973 · S/N 340N907GJKincaid Levi L · Palmer, AKBuilt 2023 · S/N 221N907GPGittlein Paul A · Wasilla, AKBuilt 2010 · S/N 001N907HHarding Jason I · Wasilla, AKBuilt 2018 · S/N 001N907HGDenali North Side Adventures LLC · Wasilla, AKBuilt 2005 · S/N 10790N907HRMerrill Andrew T · Bethel, AKBuilt 2011 · S/N 100N907JConaway Jeffrey Scott · Anchorage, AKBuilt 1965 · S/N 18-8259N907JAAnderson James C · Wasilla, AKFirst renewal noticeBuilt 2020 · S/N JA001N907JD27th Aero Squadron LLC · Phoenix, AZBuilt 2016 · S/N 70764N907JJJackson Justin R · Valley Center, KSBuilt 2019 · S/N 3319N907JSStevenson William E · Sutton, AKBuilt 2015 · S/N 2406N907JWPalm Beach Flight Training Corp · Lantana, FLBuilt 2006 · S/N 172S10328N907KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1977 · S/N 17268575N907KYYoung Richard H · Eagle River, AKBuilt 2023 · S/N RY001N907LCCrowe Talmadge L Jr · Anchorage, AKS/N 18-1111N907LEAll Her Fault LLC · Fairbanks, AKBuilt 2004 · S/N 3623N907LJAgl Aero LLC · Mckinney, TXBuilt 1969 · S/N 30-1862N907LLAerial Ag Services LLC · Hillsboro, TXBuilt 2006 · S/N 11184N907LPMicro Publishing Press Inc · Truckee, CABuilt 1999 · S/N 172S8221N907MWaitman Bradley J · Wasilla, AKBuilt 2020 · S/N 001N907NWDonelson Patrick M · Wasilla, AKBuilt 2022 · S/N NW907-1N907PKBachus James Ross · Stephenville, TXBuilt 2010 · S/N 91168N907PMMinelga Paul · Soldotna, AKBuilt 2024 · S/N 708N907PSBrock W Walker · Charleston, SCBuilt 1966 · S/N 28-3762N907RDLynch James P · Santa Barbara, CAS/N 82088N907RUBlahut Michael · Anchorage, AKBuilt 1950 · S/N 18-192N907SCCrowe Talmadge Layne Jr · Anchorage, AKS/N 18-4584N907SEAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13479N907STState Of Alaska Department Of Public Safety · Anchorage, AKBuilt 1960 · S/N 18-7262N907THNovember Alpha LLC · Dover, DEBuilt 2005 · S/N 3907N907TTHangar Ak LLC · Sterling, AKBuilt 1974 · S/N 17262358N907TWCarpenter Orin C II · Anchorage, AKBuilt 2023 · S/N 0001N907UTClaus Paul E · Chitina, AKBuilt 1957 · S/N 18-5547N907VCVision Cubs LLC · Deville, LABuilt 2025 · S/N VC-18001N907VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1973 · S/N 343N907WAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1976 · S/N 17267907N907WBWooten Kevin W · Collinsville, ALBuilt 2011 · S/N WB001N907WKNational Aircraft Leasing Corp · Manassas, VAS/N 18282197N907WMSpano Darren M · Deville, LABuilt 1979 · S/N 18-8009038N907XLLunenschloss Michael L · Anchor Point, AKBuilt 1976 · S/N 18-7609010N9080DTrieber Steven M · Eastport, MEBuilt 1958 · S/N 18-6448N9080LStewarts Aircraft Service Inc · Waynesville, OHBuilt 1970 · S/N 255-70N9080YGorley Raymond W · Lees Summit, MOBuilt 1981 · S/N 38-81A0144N9081HRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1975 · S/N 17265930N9081JPerkins Jimmy Keith · Lonoke, ARBuilt 1966 · S/N 28-3118
Back to AD 81-18-04 R2