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.

N37WHNorthrop Grumman Systems Corp · El Segundo, CABuilt 1994 · S/N 1243N3801RFial Ronald A · Milwaukie, ORBuilt 1980 · S/N WA-191N38024Hancock Aviation LLC · Baton Rouge, LABuilt 1980 · S/N WA-197N38025Missaukee Aircraft Leasing LLC · Cadillac, MIBuilt 1980 · S/N WA-198N38026Terra Scott M · Vacaville, CABuilt 1980 · S/N WA-202N3803ESorbi Aviation Inc · El Cajon, CABuilt 1981 · S/N ME-381N38054Burr William L Jr · Johns Creek, GAFirst renewal noticeBuilt 1980 · S/N WA-201N38062Marquez Naoko Quena · Henderson, NVBuilt 1980 · S/N WA-204N3807KFaucette Micro Systems Inc · Fallon, NVS/N WA-200N38086Autumn Crocus LLC · Cincinnati, OHS/N WA-210N38088Toledo Jorge A · Coral Gables, FLS/N TC-2366N3809UMartus Michael · Russellville, OHBuilt 1980 · S/N WA-211N3809YShaffer Kent R · Sour Lake, TXFirst renewal noticeBuilt 1980 · S/N WA-212N3809ZHelm Charles M · Darlington, WIBuilt 1980 · S/N WA-213N380ACUmb Bank Na Trustee · Salt Lake City, UTS/N 3383N380DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8915N380UPCc&E I LLC · Louisville, KYBuilt 2023 · S/N 67969N3811XBaron 55 LLC · Hanover, NHBuilt 1981 · S/N TC-2368N3812CChristiansen Aviation LLC · Wilmington, DES/N ME-390N3812QN3812q LLC · San Diego, CABuilt 1981 · S/N WA-214N3812UBasquit Kenneth H · Pittsburgh, PABuilt 1980 · S/N WA-215N38166S&P Airplane Sales · Branson West, MOBuilt 1981 · S/N TC-2371N3818ZRigney Mark E · Ponca City, OKBuilt 1981 · S/N WA-225N38198Zero Mike LLC · Chattanooga, TNBuilt 1981 · S/N TC-2387N381DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8859N381FLIfl Group Inc · Waterford, MIBuilt 1953 · S/N 276N381UPC C & E I LLC · Louisville, KYBuilt 2023 · S/N 67970N3820MIsrael Howard A · Santa Monica, CABuilt 1981 · S/N TC-2372N3828XAmerican Flightscope Inc · Wilmington, DEBuilt 1981 · S/N TC-2374N382DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8854N382SHernandez Luis A · Longview, TXBuilt 1966 · S/N TE-166N382UPC C & E I LLC · Louisville, KYBuilt 2023 · S/N 67971N383Martis Valley Aviation LLC · Redwood City, CABuilt 1981 · S/N ME-388N38384Baisden James Brett · Manassas, VABuilt 1981 · S/N WA-231N38397Registered aircraftS/N WA-232N3839LFlight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N ME-397N383DJGiv Investors LLC · Olean, NYBuilt 2000 · S/N 1383N383DZDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8916N383RLRescue 383 LLC · Annapolis, MDBuilt 1999 · S/N UE-383N383UPCc & Ei LLC · Louisville, KYBuilt 2023 · S/N 67972N3845LDonq LLC · Hartford, CTBuilt 1981 · S/N TC-2378N38462Krystofiak Steven · Scottsdale, AZBuilt 1981 · S/N WA-244N3846UKrystofiak Steven · Scottsdale, AZS/N WA-242N384BLynden Aero Inc · Lynden, WABuilt 1959 · S/N TD-191N384DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8974N384UPC C & E I LLC · Louisville, KYBuilt 2024 · S/N 67973N3850GN3850g LLC · Stamford, CTBuilt 1976 · S/N 340A0208N3851ZPurcell Jmes Patrick III · Bayville, NJBuilt 1981 · S/N WA-241N38537Optimumedicine LLC · Las Vegas, NVBuilt 1985 · S/N UE-158N38570Dm Asset Management LLC · Plain City, OHBuilt 1981 · S/N TC-2381
Back to AD 95-26-15 R1