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.

N908JDNash Gregg Lynn · New Waverly, TXBuilt 2009 · S/N 81284N908MCL2 Leasing LLC · Orem, UTS/N 18281900N908NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 2881368N908QCCook Hugh Q · Aurora, COBuilt 2020 · S/N 82854N908SCGomez Ryan Rene · Fort Worth, TXBuilt 1976 · S/N 177RG0943N908TBushby Harvey M · Minooka, ILBuilt 2009 · S/N M-II-2418N908VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1984 · S/N 2187N908WAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1978 · S/N 15281525N90908Charles Wilford W · Big Lake, AKBuilt 1981 · S/N 18-8109043N9090BHaynes Aviation LLC · Wetumpka, ALBuilt 1986 · S/N 2890003N9090LBascue Brandon D · Ward, ARFirst renewal noticeS/N 227-70N9090WRyeco Inc · Lewes, DEBuilt 1965 · S/N 28-10696N9090XTahaney David J · Fox Lake, ILS/N 2811001N90912Snead Douglas A · Derby, KSBuilt 1972 · S/N 338-73N90913Prime Travis R · Hammonton, NJS/N 893-73N90915Cnj Flying Inc · Flossmoor, ILS/N 894-73N90919Allman Joseph S · Blackstone, VABuilt 1973 · S/N 61-73N9091CYoung Gregory S · Riverside, CABuilt 1978 · S/N R18200396N9091DCanton Logan J · Petersburg, AKS/N 18-6469N9091HCampbell Raymond · Box Elder, SDBuilt 1975 · S/N 17265937N9091LAmelia Reid Aviation LLC · San Jose, CABuilt 1970 · S/N 784-70N9091VScheutzow David P · Medina, OHBuilt 1968 · S/N 690008N9091YCsa Investments LLC · Wayne, PABuilt 1969 · S/N 28R-35197N90922Blair Ernest J · St Thomas, NDBuilt 1981 · S/N 18-8109045N90923Gravesen Mark A · Kenmare, NDS/N 899-73N90928Skunberg Leonard T · Salmon, IDS/N 253-73N9092CAdirondack Aviators LLC · Peru, NYBuilt 1978 · S/N R18200397N9092HWinemiller Stevie Dale · Swifton, ARBuilt 1975 · S/N 17265938N9092JRegistered aircraftBuilt 1966 · S/N 28-3130N9092LYoung Vernon P · Metter, GAS/N 785-70N9092RSmith Michael A · The Villages, FLBuilt 1961 · S/N 1N9092VHogan Roger C · Virginia Beach, VABuilt 1969 · S/N 690004N9092WLong Earl V III DBA · Wichita, KSBuilt 1997 · S/N 246N9093Zimsim LLC · Charleston, SCBuilt 1974 · S/N 212N90931Davies Donald K · Hastings, MNBuilt 1981 · S/N 18-8109048N90932Hall Air Inc · Weiner, ARBuilt 1973 · S/N 432-73N9093FArcher 93f LLC · Danvers, MABuilt 1986 · S/N 28-8690039N9093JRichardson Harley T Jr · Mullins, SCS/N 28-3131N9093KPdg Leasing LLC · Maryland Heights, MOBuilt 1985 · S/N 28-8690032N9093LBielamowicz John Kolbe · Waxahachie, TXBuilt 1970 · S/N 228-70N9093SEllis Derek J · Austin, MNBuilt 1985 · S/N 28-8690033N9093ZCloud Niner LLC · Furlong, PABuilt 1985 · S/N 28-8690037N90943Center Of Gravity LLC · Elmira, NYBuilt 1981 · S/N 18-8109049N90945Pennison Scott J · Nikiski, AKS/N 18-8109050N90947Macleod Andrew S Trustee · Anchorage, AKBuilt 1981 · S/N 18-8109052N90948Ccf Ventures Inc · Bangor, MEBuilt 1981 · S/N 18-8109053N9094JDagny Aviation LLC · Gardendale, TXBuilt 1966 · S/N 28-3132N9094KWomack-Kalla Dennis E · Philadelphia, PABuilt 1985 · S/N 28-8690034N90957Cubcrawlers LLC · Cocoa, FLBuilt 1981 · S/N 18-8109041N90963Bloom Wade D · Eagle, IDBuilt 1972 · S/N 428-73
Back to AD 81-18-04 R2