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.

N7879WFlyhome One LLC · Chandler, AZBuilt 1964 · S/N 28-1903N787AAMkpeaches Properties LLC · Newark, DEBuilt 2016 · S/N 81826N787ANDixon Richard W · Laytonsville, MDBuilt 1962 · S/N 24-3308N787ATCentral Virginia Flyers Flying Club Inc · Glen Allen, VABuilt 1976 · S/N 17267881N787AUAuburn University · Auburn, ALBuilt 2019 · S/N 4496457N787BKAmeri Aircraft Sales And Service LLC · Champaign, ILBuilt 2021 · S/N BCV 21006N787BRNaron Robert W · Poolville, TXBuilt 1965 · S/N 28-2091N787BTThompson Brian K · Green Cove Springs, FLBuilt 2024 · S/N 73710N787CJInternational Air Services Inc Trustee · Carson City, NVBuilt 2010 · S/N 2843679N787CPArnett Wallace · Sullivan, INBuilt 1968 · S/N 17257760N787DHHodge Stephen E · Tipp City, OHBuilt 2017 · S/N 91514N787DJDgj Tex LLC DBA · Cleburne, TXBuilt 1977 · S/N 28-7816014N787EBStith Michael P · Boiling Springs, SCS/N AA5-0819N787ECSky Safety Inc · San Antonio, TXBuilt 2005 · S/N 40.529N787EMHughes David R Trustee · Fort Knox, KYS/N 1616N787EZKordel Kade France · Allen, TXBuilt 1985 · S/N 1217N787FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13164N787FBHot Wings Aviation LLC · Fishers, INBuilt 2025 · S/N 28020210N787FMMelillo Vince · Belvidere, ILBuilt 1978 · S/N 15281802N787GHHelbach George · Black River Falls, WIBuilt 2023 · S/N 3411N787GLTfa Holding Corp · Daytona Beach, FLBuilt 2007 · S/N 172S10577N787GWRegent Trust Corp Trustee · Wichita, KSBuilt 2004 · S/N 25101CN787KSWalden Franklin S · Southern Pines, NCBuilt 1964 · S/N 24-3644N787LFH&R Aviation LLC · West Linn, ORBuilt 2011 · S/N 172S11125N787LHLawyers Real Estate Services LLC · Roswell, NMBuilt 2018 · S/N 001N787MDGeorgia Forestry Commission · Macon, GABuilt 2011 · S/N 18282308N787MPWherrell Chad · Okeechobee, FLBuilt 1979 · S/N 18-7909141N787MTHeppe Andrew S DBA · Turner, MTFirst renewal noticeBuilt 1966 · S/N 18-8425N787NDuenas Carlos · Hurricane, UTBuilt 2007 · S/N 2123N787PCLivingtofly1 LLC · Ball Ground, GABuilt 1979 · S/N R18200867N787PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7350033N787PMJacobs Philip · Dickson, TNBuilt 2005 · S/N T18208429N787RGCareer Aviation Company Inc · Wilmington, DEBuilt 1978 · S/N R18200816N787RHRushing Christian W · Savannah, GABuilt 1978 · S/N 435-78N787RPSilver Fox Aircraft LLC · Queen Creek, AZBuilt 1985 · S/N 28-8690025N787RSJjd Holdings LLC · Fort Madison, IABuilt 2005 · S/N 3232040N787SDDornberger Eric A · Aurora, COBuilt 2016 · S/N 91472N787SGContainer Stop Inc · Paso Robles, CABuilt 1953 · S/N 18-2916N787SPSierra Tango Ventures LLC · Monte Sereno, CABuilt 2001 · S/N 172S8714N787STCitabria N787st LLC · Reno, NVS/N 486-2004N787TKennedy Thomas M · Long Beach, CABuilt 2015 · S/N 0248N787TBWoods Phillip A · Cimarron, KSBuilt 1996 · S/N 22127N787TFAir Fleet Holdings LLC · Missoula, MTBuilt 2022 · S/N 2881555N787TJTate John D · Roseville, CABuilt 2019 · S/N 60124N787TKIal Corp · Lewes, DES/N 2881144N787WAnequim LLC · Omaha, NEBuilt 2000 · S/N 1107N787WTSemper Supra Air LLC · Ashland City, TNBuilt 1978 · S/N 17271319N78804Whitt James M · Meadowview, VABuilt 1968 · S/N 17257772N78805Fugleberg Richard H · Mayville, NDBuilt 1968 · S/N 17257773N78808Ginter Michael J · Oakland, MDBuilt 1968 · S/N 17257774
Back to AD 81-18-04 R2