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.

N953LCHustings Ross · Rockwall, TXBuilt 2003 · S/N 5145N953LWWatson Frank D · Canton, PABuilt 1980 · S/N 6007648061231N953MAGutierrez Francisco J · Laredo, TXS/N 3372N953MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2022 · S/N 40.1234N953RNWeinreich Mark W · River Falls, WIBuilt 1988 · S/N RN4N953RRJcb Aviation LLC · Paragould, ARBuilt 2007 · S/N 18282009N953SASunrise Aviation Inc · Ormond Beach, FLBuilt 1980 · S/N 15283908N953SMBogen Alfred T · Brandon, MSBuilt 1980 · S/N 172RG0772N953SSSinor Delbert D · Ozark, MOBuilt 2024 · S/N SD75-11751N953TEL A Mesa Ventures LLC · Denison, TXBuilt 2004 · S/N 10232N953TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881953N953TWEllison Craig M · Sandpoint, IDBuilt 2008 · S/N 001N953WTDragons Fly Aviation LLC · Lantana, TXBuilt 1976 · S/N 289/24-01N95402Registered aircraftBuilt 1969 · S/N 28-25920N95403Deffenbaugh Dennis L · Langley, OKBuilt 1969 · S/N 28-25921N95404Delta State University · Cleveland, MSBuilt 1984 · S/N 15285887N95405Hovey Ryan R · Concord, VTBuilt 1969 · S/N 28-25922N9540BFly8ma LLC · Big Lake, AKBuilt 1981 · S/N 172RG0866N9540DGibsons Gas Inc · Holland, NYBuilt 1958 · S/N 22-6456N9540LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276574N9540MBostrom Zachary J · Ballwin, MOBuilt 1966 · S/N 670117N9540PStuder Al C · Shelby, MIBuilt 1974 · S/N 25-7405628N9540WCarter Brian A · Paragould, ARS/N 28-22970N95418Selleck Stephen P · Colton, CABuilt 1969 · S/N 28-25936N95419Underwood William · Fargo, NDBuilt 1969 · S/N 28-25937N9541KElliott Thomas W · Sarona, WIBuilt 1976 · S/N 28-7625183N9541YNavigated Technologies LLC · Nashville, TNBuilt 1962 · S/N TD-522N95420Registration Pending · Easton, PARegistration pendingS/N 28-25938N95422Chimera Air Inc · Maumee, OHBuilt 1969 · S/N 28-25940N95423Fullerton Alan D · La Crosse, WIBuilt 1969 · S/N 28-25941N95424Air69 LLC · Kaiser, MOBuilt 1969 · S/N 28-25942N95426Morten Jesse L · Larimore, NDBuilt 1969 · S/N 28-25944N95427Mahoney Christopher P · Quakertown, PAS/N 28-25945N95428Raines Matthew A · Whiteside, TNS/N 28-25946N95429Suburban Air Corp · Castro Valley, CABuilt 1984 · S/N 15285892N9542CSandberg Joseph · Lincroft, NJBuilt 1978 · S/N 32R-7885054N9542HAbusham Hamed M · Upland, CABuilt 1975 · S/N 17266215N9542UNorman Ronald Edward · Lopez Island, WAS/N AA1C0039N9542WState Of North Carolina · Raleigh, NCBuilt 1998 · S/N 18280136N95431Kent State University · Stow, OHBuilt 1984 · S/N 15285893N95436Dawson Danny L · Clay, WVBuilt 1969 · S/N 28-25951N95437Howard Bruce A · Santa Fe, NMBuilt 1969 · S/N 28-25952N95438Jordan Kenneth R · Wake Forest, NCBuilt 1969 · S/N 28-25953N9543FEvans Michael · Punta Gorda, FLBuilt 1998 · S/N 18280219N9543GHi Low Aviation LLC · Alpine, TXBuilt 1998 · S/N 18280245N9543HGonzalez-Rio Jesus A · Big Pine Key, FLBuilt 1975 · S/N 17266216N9543JKool Wings Leasing LLC · Indianapolis, INBuilt 1966 · S/N 28-3672N9543L10 Skies LLC · Rockport, TXBuilt 1974 · S/N AA5-0605N9543MReedy Coleman · Cool, CAS/N 670120N9543PHerr Bridget J · Boles, ARBuilt 1999 · S/N 17280644
Back to AD 81-18-04 R2