AD 95-26-16 R1

Registered aircraft · 1,406

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:95-26-16-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-16-R1')
  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.

N5778CTieman Matthew · Chapel Hill, NCS/N 24-1613N5779YMetz Timothy G · Chattanooga, TNBuilt 1984 · S/N 24-1510N5780YShields Thomas J · Port Orange, FLBuilt 1984 · S/N 24-1511N5785MCanon James P · Calumet, OKBuilt 1984 · S/N 24-1520N5785TLos Alamos Aero Services LLC · Los Alamos, NMBuilt 1984 · S/N 24-1521N5786ZCampagnone Robert P · Columbia, CTFirst renewal noticeBuilt 1984 · S/N 24-1523N5788YWright Brent Alan · Colleyville, TXBuilt 1984 · S/N 24-1524N5789SSierra Aero Corp · Totowa, NJBuilt 1984 · S/N 24-1527N5795DQualitair LLC Trustee · MichelstadtBuilt 1984 · S/N 24-1532N57986Registered aircraftBuilt 1984 · S/N 24-1533N58016Budley Ltd · Muskegon, MIBuilt 1985 · S/N 24-1536N5801CFly-A-Way Leasing Corp · Farmington Hills, MIBuilt 1985 · S/N 24-1534N5801NN5801n LLC · Lewes, DES/N 24-1606N58060Pacer Flying Club Inc · Millbrae, CABuilt 1985 · S/N 24-1538N58062Des Moines Flying Club LLC · Indianola, IAS/N 24-1540N58065Smith Richard Trustee · Dublin, CAS/N 24-1616N58079Byrne David P · Ojai, CAS/N 24-1638N5807SFisher Gary C · Louisburg, KSBuilt 1988 · S/N 24-3065N5807TRoyal Treatment Carriers Inc · San Antonio, TXBuilt 1985 · S/N 24-1543N58086Omg Aviation LLC · Benton, KSBuilt 1985 · S/N 24-1552N5808APas Services LLC · Townsend, DEBuilt 1994 · S/N 24-3334N5808PWatson James Christopher · Boerne, TXBuilt 1985 · S/N 24-1548N58097Avinash M Mondkar Md Mc · Payson, AZBuilt 1985 · S/N 24-1556N5809HN5809h Aviation LLC · Kalispell, MTBuilt 1985 · S/N 24-1553N58102Laperle George M · Santa Barbara, CABuilt 1986 · S/N 24-3008N58103Registered aircraftS/N 24-3009N58105Mooney Skies Unlimited LLC · Merritt Island, FLS/N 24-3059N58107Perez Jeremiah · Fort Worth, TXS/N 24-1627N5811CSon Of A Gun Aviation LLC · Cherry Hill, NJS/N 24-1546N58120Air Giblinski LLC · Sedgwick, KSS/N 24-1647N5812TRegistered aircraftBuilt 1985 · S/N 24-1559N58135Petticrew Travis R · Mckinney, TXBuilt 1986 · S/N 24-1567N5813FGalligan Derek · Portland, ORBuilt 1985 · S/N 24-1563N5813UStackhouse Thomas G · Bethlehem, PAS/N 24-1649N58143Sustich Steven R · Odessa, TXBuilt 1985 · S/N 24-1573N58144Low Daniel A · Los Angeles, CABuilt 1985 · S/N 24-1574N58148Wilkerson James · Howell, MIS/N 24-3000N5814QKlapper Robert D · San Jose, CABuilt 1985 · S/N 24-1570N5814TMulligan Shawn Patrick · Santa Rosa, CABuilt 1985 · S/N 24-1571N5814YSarshad Todd · San Pablo, CABuilt 1985 · S/N 24-1572N58153Marsan Steve R · Sisters, ORS/N 24-1580N58156Kim Seuk · Springfield, VABuilt 1986 · S/N 24-1582N58158Austin Mooney Flyers LLC · Austin, TXBuilt 1984 · S/N 24-1509N58159Mcclure Jeffrey S · Loomis, CAS/N 24-1650N5815CFrogmore Flyers LLC · St Helena Is, SCBuilt 1985 · S/N 24-1576N5815SClear Aire LLC · Las Vegas, NVBuilt 1986 · S/N 24-1577N5815XMorozov Nikolai · Tucson, AZBuilt 1986 · S/N 24-1578N58162Link Stanley C · Theodosia, MOS/N 24-1587N58166Harrie Michael Raymond · Marsing, IDS/N 24-1588N5816TCrossroad Productions LLC · Covington, LABuilt 1985 · S/N 24-1569
Back to AD 95-26-16 R1