OpenAirDocs.org
AD 95-26-15 R1

Registered aircraft · 5,440

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-15-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-15-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.

N217UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 30550N2182LGadboys Jeffrey A · Naples, FLS/N TC-1996N218CFLevel 200 LLC · Charlottesville, VABuilt 1980 · S/N 340A0989N218JPAerotrust Services Corp Trustee · Wilmington, DES/N 53305N218KDMojave Jet LLC · Wilmington, DEBuilt 1991 · S/N 1164N218MDNe-2 LLC · Houston, TXBuilt 2003 · S/N 1515N218NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1229N218PDMoye Robert W · Saint Augustine, FLS/N LF-48N218SLAlpine Aviation Inc · Provo, UTBuilt 1990 · S/N UC113N218UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30222N2197LJ Rougeau Rehab Inc · North Adams, MABuilt 1976 · S/N TC-2018N219CYCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24358N219KABank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 340B192N219MLGelbard Dustin S · Lake Havasu City, AZBuilt 1966 · S/N TE-243N219NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1255N219RMMoro Aircraft Leasing Inc · Two Rivers, AKBuilt 1988 · S/N UC-13N219UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30551N219VPAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-14N219ZCarroll Sean Terence · Saint Petersburg, FLBuilt 1964 · S/N TC-789N21BBSmartin Enterprises LLC · Phoenix, AZS/N TC-1690N21KFFans Of Nola Corp · New Orleans, LABuilt 1976 · S/N TC-1926N21RSRainier Air Inc · Wauna, WAS/N TD-224N21RW1rw LLC · Mont Vernon, NHBuilt 1967 · S/N TE-360N21RZUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N UC-106N21VMHazard John A · Vero Beach, FLBuilt 1980 · S/N TC-2301N220AAerospace Aviation Services Inc Trustee · Wilmington, DEBuilt 1965 · S/N TC-866N220BXDangberg Dennis · Wayne, NEBuilt 1972 · S/N TC-1462N220GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-220N220MJBank Of Utah Trustee · Salt Lake City, UTS/N 340B-220N220NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1262N220TDRegistration Pending · Rantoul, KSRegistration pendingBuilt 1988 · S/N 1070N220UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30223N220VStartz John D · Dallas, TXBuilt 1969 · S/N TC-1235N220XTBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 29739N221EAGlobal Acquisition Holdings LLC · Oklahoma City, OKBuilt 2002 · S/N 1476N221MJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 4038N221UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30552N222ABStanderfer William E · Fort Collins, COBuilt 1973 · S/N TC-1527N222GYSpec Air LLC · Miami, FLBuilt 1990 · S/N 1142N222JGNoyes Jeffery A · Bridgeport, TXBuilt 1959 · S/N TD-215N222MBCobb Joseph E · Cameron, TXBuilt 1964 · S/N TC-654N222RDAviation Consultants Inc · San Luis Obispo, CABuilt 1977 · S/N 340A-0366N222UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30553N222WSCenterline Aviation Services LLC · Huntsville, NCS/N TC-1311N223UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30224N224NVSunrise Asset Management LLC · Las Vegas, NVS/N 1694N224SSmith Darrell E · Duncan, OKBuilt 1965 · S/N TC-892N224UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30225N225AXOmni Planes LLC · Tulsa, OKBuilt 2001 · S/N 30434N225DCAvion LLC · Birmingham, ALBuilt 1994 · S/N 1253
Back to AD 95-26-15 R1