OpenAirDocs.org
AD 95-19-15 R1

Registered aircraft · 1,889

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

N716ERFly With Bruno LLC · Mountainside, NJBuilt 1978 · S/N AA5B0867N716RELeo Ilana · Wellington, FLS/N AA5-B0804N7177LSale Reported · Punta Gorda, FLSale reportedBuilt 1974 · S/N AA5-0677N7178LRi Flying Club Inc · Fullerton, CABuilt 1974 · S/N AA5-0678N717FTMurtha Ronald A Jr · Sycamore, ILBuilt 1979 · S/N AA5A0876N7180LOsp Leroy B · Thief River Falls, MNS/N AA5-0680N7181LNaughty Air LLC · Sheridan, WYBuilt 1973 · S/N AA5-0481N7182LHenderson Arthur F · Dallas, GABuilt 1973 · S/N AA5-0482N7184LJames Danny F · Granbury, TXBuilt 1973 · S/N AA5-0484N7186LHows Grandma LLC · South Daytona, FLBuilt 1973 · S/N AA5-0486N7188LLopez Geo U · Round Rock, TXBuilt 1973 · S/N AA5-0488N7189LNotov Aleksandr · Broomfield, COBuilt 1973 · S/N AA5-0489N7190LYoung Anthony G · Murray, KYBuilt 1973 · S/N AA5-0490N7192LCheek Donald · Ocala, FLBuilt 1973 · S/N AA5-0492N7193LLevison Louis · Klamath Falls, ORBuilt 1974 · S/N AA5-0693N7196LDodson International Parts Inc · Rantoul, KSBuilt 1973 · S/N AA5-0496N7197LMorris Gary M · Lucedale, MSBuilt 1974 · S/N AA5-0697N71FPArndt James R Jr · Round Rock, TXBuilt 1978 · S/N AA5A0643N7200LWorley Matthew · Cordova, TNBuilt 1974 · S/N AA5-0500N721JFTiger Moon LLC · Portland, ORBuilt 1978 · S/N AA5B0807N721ZMKoenig Michal · Encinitas, CABuilt 1976 · S/N AA5B-0241N725DBMang Joseph K · West Des Moines, IABuilt 1976 · S/N AA5A-0126N727TMModesto Vapor Trails · Modesto, CABuilt 1979 · S/N AA5B1178N7284LGriffin Alvin G · Mechanicsville, MDBuilt 1972 · S/N AA5-0284N7285LMurrell David Tyler · Pensacola, FLBuilt 1972 · S/N AA5-0285N7286LCover George A · Thayer, MOBuilt 1972 · S/N AA5-0286N7289LMott Calvin L · Rolla, MOBuilt 1972 · S/N AA5-0289N7293LHeilade204 LLC · Jupiter, FLBuilt 1972 · S/N AA5-0293N7294LHampshire Kimberly S · Piqua, OHBuilt 1973 · S/N AA5-0294N7297LFehr Jacob · Grand Forks, NDBuilt 1973 · S/N AA5-0297N72LMCoonan Paul M · Huntsville, MOS/N AA5-0217N72TGuazzerotti Fred · Mooresville, NCBuilt 1979 · S/N AA5B1086N7300LBarlow Tyrone J · St George, UTBuilt 1972 · S/N AA5-0230N731PKC & M Properties LLC · Chesterton, INS/N AA5B0670N7351LTaigen Robert L Jr · Queen Creek, AZBuilt 1972 · S/N AA5-0251N7366LBoles Quincy · Panama City, FLBuilt 1972 · S/N AA5-0266N7367LRegistered aircraftBuilt 1972 · S/N AA5-0267N7368LBohman John T · Monona, WIBuilt 1972 · S/N AA5-0268N7369LMcdonnel Jack E Jr · Woodsboro, TXBuilt 1972 · S/N AA5-0269N7371LMcewen Michael Trustee · Overgaard, AZBuilt 1972 · S/N AA5-0210N739PTollini Ryan D · Perkasie, PABuilt 1976 · S/N AA5B-0365N73FTBerecz Kevin · Parrish, FLBuilt 1978 · S/N AA5A-0662N74024Milner Stephen L · Dallas, TXBuilt 1975 · S/N AA5B-0101N74026Coburn William E · Carrollton, VABuilt 1975 · S/N AA5B-0103N74027Harvey James R · Ocala, FLBuilt 1975 · S/N AA5B-0104N74051Plane Fun LLC · Valdosta, GAS/N AA5B-0109N74052Macdonald Mark A · Muskego, WIBuilt 1975 · S/N AA5B-0110N74057Madden Patrick · Fort Lauderdale, FLBuilt 1975 · S/N AA5B-0112N74058Ricci Anthony Albert · Bishop, GABuilt 1975 · S/N AA5B-0115N74079Marques David A · Gilbert, AZBuilt 1975 · S/N AA5B-0120
Back to AD 95-19-15 R1