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.

N6768RTaylor Bradley K · Muskego, WIS/N 18280543N6768UBranson Randel L · Eclectic, ALBuilt 1963 · S/N 2490N6768WCimeira Aviation LLC · Birmingham, ALBuilt 1965 · S/N 28-20895N6769JHanson Tobin S · Westlake, ORBuilt 1968 · S/N 28-24493N6769NCausey Kevin L · Bainbridge, GABuilt 1968 · S/N 680081N6769PKroll Richard L · Montague, MIBuilt 1960 · S/N 24-1900N6769UWard Leonard · Preston, IDBuilt 1963 · S/N 2491N676APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843779N676AKDillard Clayton B · Talkeetna, AKBuilt 2022 · S/N CD001N676CBElizabeth City State University · Elizabeth City, NCBuilt 2021 · S/N 172S12619N676CHTake Off Aviation Services LLC · Rockledge, FLBuilt 1976 · S/N 17266905N676CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11537N676DWSunrise Aviation Inc · Ormond Beach, FLBuilt 1999 · S/N 17280774N676ECCastle Joseph E · Marietta, OHBuilt 1997 · S/N 2163N676EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12745N676FLEdwards William J · Big Rapids, MIBuilt 1971 · S/N 28-7125605N676HWinterbottom Eric A · Beavercrk Twp, OHBuilt 1986 · S/N 676N676MMButler Nathaniel J · West Fargo, NDBuilt 2006 · S/N 2843631N676NLoftus Timothy P · Mclean, VABuilt 1968 · S/N 680032N676QKeil Urban G · The Villages, FLBuilt 2002 · S/N 4213N676SECircle K Aircraft Leasing LLC · Houston, TXBuilt 2010 · S/N 2843676N676TFAeon62 Holdings LLC · Plano, TXBuilt 2022 · S/N 2881554N676WLeymaster Michael J · Westerville, OHBuilt 1977 · S/N AA5B0676N676YMarvin James · La Verkin, UTBuilt 2008 · S/N 3016N67701R&R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 15281969N67705Registration Pending · Tacoma, WARegistration pendingBuilt 1978 · S/N 15281971N67708Pischel Tom K · Meadow Vista, CABuilt 1978 · S/N 15281974N6770NGrant William S · Azle, TXBuilt 1968 · S/N 680090N6770VDobalian Vaughn E · Jacksonville Beach, FLBuilt 1970 · S/N 700060N67710Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281975N67711Cox Linda M · Christiana, TNFirst renewal noticeBuilt 1978 · S/N 15281976N6771FDecruz Enterprises LLC · Hattiesburg, MSBuilt 1976 · S/N 28-7715178N6771PBach Keith · Hilton Head Island, SCBuilt 1960 · S/N 24-1902N6771VBrice Michael · Dickinson, NDBuilt 1970 · S/N 700078N67728Edj Aviation Ltd · Fort Myers Beach, FLBuilt 1978 · S/N 15281983N6772JMaljanion Mark D · Upton, MABuilt 1968 · S/N 28-24497N6772NHapp Michael E · Valley Center, KSBuilt 1968 · S/N 680083N6772WKolb Lowell E · Rapid City, SDBuilt 1965 · S/N 28-20899N67733Righter Douglas D · Bellingham, WABuilt 1978 · S/N 15281986N6773JTuskegee Airmen National Historical Museum Inc · Detroit, MIBuilt 1968 · S/N 28-24498N6773NMills David J · Combine, TXBuilt 1968 · S/N 680091N6773VSouthern Mooney Inc · Wilmington, DES/N 700079N67746Air-Planes LLC · Soddy Daisy, TNBuilt 1978 · S/N 15281992N6774BLegacy Aviation And Sales LLC · Ririe, IDBuilt 1956 · S/N 18-5007N6774PWw LLC · Sioux Falls, SDBuilt 1960 · S/N 24-1905N6774UFair Weather Holdings LLC · Centennial, COBuilt 1963 · S/N 2496N6774W10-4 Aviation LLC · Waco, TXBuilt 1965 · S/N 28-20901N67753Southwinds Export Inc · Kissimmee, FLS/N 15281998N6775BOcean Aerial Ads Inc · Berlin, MDBuilt 1956 · S/N 18-5008N6775FPittsburgh Flying Club Inc · Greensburg, PABuilt 1976 · S/N 28-7790163
Back to AD 81-18-04 R2