OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N2900ZCheatham Paul · La Verne, CABuilt 1959 · S/N 22-6868N2901ALa Hoz Bruno · Canyon Country, CABuilt 1979 · S/N 28-7916524N2901MRickard William A · Virginia Beach, VABuilt 1946 · S/N 12-1325N2901XErwin Brandon · Jacksboro, TXBuilt 1967 · S/N 17700301N2901ZSmith Roger L · Los Alamos, NMBuilt 1959 · S/N 22-6873N29021Kough Brian R · Plant City, FLBuilt 1979 · S/N 28R-7918133N29028Service Oriented Aviation Readiness (Soar) · Bolivar, MOBuilt 1974 · S/N 17264095N2902BSky Angel LLC · Sikeston, MOBuilt 1979 · S/N 28-7990538N2902LIvey Steven L · Graniteville, SCBuilt 1967 · S/N 670065N2902MKelsey Michael O · Carey, IDBuilt 1946 · S/N 12-1362N2902PHentgen Chip · Peru, INBuilt 1955 · S/N 22-3168N2903DBecker Paul J · Spring Hill, FLBuilt 1979 · S/N 28-7990542N2903LSchillinger Bradley Charles · Honeoye Falls, NYBuilt 1967 · S/N 670066N2903MKrog Steven L · Hartford, WIBuilt 1946 · S/N 12-1327N2903XBrowning Mcpherson Aviation LLC · Auburn, KYBuilt 1967 · S/N 17700303N29047State College Pilots Club · Philipsburg, PABuilt 1974 · S/N 17264096N29049Weiman Magnus · Lynchburg, VABuilt 1979 · S/N 28-7990429N2904MLange Keith J · Wasilla, AKBuilt 1946 · S/N 12-1318N29056Land Of Lakes Aviation LLC · Eagle River, WIBuilt 1974 · S/N 17264097N2905BHawley Timothy J · Ashland, OHBuilt 1979 · S/N 32-7940194N2905ECappadona Roy · Iliamna, AKBuilt 1978 · S/N 17271369N2905LSteel Alan P · Odessa, TXBuilt 1967 · S/N 670299N2905PSimpson Danny R · Waunakee, WIBuilt 1955 · S/N 22-3172N2905XRudy Schmitt · Brookshire, TXBuilt 1967 · S/N 17700305N2905ZWmh Aviation LLC · Buckley, WABuilt 1978 · S/N 358-78N29062Jackson Stephen D · Pennsboro, WVBuilt 1979 · S/N 28-8011054N2906LHogue Aviation LLC · Dover, PABuilt 1967 · S/N 670300N2906MFry Steven G · Eagle River, AKBuilt 1946 · S/N 12-1321N2907Cizek Joseph E · Wasilla, AKBuilt 2017 · S/N 2016N29070Buzick Carey B · Fargo, NDBuilt 1978 · S/N R18200639N29076Flight Dynamics LLC · De Leon Springs, FLBuilt 1987 · S/N 1022N2907MKutschera Thomas C · Youngsville, NYBuilt 1946 · S/N 12-1322N2907PWickenheiser John D · Newport, MIBuilt 1955 · S/N 22-3175N2907RFricks Cline Thomas Jr · Toccoa, GABuilt 1969 · S/N 28R-35324N2907VPort Townsend Aero Museum · Port Townsend, WABuilt 1949 · S/N 123N2907ZCabana Robert D · Cocoa, FLBuilt 1978 · S/N 377-78N2908GGraves Sam · Tarkio, MOBuilt 1959 · S/N 263N2908LGurney Stephen E · Niceville, FLBuilt 1967 · S/N 670302N2908PHull Mahlon B · Sedro Woolley, WABuilt 1955 · S/N 22-3176N2908UBarrett H Gould · Myrtle Beach, SCS/N 1023N29098Gill Stuart W Jr · Kingsport, TNBuilt 1979 · S/N 28-7990436N2909BIsland Hoppers Inc · Glenridge, NJBuilt 1979 · S/N 32-7940196N2909DPainter Kelly A · Cantwell, AKBuilt 1955 · S/N 26852N2909QHelman Tom · Evanston, WYBuilt 1979 · S/N 28-7916533N290AMWheaton Megan E · Orchard Park, NYS/N 2096N290CPCivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283321N290DBByers Kathleen R · Rigby, IDS/N 698N290DMWalker George R · Mableton, GAS/N 156N290DSNakel Inc · Elkton, SDBuilt 2003 · S/N 40.290N290FBAstarb John E · Baden, PAS/N 1
Back to AD 81-18-04 R2