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.

N225JPBrazos River Aviation Group LLC · Mineral Wells, TXBuilt 1959 · S/N TD-270N225NE2/25/94 LLC · Foxboro, MABuilt 1991 · S/N 25194N225PGAero 7 LLC · Doral, FLS/N 25247N225R707 Aviation LLC · Batesville, MSBuilt 1974 · S/N TC1728N225UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30554N225VBas Part Sales LLC · Greeley, COBuilt 1966 · S/N TE-123N2265TOracle Aviation LLC · Omaha, NEBuilt 1980 · S/N ME-333N226DRTechnical Education Services Inc · Virginia Beach, VABuilt 1967 · S/N LM-14N226MPExecutive Jet Group LLC · Opa Locka, FLBuilt 1996 · S/N 1300N226RS226rs LLC · Cypress, TXBuilt 2002 · S/N 1479N226UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 30226N227AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27448N227BYAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1970 · S/N TC-1347N227CYCargo Aircraft Management Inc · Wilmington, OHBuilt 1996 · S/N 26327N227UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 30555N22889Tenax Aviation LLC · Ridgeland, MSBuilt 1998 · S/N UE-314N228DGKonair US LLC · Miami, FLS/N 128N228NVSunrise Asset Management LLC · Las Vegas, NVBuilt 1997 · S/N 716N228PLCrimmins Nathanael D · Glasgow, KYBuilt 1968 · S/N TC-1180N228RECape Clear LLC · Westborough, MABuilt 2001 · S/N 1438N228UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 30556N229AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 27059N229RBSouthern Utah University · Cedar City, UTBuilt 1978 · S/N TC-2100N229SWBerry Aviation Inc · San Marcos, TXBuilt 1995 · S/N 120.305N229UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 30557N22BBSpillman Robert · Port Orange, FLBuilt 1967 · S/N LJ-241N22BSSmith Aviation Inc · Wilmington, DEBuilt 1976 · S/N TC-1928N22EWHoltaway Robert F · Bullock, NCBuilt 1968 · S/N TC-1058N22LW22lw LLC · New Port Richey, FLBuilt 1973 · S/N TC-1559N22TAWoodling Jason D · Venice, FLBuilt 1959 · S/N TD-250N22WPMatulich Ronald G · Drytown, CABuilt 1967 · S/N TC-1045N230ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 3667N230DAHot Seat Aviation · Blacksburg, VAS/N TC-387N230FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6773N230NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2001 · S/N 1372N230QKuper Carl J II · Dalhart, TXBuilt 1966 · S/N TE-278N231XCMojave Jet LLC · Nolensville, TNS/N 231N231YVAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-231N231ZHolland Douglas A · Wichita Falls, TXBuilt 1962 · S/N TC-370N2320AStructural Integrity Systems LLC · Wichita, KSBuilt 1977 · S/N TC-2113N232FN232k LLC · Midland, TXBuilt 1993 · S/N 1232N232FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6838N233AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29430N233FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7095N233NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2003 · S/N 2001N233SWBerry Aviation Inc · San Marcos, TXBuilt 1995 · S/N 120.307N234ATr Aero LLC · Poway, CABuilt 1972 · S/N TC-1437N234AXCargo Aircraft Management Inc · Wilmington, OHBuilt 2001 · S/N 30436N234MMWalt Disney World Co · Lake Buena Vista, FLBuilt 1963 · S/N 121N234MSVertical Horizon Aviation LLC · Sandown, NHBuilt 1975 · S/N 3400351
Back to AD 95-26-15 R1