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.

N8786NSorenson Kyle F · Deaver, WYBuilt 1969 · S/N 28-25772N8786WPhoenix Eengineering LLC · Valley Center, CABuilt 1964 · S/N 28-10333N87875Rice John D · Maddock, NDBuilt 1954 · S/N 18-3589N87876Plauger George V Jr · Beverly, WVBuilt 1987 · S/N 18-3595N87878International Air Services Inc Trustee · Carson City, NVBuilt 1959 · S/N 24-469N8787CBrolan Aviation LLC · Kansas City, MOBuilt 1976 · S/N 28-7690165N8787EMyers Danny A · Saint Charles, MOBuilt 1976 · S/N 28-7615163N8787FLibby Nicholas J · Olympia, WABuilt 1976 · S/N 28-7715289N8788CSaflight Pilot Training Inc · Manchester, NHS/N 28R-7635182N8788DMartens Edwin L · Ogallala, NEBuilt 1958 · S/N 18-6325N8788ECoastal Fliers Inc · El Cajon, CABuilt 1976 · S/N 28-7690204N8788RRicher Ned A · Glendale, AZBuilt 2016 · S/N 91895N8788WMacken Jason P · Lancaster, NYBuilt 1964 · S/N 28-10335N8788YAerotransit Inc · Milwaukee, WIS/N 30-1946N87898Scott Shawn · Darrington, WAS/N 440301N8789CPainter Joe S · Buffalo, SDFirst renewal noticeBuilt 1953 · S/N 18-2885N8789DStrembicke Derek R · Owens Cross Roads, ALS/N 18-6326N8789TChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12408N878ACDecathlon LLC · Herndon, VABuilt 2001 · S/N 878-2001N878ALCathcart Richard Gordon · Covington, VABuilt 2018 · S/N 65-10175N878BREva Flight Training Academy · Mather, CABuilt 2025 · S/N 40.1263N878CBPollux Aviation Ltd · Wasilla, AKBuilt 2004 · S/N 10404N878CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281868N878DRFive Star Aviation LLC · Greer, SCS/N 32-46055N878DZSlayback Eric J · Florence, KYBuilt 2004 · S/N 81885N878EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12684N878JMVaughan William F · Henryville, INBuilt 1973 · S/N 177RG0450N878MAAgri Med LLC · Belgrade, MTBuilt 2006 · S/N 1415-2006N878MCHelicopter Leasing LLC · Henderson, NVBuilt 2005 · S/N 3782N878RMBowman Mark R · Tillamook, ORBuilt 2013 · S/N 145N878RVVenohr Robert E · Aurora, COBuilt 2006 · S/N 81663N878SATampa Bay Aviation Inc · Clearwater, FLBuilt 2006 · S/N 172S10209N878WSWallace State Community College · Hanceville, ALBuilt 2021 · S/N 28020033N878ZCrawford Chris M · Petersburg, VAS/N 80096N8790CAltitude Unlimited Inc · Lewes, DEBuilt 1953 · S/N 22-1402N8790EFenty Brandon · Normandy, TNBuilt 1976 · S/N 28R-7635214N8791EKl&Z Farms LLC · Littleton, NCBuilt 1976 · S/N 32-7600012N8791LMarkes Tim · Douglas, OKBuilt 1970 · S/N 25-5278N8791NVetter Daniel W · Dayton, NVBuilt 1969 · S/N 28-25631N8791WRegistration Pending · Johns Island, SCRegistration pendingBuilt 1964 · S/N 28-10339N8791YGeboy Alan R III · Baxley, GABuilt 1969 · S/N 30-1949N8792DAndresen Elouise H · Anchorage, AKBuilt 1958 · S/N 18-6333N8792NPiotrowski Nicholas S · Poplar Grove, ILBuilt 1969 · S/N 28-25633N8792PPrivette Richard E · Oak Hill, FLBuilt 1965 · S/N 24-4245N8792WHale Mitchell D · Chugiak, AKBuilt 1964 · S/N 28-10340N8793LVoerman Joseph R Jr · Cambridge, NYBuilt 1974 · S/N 18-7409125N8794FMundell Terry D Trustee · Rosston, OKBuilt 1962 · S/N 103-0002N8794GBarrymore Blake · Hailey, IDBuilt 2019 · S/N JA515-12-17N8794NCopeland Kevin D · Vidalia, GABuilt 1969 · S/N 28-25637N8795NCycle-Moto Inc · Gilbert, AZBuilt 1969 · S/N 28-25639
Back to AD 81-18-04 R2