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.

N332JNMenzel Michael Alexander Jr · Peculiar, MOS/N 24-1517N333CDIct Flyilng LLC · Pelham, ALBuilt 1988 · S/N 24-3057N333VCRegistered aircraftS/N 24-1671N334ARHouldson Consulting Inc · Morrison, ILBuilt 1977 · S/N 24-0334N335BBVantrease David A · Wills Point, TXBuilt 1983 · S/N 24-1367N335ERLandgraf Scott A · Buffalo, MNS/N 24-3162N337MCLandavazo Joseph · Albuquerque, NMBuilt 1983 · S/N 24-1385N33YZJenkins Blake T · Lakeland, FLBuilt 1978 · S/N 24-0631N340BMInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 24-0421N343DMHess Eric J · Cave Creek, AZBuilt 1996 · S/N 24-3396N34LLGwizz Financial LLC · Wausau, WIBuilt 1976 · S/N 24-0047N34PWContinental Expedited Services · Clarksville, TNBuilt 1981 · S/N 24-1203N34SAMiller Keaton · Newburgh, INBuilt 1978 · S/N 24-0428N3510HNix Terry W · Golden, MSBuilt 1980 · S/N 24-1031N3512HR & D Plane LLC · Longwood, FLBuilt 1980 · S/N 24-1032N3513HTurbett Robert E · Penfield, NYBuilt 1980 · S/N 24-1033N3526HLyons Donald F · Cheverly, MDFirst renewal noticeBuilt 1980 · S/N 24-1035N353BWHall Aviation LLC · Ithaca, NYBuilt 1994 · S/N 24-3354N3545HBurkett Aviation LLC · Boone, NCFirst renewal noticeS/N 24-1036N355DTForster George A · Port Townsend, WABuilt 1994 · S/N 24-3340N355RLRegistered aircraftBuilt 1995 · S/N 24-3373N35ELB&W Air LLC · Lincoln, NEBuilt 1990 · S/N 24-3142N365BCFisher Charles P · North Charleston, SCS/N 24-1213N365JTBe-A36 Inc Trustee · Wilmington, DEBuilt 1981 · S/N 24-1130N3687HRunia Allan D Trustee · Gold Hill, ORS/N 24-1040N369RPRegistered aircraftBuilt 1988 · S/N 24-1682N36CEHawkes Delray · Sequim, WABuilt 1982 · S/N 24-1321N3703HTsyupka Andriy · Hinsdale, ILBuilt 1979 · S/N 24-0904N3705HGeyer Donovan · Palo Cedro, CABuilt 1979 · S/N 24-0905N3706HDurand Ryan A · Hermantown, MNBuilt 1979 · S/N 24-0906N3712HSpencer James W · Valley Lee, MDBuilt 1979 · S/N 24-0909N3716HSky Deals LLC · Kearney, NEBuilt 1979 · S/N 24-0911N3742HLocurto Anthony C · Alexandria, VABuilt 1979 · S/N 24-0918N374SMN374sm LLC · Orlando, FLBuilt 1984 · S/N 24-1464N3751HSoftcomm Aviation Inc · Irvine, CABuilt 1979 · S/N 24-0923N3755HWeltman Brian G · Pasadena, CABuilt 1979 · S/N 24-0927N3766HN3766h LLC · Portland, ORBuilt 1979 · S/N 24-0934N3768HArrow Electric Contractors LLC · Kent City, MIBuilt 1979 · S/N 24-0935N3770HGrandy Boyd · Arcadia, CABuilt 1979 · S/N 24-0936N3774HRegistered aircraftBuilt 1979 · S/N 24-0938N377JFTranchina George R Jr · Lacombe, LABuilt 1992 · S/N 24-3267N377VKFoy Carol M · Spicewood, TXBuilt 1984 · S/N 24-1495N3790HEmerson David E · Sugar Land, TXBuilt 1979 · S/N 24-0940N3792HWalbright Phil · Zanesfield, OHBuilt 1979 · S/N 24-0942N3795HMartin Timothy · Queen Creek, AZBuilt 1980 · S/N 24-0943N3796HMceachern Mary Margaret · Wilmington, NCBuilt 1980 · S/N 24-0944N37GDKmsb Management LLC · Sarasota, FLBuilt 1987 · S/N 24-1619N3803HStaib Matthew · Cambridge, MABuilt 1980 · S/N 24-0945N3813HJohnson Mark A · Cypress, TXBuilt 1980 · S/N 24-1043N3827HPlane1 LLC · Lander, WYBuilt 1980 · S/N 24-0953
Back to AD 95-26-16 R1