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.

N56BVEuroaviation Inc Trustee · KematenBuilt 1978 · S/N AA5A0719N56ERGsell Bruce Ward · Southampton, NJBuilt 1979 · S/N AA5B-1094N56GTDonaldson Timothy A · Oklahoma City, OKBuilt 1976 · S/N AA5B-0344N56SCHighley Robert W III · Aldie, VABuilt 1975 · S/N AA5-0754N575JKKiffe Keaton T · Columbia, MOBuilt 1991 · S/N 10030N5798LLymburner Lawrence E · Lehigh Acres, FLBuilt 1972 · S/N AA5-0207N57ERBlake David A · Bremerton, WABuilt 1979 · S/N AA5B1253N5802LHarrold Michael C · Hamilton, MTBuilt 1971 · S/N AA5-0002N5804LAa Horizons LLC · League City, TXBuilt 1971 · S/N AA5-0004N5806LSutphin Christoper F · Darlington, SCS/N AA5-0006N5808LChristensen Donald R · Anchorage, AKBuilt 1971 · S/N AA5-0008N5809LNealy William · Heath, TXS/N AA5-0216N5812LLindly Lowell J · Nashville, ARBuilt 1971 · S/N AA5-0012N5815LFidler Richard · San Francisco, CABuilt 1972 · S/N AA5-015N5816LSparrowhawk Aviation LLC · Moraine, OHFirst renewal noticeBuilt 1972 · S/N AA5-0016N5819LLandauer Jacob · Gainesville, FLBuilt 1972 · S/N AA5-0219N5825LMahurin Devin · Mountain Grove, MOBuilt 1972 · S/N AA5-0025N5826LGibson Bobby S · Clearwater, FLBuilt 1972 · S/N AA5-0026N5831LCooks Aviation LLC · Conover, NCBuilt 1972 · S/N AA5-0231N5832LPlesea Lucian · Redlands, CABuilt 1972 · S/N AA5-0232N5832RMcmanus James D · Gilbert, AZBuilt 1978 · S/N AA5B-0778N5834LFount Valley Flying Club LLC · Kidron, OHS/N AA5-0034N5837LDudock John M Jr · Birch Run, MIBuilt 1972 · S/N AA5-0037N5838LCox Andrew C · Scappoose, ORBuilt 1972 · S/N AA5-0038N5839LHoyer Chase R · Jarrell, TXBuilt 1972 · S/N AA5-0039N5842LBerner Walter T III · Stamford, CTBuilt 1972 · S/N AA5-0042N5843LMaschek Scott · Harker Heights, TXBuilt 1972 · S/N AA5-0043N5844LHennell Elizabeth · Orrville, OHBuilt 1972 · S/N AA5-0044N5845LKunkel Dennis J Co Trustee · Clearwater, MNBuilt 1972 · S/N AA5-0045N5848LN5848l LLC · San Francisco, CABuilt 1972 · S/N AA5-0248N584LLawver William A · Panama City, FLBuilt 1972 · S/N AA5-0084N5850LXeus Inc · Nottingham, PABuilt 1972 · S/N AA5-0050N5851LOretsky Philip H · South Haven, MIBuilt 1972 · S/N AA5-0051N5852LOhser David G · Hudson, FLBuilt 1972 · S/N AA5-0052N5853LKennedy Samuel E · Watsonville, CABuilt 1972 · S/N AA5-0053N5854LVolpe Brandon M · Baton Rouge, LABuilt 1972 · S/N AA5-0254N5855LSchauf Cindy R · Colwich, KSBuilt 1972 · S/N AA5-0055N5856LOrland Flying Service Inc · Bunnell, FLBuilt 1972 · S/N AA5-0056N5857LHill James III · Gainesville, FLBuilt 1972 · S/N AA5-0057N585PTWest Texas Aircraft LLC · Fort Worth, TXBuilt 1976 · S/N AA5B-0375N585WSPrysock Fred S · Ellisville, MSBuilt 1978 · S/N AA5A0539N5860LBeede Curtis M Trustee · Maineville, OHBuilt 1972 · S/N AA5-0060N5862LAnderson Terry L · Lincoln, NES/N AA5-0062N5865LMontez Santiago S · Mesa, AZBuilt 1972 · S/N AA5-0065N5866LRickman Loy D · Sunrise Beach, MOBuilt 1972 · S/N AA5-0066N5867LLytle David C · Portage, WIS/N AA5-0067N5868LEngineering Forensics Inc · Glen Burnie, MDS/N AA5-0068N5871LSleeper James A · Middleburg, FLBuilt 1972 · S/N AA5-0071N5872LMai David A · Chattanooga, TNBuilt 1972 · S/N AA5-0072N5876LWilson James · Bagwell, TXS/N AA5-0276
Back to AD 95-19-15 R1