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.

N816RDHoffman Aeronautics LLC · Sedalia, COBuilt 2023 · S/N 172S12987N816RFTerhaar Ronald D · Albany, ORBuilt 2009 · S/N 40097N816RMRegistered aircraftBuilt 2024 · S/N 42201N816STForensic Doctors Group Pc · San Francisco, CABuilt 1985 · S/N 323N816SWUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2007 · S/N 172S10576N816TRGood Day Holdings LLC · Sheridan, WYBuilt 2022 · S/N 18283173N816TSCd Logic Inc · Wilmington, DEBuilt 1985 · S/N 24-1562N816TXDavis Derek P · Sebastian, FLBuilt 1979 · S/N R18200811N816WAFredericks Ruth · Miami, FLS/N 28-7525173N816WBNorthern Aggregate Inc · Bemidji, MNBuilt 1980 · S/N 32-8006015N816WLRumsey Todd · Sturgis, MIBuilt 2009 · S/N 2412N816WMRent A Copter LLC · Homer Glen, ILBuilt 2000 · S/N 0824N816WRDonovan Mark J DBA · Moultonborough, NHBuilt 1982 · S/N 18-8309017N816YQazwbt LLC · Arroyo Grande, CABuilt 2003 · S/N 2273N8170CGibbens Brett S · Mc Grath, AKBuilt 1954 · S/N 18-3626N8170FAlfonso Peter J · Jamestown, RIBuilt 1980 · S/N 32R-8013071N8170NFalter George H III · Baltimore, MDBuilt 1968 · S/N 28-25366N8171Thaven Aviation LLC · Edwards, COS/N 81320N81713Brown Matthew · Spokane, WABuilt 1980 · S/N 28-8016290N81715Registration Pending · Hanford, CARegistration pendingS/N 28-8016291N8171CPeed Aviation Inc · Casa Grande, AZBuilt 1954 · S/N 18-3627N8171DLueking Clyde F · Holdrege, NEBuilt 1957 · S/N 18-6100N8171NOndrovic Rick · Belton, SCBuilt 1968 · S/N 28-25367N8171YFaith Works Aviation LLC · Glenmoore, PABuilt 1980 · S/N 28-8016284N8172Magrini Shawn P · Salem, OHBuilt 1970 · S/N RJB-2N81723Aero Legacy Foundation · Basehor, KSS/N 31047N81729Bushroe Dennis J · Temperance, MIBuilt 1996 · S/N 20847N8172CDrath Mark O · Reedsville, WIBuilt 1954 · S/N 18-3628N8172NBeasley Michael Jeffrey · Dothan, ALS/N 28-8090261N8172QFrost Aviation Services Inc · Las Cruces, NMBuilt 1980 · S/N 28-8090263N8172WMile High Advertising LLC · Dover, DEBuilt 1965 · S/N 28-2294N8172YKline John C · Wolcottville, INBuilt 1966 · S/N 30-1286N8172ZAverka Steven D · Sutton, MABuilt 1980 · S/N 28-8090264N8173DAaa Flying Service Inc · Wellington, TXBuilt 1957 · S/N 18-6097N8173ESky Equity LLC · Woodbury, MNBuilt 1978 · S/N 17272147N8173HMcmahon Mary G · Winchester, CABuilt 1980 · S/N 28-8011097N8173NJones Roy F · Benson, AZBuilt 1968 · S/N 28-25369N8173WRoadrunner Flight School LLC · Farmington, NMS/N 28-2295N8173YAltitude Aviation Group LLC · Kissimmee, FLS/N 30-1287N81741Corsican Aviation LLC · Westfield, INBuilt 1980 · S/N 28-8090134N81749Friend Aircare Inc · Washington, PABuilt 1982 · S/N 28-8290107N8174MFlight Time Builders Inc · Memphis, TNBuilt 1972 · S/N 17260574N8174PIglewski Rudolph Daniel II · Apache Junction, AZBuilt 1963 · S/N 24-3430N8174WJeffers Coreen · Bellmawr, NJBuilt 1965 · S/N 28-2298N8174XJones Aaron B · Bruceton Mills, WVBuilt 1980 · S/N 28-8011067N8174YStansbury Todd V · Centennial, COS/N 30-1289N81756Jrny Air LLC · Everett, WABuilt 1982 · S/N 32R-8313013N8175CYates Trucking Inc · Quartz Hill, CABuilt 1975 · S/N 28R-7635132N8175EHigh Planes Aviation LLC · Goodland, KSBuilt 1959 · S/N 1446N8175HHowe Richard B · San Luis Obispo, CABuilt 1980 · S/N 28-8016292
Back to AD 81-18-04 R2