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.

N5357WJones Michael A · Greer, SCBuilt 1962 · S/N 28-421N5357XFirn Line Aviation Inc · Wasilla, AKS/N 18-7391N53587Chapel Hill Flying Club Inc DBA · Sanford, NCBuilt 2003 · S/N 172S9407N53588Davis Charles · Sanford, FLBuilt 1981 · S/N 17274782N5358DXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 17272543N5358HDaniels Scott M · Litchfield, MEBuilt 1949 · S/N 16-165N5358LTwidwell Jon J · Olathe, KSS/N 28-4661N5358PWilliams George A · Bonifay, FLBuilt 1958 · S/N 24-306N5358TCarr Jon C · Shell Knob, MOBuilt 1982 · S/N R18201860N5359FWashington Fliers Club Inc · Washington, IABuilt 1976 · S/N 28-7790098N5359KAbove And Beyond Aviation LLC · Austin, TXBuilt 2003 · S/N 172S9447N5359LFirst Flight Corp · San Diego, CABuilt 1968 · S/N 28-4663N5359PPanhandle Groundwater Conservation District · White Deer, TXBuilt 1958 · S/N 24-408N5359SRegistered aircraftBuilt 1980 · S/N R18201554N5359ZSale Reported · Crozet, VASale reportedS/N 22-9085N535EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13168N535FLJestes Monte G · Stillwater, OKBuilt 2005 · S/N F-3747N535HFPars Avn Corp · Wilmington, DEBuilt 2000 · S/N 17280926N535KSKent State University · Stow, OHBuilt 2013 · S/N 172S11321N535LEAirman Helicopter Inc · Fort Lauderdale, FLBuilt 2026 · S/N 2857N535LMMillcopter LLC · Wahpeton, NDBuilt 2007 · S/N 1790N535RHHarkness Richard · Hanahan, SCBuilt 2017 · S/N 7087N535TCNichols Craig J · Andover, MNBuilt 1947 · S/N 12-3976N535TKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 14025CN535TWJohnson William · New Wilmington, PABuilt 1973 · S/N 28R-7335381N535WPMcmillin Robert E · Wampum, PABuilt 2007 · S/N 90825N53600Kdrd Holdings LLC · Texas City, TXS/N 17272544N53603Wings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 17274786N5360HEastern Stearman Inc Trustee · Leesburg, VABuilt 1949 · S/N 16-167N5360JFly Montana LLC · Miles City, MTBuilt 1980 · S/N 17273763N5360KN5360k LLC · Lebanon, MOBuilt 2002 · S/N 3246207N5360LKitzmiller Peter Charles · Seattle, WAS/N 28-4664N5360PN5360p LLC · Blacklick, OHBuilt 1958 · S/N 24-409N5360WShaffer Thomas D · Round Rock, TXS/N 28-425N53611Aero Mobil Inc · Wilmington, DEBuilt 1981 · S/N 17274787N53614Orange County Flight Center Inc · Santa Ana, CABuilt 2003 · S/N 172S9413N5361HNall Melvin J · Luthersville, GABuilt 1949 · S/N 16-168N5361KLong Island Soaring Association · Shirley, NYBuilt 1980 · S/N 17274080N5361NKdb LLC · Underwood, IABuilt 2003 · S/N 2843549N5361WRoberts Misty L · Fountain Hills, AZBuilt 1962 · S/N 28-426N53622Mc Air LLC · Miami Beach, FLBuilt 1981 · S/N 17274788N5362FPetros Michael · Chandler, AZBuilt 1976 · S/N 32-7600024N5362HMccue Tedd R · Eveleth, MNBuilt 1975 · S/N 17265412N5362LTiedemann Douglas A · Skaneateles, NYBuilt 1968 · S/N 28-4667N5362UHebert Loree W Jr · Saint Francisville, LABuilt 2003 · S/N 2843555N5362XSky West Aviation Inc Trustee · Albuquerque, NMS/N 18-6685N53630Arlington Flight Services Inc · Arlington, WABuilt 1981 · S/N 17274789N53632Siple Aviation LLC · Kalispell, MTS/N 17274791N5363HBauer Dereck R · Springfield, ORBuilt 1949 · S/N 16-172N5363JPulliam Joe Clinton Jr Trustee · Pilot Point, TXBuilt 2003 · S/N 2843559
Back to AD 81-18-04 R2