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.

N5816QHigh Flying Vision LLC · Clarksdale, MSBuilt 1965 · S/N 3117N5816UHarsimran Singh · Las Vegas, NVBuilt 1970 · S/N 28-26645N5816ZPerdew Paul T · Mcfarland, WIBuilt 1963 · S/N 22-9674N58174Castle Farms Inc · Sunnyside, WAS/N 480685N5817FWicker John E · Lexington, NCBuilt 1976 · S/N 28-7790136N5817HPiper Aviation Museum Foundation · Lock Haven, PABuilt 1949 · S/N 16-434N5817TSnow Robert I · New Caney, TXBuilt 1988 · S/N 24-1654N5817WDow Jeff W · Port Hadlock, WABuilt 1964 · S/N 28-1988N5817ZLamb Matthew P · Edmond, OKBuilt 1963 · S/N 22-9644N5818HSlatter Lowell J · Buhl, IDBuilt 1949 · S/N 16-447N5819DMiceli Michael J · Frewsburg, NYBuilt 1956 · S/N 22-4494N5819HGaniere Constance L · Kemp, TXFirst renewal noticeBuilt 1949 · S/N 16-435N5819LLandauer Jacob · Gainesville, FLBuilt 1972 · S/N AA5-0219N5819UOn Final Aviation LLC · Brookland, ARBuilt 1970 · S/N 28-26649N5819WKee Anthony S · Greenup, KYBuilt 1964 · S/N 28-1997N5819ZCristando Robert J · Wolfeboro, NHBuilt 1963 · S/N 22-9676N581BLGrundy Dennis E · Danville, INBuilt 2016 · S/N 20133N581COn Call Aviation LLC · Brentwood, TNBuilt 2003 · S/N 1271N581CHHill Judith L · Carriere, MSBuilt 2010 · S/N 80581N581DMTichy Thomas H · Albuquerque, NMBuilt 2002 · S/N 894-2002N581ESQuinby Alan D · Woodward, OKBuilt 1978 · S/N 17271811N581FAbj Holdings LLC · Buckeye, AZBuilt 1998 · S/N 1407N581JDAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1995 · S/N 21912N581KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843916N581MTMiddle Tennessee State University · Murfressboro, TNBuilt 2004 · S/N 40.397N581NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496258N581SBHudson Harold Daniel · Williamsburg, VABuilt 1965 · S/N 3115N58206Kiwi Choppers LLC · Hillsboro, ORBuilt 1978 · S/N 190768N58208Smith Helicopter Inc · Cotulla, TXBuilt 1979 · S/N 390780N5820QSmith Douglas C · Lewisville, TXBuilt 1965 · S/N 3119N5820UScarpelli Leonard · Lakewood, ILBuilt 1970 · S/N 28-26650N5820WRed Baron Aviation LLC · Pine Bush, NYBuilt 1964 · S/N 28-2000N5820ZWilson Jonathon D · Breckenridge, MIBuilt 1963 · S/N 22-9677N5821HFifer Lucas J Trustee · Charlestown, INS/N 16-437N5821PCummings Mark R · Laveen, AZS/N 121N5821WEnander Johannes T · Grenora, NDS/N 28-2033N5822DFranz Stanley E · Yakima, WABuilt 1956 · S/N 22-4497N5822MKuenzi Steven M · Alamogordo, NMBuilt 1984 · S/N 01N5822PJstream Lc · Sheridan, WYBuilt 1959 · S/N 24-903N5822QKnudsen Ernst W · Ennis, TXBuilt 1965 · S/N 3120N5822UCurliss James P · Quincy, MABuilt 1970 · S/N 28-26653N5822ZHogan Gerard T · Rockford, ILBuilt 1963 · S/N 22-9679N5823AAtp Aircraft 8 LLC · Wilmington, DEBuilt 2008 · S/N 4496260N5823QRegistered aircraftBuilt 1965 · S/N 777N5823UNewton Donald S · Elk Grove, CABuilt 1970 · S/N 28-26654N5823WHill Travis R · Aledo, TXBuilt 1964 · S/N 28-2070N5824DWitthuhn Johnie B · Callaway, NEBuilt 1956 · S/N 22-4499N5824PClaxton Fred E · La Habra, CABuilt 1959 · S/N 24-905N5824QTss-Glass Machinery Sales Inc · Fort Worth, TXS/N 3121N5824ULindaman Craig C · San Luis Obispo, CABuilt 1970 · S/N 28-26655
Back to AD 81-18-04 R2