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.

N9577MStaton Jered · Rochester, MNBuilt 1966 · S/N 670154N9577USoluserv LLC · Caldwell, TXBuilt 1975 · S/N AA5A-0077N9577VMdr Flying Inc Trustee · Wilmington, DEBuilt 1974 · S/N 17264379N9577WIasco Flight Training Inc · Redding, CABuilt 1998 · S/N 17280527N9577ZAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280528N95787Wisconsin Aviation - Four Lakes Inc · Madison, WIBuilt 1985 · S/N 15285967N9578BHalseth Harald E · El Paso, TXBuilt 1981 · S/N 172RG0895N9578ENorton Tim C · Danville, VAS/N 76-31130N9578JDesbien Paul D · Texhoma, OKBuilt 1966 · S/N 28-3716N9578LRegistration Pending · Hoover, ALRegistration pendingBuilt 1974 · S/N AA5-0578N9578POldenburg Scott J · Kasilof, AKS/N 18-7609156N9578UScheutzow David P · Medina, OHS/N AA5A-0078N95797Kent State University · Stow, OHBuilt 1985 · S/N 15285968N9579CVan Winkle Steven Russell · East Berlin, PABuilt 1978 · S/N 28-7890425N9579DLee Gerald R · Glennallen, AKBuilt 1958 · S/N 186764N9579JGarrity Richard R · Green Bay, WIBuilt 1966 · S/N 28-3717N9579LJackson Richard B · Cambria, CABuilt 1974 · S/N AA5-0579N9579UBoland Kelly A · Fort Worth, TXBuilt 1975 · S/N AA5A-0079N9579VPlaisted Aviation LLC · Elk River, MNBuilt 1998 · S/N 17280529N957ATetzlaff Christian · Athens, GABuilt 1951 · S/N 22-269N957BHHiggins William J · Plymouth, MABuilt 2010 · S/N 25749N957DDDon Davis Aviation Inc · Henderson, KYBuilt 2021 · S/N 172S12775N957DHEddy Stephen Michael · Benton, KSBuilt 1996 · S/N 22887N957DJKim Sung Su · Upland, CABuilt 1990 · S/N 3084N957DMCosbie Lee Roy · Tuscumbia, ALBuilt 2009 · S/N 6-6400N957DSDelta State University · Cleveland, MSBuilt 2024 · S/N 314/USN957EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S13001N957ESVolar I LLC · Edmond, OKBuilt 2008 · S/N 172S10675N957JACbmw LLC · Wise, VABuilt 1978 · S/N 3308N957MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2023 · S/N 40.1239N957PDEverything Pitts LLC · Queen Creek, AZBuilt 1998 · S/N 6001N957RVWilson Tyler J · Lynnwood, WABuilt 2009 · S/N 72608N957SSkymark Airlines · Sacramento, CARegistration revokedBuilt 1962 · S/N 27-2136N957TSevern Valley Aviation Inc Trustee · Wilmington, DEBuilt 2000 · S/N 3246176N957TEConlon Kevin P · Lake Geneva, WIBuilt 2004 · S/N 10236N957UMBecker Brian S · Portage, WIBuilt 1990 · S/N AG5B-10002N957WALuy Wayman A · Weston, FLBuilt 1990 · S/N 1057N957WBWelch Mark A · West Hartford, CTBuilt 2024 · S/N 42129N9580JFrontier Adventure Flyers LLC · Colorado Springs, COBuilt 1966 · S/N 28-3718N9580LBlack Carrell C · Cochranville, PABuilt 1974 · S/N AA5-0580N9580MRegistration Pending · Campbellsville, KYRegistration pendingBuilt 1966 · S/N 670157N9580URogers Ronald G · Forest, VABuilt 1975 · S/N AA5A-0080N9580WDestination Flyer LLC · Memphis, TNBuilt 1967 · S/N 28-23025N9581GN9581g Corp · Skokie, ILBuilt 1998 · S/N 17280530N9581SKing John D · Midland, VABuilt 1966 · S/N 192N9581VMartin Northern Aviation LLC · Benton, ARBuilt 1998 · S/N 18280257N95821Kent State University · Stow, OHBuilt 1985 · S/N 15285970N9582DMontminy John · Berlin, NHBuilt 1958 · S/N 22-6489N9582HMiller Timothy · Saratoga, CABuilt 1975 · S/N 17266244N9582VCady Craig D · New Braunfels, TXBuilt 1974 · S/N 17264384
Back to AD 81-18-04 R2