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.

N97PBlack River Construction Services LLC · Black River Falls, WIBuilt 2001 · S/N 881-2001N97PFSoaring Eagles Flying Svc Ltd · Edwards, ILBuilt 1980 · S/N 28-8116068N97PLLarson Preston A · Webster, MNBuilt 1997 · S/N 20942N97PRBiggers Jarett J · Alexandria, VABuilt 2013 · S/N 55118501N97PZStoraasli Paul · Torrance, CABuilt 1997 · S/N 581N97RADavis James K · Vero Beach, FLBuilt 1976 · S/N 28-7610020N97RKKeenan Michael P · Ankeny, IABuilt 1998 · S/N 97K003N97RPCombs Jonathan R · Girdwood, AKBuilt 1998 · S/N PR-18-1N97RTDoran John F · Charlestown, RIS/N 974N97RVLindberg Stephen J · Tumwater, WABuilt 1997 · S/N 2431N97RWWiplinger Robert D · Inver Grove Hts, MNS/N 18280387N97SARegistration Pending · Peosta, IARegistration pendingBuilt 1975 · S/N 18-7509117N97TKDekalb Aviation LLC · Williston, NDBuilt 2007 · S/N 1717N97UAManufacturing Services And Solutions LLC · Lake Villa, ILBuilt 1978 · S/N 28R7837163N97UPMf Helicopters LLC · East Troy, WIBuilt 1996 · S/N 0237N97VACamps Bay Aviation LLC · Waukegan, ILBuilt 2005 · S/N 172S9906N97VPAtkins Louis Clifford Jr · Birmingham, ALBuilt 1964 · S/N 30-480N97WButler William E · Idaho Falls, IDBuilt 1987 · S/N 120N97WHCox Thomas R · Kirkland, WAS/N 5263N97WKPantas James S · Mount Pleasant, NCBuilt 1999 · S/N 265978369N97WYCentral Copters Inc · Bozeman, MTS/N 3177N97XCN97xc LLC · Milpitas, CABuilt 2019 · S/N CC19-0045N97XTRobertson Paul L · Knoxville, TNBuilt 2001 · S/N 205N97XZAllen Nathanael W · Bemidji, MNBuilt 2026 · S/N 42063N97YMueller Dan W Jr · Maryland Heights, MOBuilt 1948 · S/N 867N97ZZMx7 LLC · Hudson, OHBuilt 2006 · S/N 22023CN98001Goltsos William · Barrington, RIBuilt 1969 · S/N 28-25991N98009Lebron Renard Luke Jr · Gulfport, MSBuilt 1969 · S/N 28-25994N9800PGrisham Steve DBA · Belzoni, MSBuilt 1976 · S/N 18-7609032N9800UHarvey Mallory · Baxley, GABuilt 1976 · S/N AA5A0200N9800WMrd Aero LLC · Manheim, PABuilt 1967 · S/N 28-23296N98012Registration Pending · West Sacramento, CARegistration pendingBuilt 1969 · S/N 28-25995N98014Bas Part Sales LLC · Greeley, COBuilt 1969 · S/N 28-25998N98015Rd Aire LLC · Opelika, ALBuilt 1969 · S/N 28-25999N98017Blakeslee Vernon A Jr · Torrington, CTBuilt 1969 · S/N 28-26000N9801WNorth Little Rock Air Inc · North Little Rock, ARBuilt 1967 · S/N 28-23297N98021Wright Joseph R · Perry, GABuilt 1969 · S/N 28-26001N9802AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496255N9802UStoll John E · Summerville, SCBuilt 1976 · S/N AA5A0202N98037Hammer Joseph K · Dike, TXBuilt 1969 · S/N 28-26004N9803CWhite Traci M · Manasquan, NJBuilt 1971 · S/N 17259703N9803DAttitude Aerobatics LLC · Wilmington, DEBuilt 1959 · S/N 22-6690N9803PLosse Randall J · Wasola, MOBuilt 1975 · S/N 25-7556118N9803YHubbard Nathan · Butte, MTS/N 38N98041Rosman Patrick R · Creston, WABuilt 1946 · S/N 18188N98043Paul Lester E Jr · Okoboji, IABuilt 1946 · S/N 18190N9804DEngbring Tim · Valmeyer, ILBuilt 1959 · S/N 22-6691N9804WHoyos Luis · Fort Pierce, FLS/N 28-23301N98055Shkvarok Roman · Staten Island, NYS/N 28-26016N98059Airplane LLC · Fort Collins, COBuilt 1969 · S/N 28-26013
Back to AD 81-18-04 R2