OpenAirDocs.org
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.

N201PFMooney Flyers LLC · Minot, NDBuilt 1977 · S/N 24-0145N201PJBrownfield Izzy · Denton, TXBuilt 1977 · S/N 24-0180N201PKMininger John · Quakertown, PABuilt 1977 · S/N 24-0278N201PLM Star Aviation LLC · Oconto, WIBuilt 1977 · S/N 24-0284N201PNAkins Anthony · Meridian, IDBuilt 1977 · S/N 24-0302N201PPRohrbach James S · Fort Lauderdale, FLBuilt 1979 · S/N 24-0846N201PQBlue Steel Ventures LLC · Wilmington, NCBuilt 1977 · S/N 24-0287N201PSEmbrey Matthew D · Murrieta, CABuilt 1977 · S/N 24-0113N201PTWells Tony · Knob Lick, KYBuilt 1977 · S/N 24-0106N201PVCowan George L · Scranton, SCBuilt 1977 · S/N 24-0321N201PXNecessary Richard A Jr · Rural Hall, NCBuilt 1977 · S/N 24-0315N201PYRandolph Paul D · Easley, SCS/N 24-0310N201PZSmits Joel R · Crete, ILBuilt 1977 · S/N 240329N201QAIron Wing Flying Club Inc · Shelby Township, MIBuilt 1977 · S/N 24-0317N201QBQuattlebaum Kevin R · High Rolls, NMBuilt 1979 · S/N 240895N201QCDigital Outdoor Adertising LLC · Reno, NVS/N 24-0305N201QEWaters Michael C · Social Circle, GABuilt 1977 · S/N 24-0343N201QHPodd Bradley Stephen · Wilmington, NCBuilt 1977 · S/N 24-0348N201QJDubritz Michael J · Dix Hills, NYBuilt 1977 · S/N 24-0347N201QLBuchholz Michael S · West Hamlin, WVBuilt 1986 · S/N 24-1604N201QMNordica Group Ltd · Chicago, ILBuilt 1977 · S/N 24-0339N201QRJennings Denise E Trustee · Fullerton, CABuilt 1977 · S/N 24-0353N201QSLaughridge Mark L · Apopka, FLBuilt 1977 · S/N 24-0325N201QTR Squared LLC · Brandon, MSBuilt 1977 · S/N 24-0309N201QUModen Aircraft Inc Trustee · Wilmington, DEBuilt 1991 · S/N 243216N201QVJohnson Philip H · Bluffton, SCS/N 24-0355N201QWRose James D · Fort Worth, TXS/N 24-0236N201QXRegistration Pending · Portland, ORRegistration pendingBuilt 1977 · S/N 24-0367N201QYJohnson Seth M · Arlington, TXBuilt 1977 · S/N 24-0357N201QZFogle Adventure Air LLC · Neeses, SCS/N 24-0358N201RMay Jack C · Conroe, TXBuilt 1977 · S/N 24-0203N201RAMooney 201ra Holding LLC · San Diego, CABuilt 1982 · S/N 24-1319N201REFowler W Kirk · Longmont, COBuilt 1977 · S/N 24-0341N201RFMfc Corp · Washington, DCS/N 24-0135N201RGCrate Thomas Trustee · Las Vegas, NVBuilt 1989 · S/N 24-3138N201RJLoyless John B · Lubbock, TXBuilt 1977 · S/N 24-0115N201RLGmg Associates · Madison, CTBuilt 1977 · S/N 24-0143N201RPLanter Patricia Diane · Camarillo, CABuilt 1992 · S/N 24-3255N201RRGuthrie Edward J · Lincoln Univ, PABuilt 1977 · S/N 24-0089N201RSWilliams Ken L · Palmer, AKBuilt 1976 · S/N 24-0062N201RTRed Tail Av8rs LLC · Saline, MIS/N 24-1109N201RUMoore James B · Yorktown, VAS/N 24-0360N201RWRodriguez Ricardo A · Norristown, PAS/N 24-0158N201RX201rx LLC · Russellville, ALBuilt 1977 · S/N 24-0311N201RYTop Shelf LLC · West Fargo, NDBuilt 1977 · S/N 24-0257N201RZGoller Daniel M · Grass Lake, MIBuilt 1977 · S/N 24-0327N201SAQuinn Timothy M · South Haven, MIBuilt 1977 · S/N 24-0114N201SBPatterson James L · Grandview, TXBuilt 1983 · S/N 24-1388N201SDHendin Stuart M · Westminster, MDS/N 24-1611N201SECooper William C · Midlothian, TXBuilt 1990 · S/N 24-1706-14
Back to AD 95-26-16 R1