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.

N6535LRodick John M · Hanson, MABuilt 1973 · S/N AA1B-0335N6535PPetter Kristopher · Orient, IABuilt 1959 · S/N 24-1657N6535TDobson Richard W · Phenix City, ALBuilt 1968 · S/N MB-360N65367Wheels Up Re LLC · Odenville, ALBuilt 2004 · S/N 18281435N6536JCooper David M · Sedona, AZS/N 28-4977N6536PWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 15285029N6536VTran Dai A · Rancho Cucamonga, CABuilt 1980 · S/N 172RG0760N6536WDenny David F · Bath, NCS/N 28-20615N6537DCunningham Edward A · Washington, DCBuilt 1979 · S/N 17272853N6537FWheels Up Aviation LLC · Pittsburgh, PABuilt 1979 · S/N 17273236N6537HRivers Robert A · Oxford, NCBuilt 1975 · S/N 17265480N6537JTimer Anna Mae · Wildwood Crest, NJBuilt 1968 · S/N 28-4978N65380Mikol Gabriel · Burlington, WIS/N 172S9710N6538FMbk Leasing And Consulting LLC · Lakeland, FLBuilt 1979 · S/N 17273237N6538JBerra Robert J · Burtonsville, MDS/N 28-4980N6538PStorck Andrew D · Dayton, OHBuilt 1959 · S/N 24-1660N6538RFunnell John R · Cedar Park, TXBuilt 1974 · S/N MB-712N6538VSommer Timothy T · Combined Locks, WIBuilt 1980 · S/N 172RG0762N6538WVenture Flying LLC · Mobile, ALBuilt 2004 · S/N 18281440N65398Seeley Timothy C Trustee · Chico, CABuilt 1978 · S/N 15281526N6539HAbove The Haze LLC · San Lorenzo, CAS/N 17265481N6539RSpencer Alexander Joshua · North Las Vegas, NVS/N MB-713N6539WYounglove Donald L · Mendota, ILBuilt 1965 · S/N 28-20618N653BQQuilty Stephen M · Abingdon, VABuilt 1968 · S/N 28-5055N653CHKelley Aviation Consultants LLC · S Williamsport, PABuilt 1965 · S/N 96-0653N653DFRv 10 LLC · Kalispell, MTS/N 40909N653EREmbry-Riddle Aeronautical University · Prescott, AZBuilt 2019 · S/N 172S12399N653FTFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2024 · S/N 28020171N653JFRegistration Pending · Elizabeth, NJRegistration pendingBuilt 1992 · S/N 653N653KBSkyhawk Aviation Inc · Marietta, GABuilt 2000 · S/N 172S8686N653MCDaily Joshua · Rochester, WAS/N 146N653NDPelican Flight Training LLC · San Carlos, CABuilt 2014 · S/N 172S11469N653PAPurdue Aviation LLC · West Lafayette, INBuilt 2018 · S/N 172S12163N653PSCorcoran Matthew L · Redondo Beach, CABuilt 2016 · S/N 70035N653QPhillips Robert B · Coshocton, OHBuilt 1959 · S/N TD-201N653RVRoberts Todd L · Friday Harbor, WABuilt 2002 · S/N 60503N653SHGivens Tyler · La Vernia, TXBuilt 2003 · S/N 3504N653SMMckinney Steven R · Hamersville, OHBuilt 1984 · S/N TRICE 0001N653SRVertex Aviation Services LLC · Burlington, WABuilt 1968 · S/N 17701048N653TSSturm Mark I · Albuquerque, NMBuilt 2016 · S/N DMO 352N653WChesebro Ben D · Oro Valley, AZBuilt 1998 · S/N 60053N654Roderick Paul E · Talkeetna, AKBuilt 2016 · S/N 006N65401Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1978 · S/N 15281529N65407Clemson Flying Club Inc · Seneca, SCS/N 15281533N65408Hendrix Aviation Inc · Plantation, FLBuilt 1978 · S/N 15281534N6540DCollon John C · Louisville, KYRegistration revokedBuilt 1963 · S/N 1N6540LSmith Thomas E · Williamstown, MABuilt 1973 · S/N AA1B-0340N6540PStauffer Charles R · Pittsburg, MOFirst renewal noticeBuilt 1959 · S/N 24-1662N6540WRiggs Charles A · Pembroke Pines, FLBuilt 1965 · S/N 28-21266N65411Simmons Guy M · Paso Robles, CABuilt 2004 · S/N 172S9714
Back to AD 81-18-04 R2