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.

N1972GCapone Eugene L DBA · Frisco, TXBuilt 1972 · S/N AA5-0157N1973THogs & Hoses LLC · Seguin, TXBuilt 1972 · S/N AA5-0233N1976TSickels Charles Joseph · San Diego, CAS/N AA5B0323N1979GBerardo Frederick Andrew · Redmond, ORBuilt 1978 · S/N AA5B1041N199CBSmisek James W · Frankston, TXBuilt 1976 · S/N AA5A0226N19BFKerkering Kenneth J · Colleyville, TXBuilt 1975 · S/N AA5B-0106N19TMSnider Tim · Stony Creek, CTBuilt 1977 · S/N AA5A0335N1SXMuehl Harvey C · Macomb, MIBuilt 1976 · S/N AA5B0387N2000HMartinez Edgar · Houston, TXBuilt 1974 · S/N AA5-0625N200BDEason Charles E · Locust Grove, GABuilt 1972 · S/N AA5-0159N200FWNextwerk Inc · Carlsbad, CABuilt 1975 · S/N AA5B-0194N202DGGolovko Daniel M · East Falmouth, MABuilt 1972 · S/N 0083N202ECRegistered aircraftS/N AA5B-0035N20367383 Park Street A LLC · Dracut, MAS/N AA5B-0161N203JASmith Kevin A · Eagle, IDS/N AA5A-0474N2072XBraude Bradford H · Independence, OHS/N AA5B-1101N207RDSpry Brent A · Madison, INBuilt 1977 · S/N AA5A0449N20NASchneider Adam R · Hutchinson, KSBuilt 1977 · S/N AA5B-0560N210JAThroneburg Jason J · Lecanto, FLBuilt 1979 · S/N AA5A-0882N211JKNelson Christopher B · Fort Atkinson, WIBuilt 1972 · S/N AA5-0049N2121TSiebols Johan · Friendswood, TXS/N AA5B-1031N2145FSmith Jeffrey D · Hamilton, GABuilt 1972 · S/N AA5-0017N215ERAmerican Capacitor Corp · Irwindale, CABuilt 1992 · S/N 10117N21GWBing Kenneth · Millersport, OHBuilt 1972 · S/N AA5-048N21HKSims Nathaniel Merriman · Boston, MABuilt 1976 · S/N AA5A-0257N2203RHubin Scott E · Kent, OHBuilt 1975 · S/N AA5B-0071N221EWRowe Bradley Markus · Boca Raton, FLBuilt 1978 · S/N AA5B0885N221PJHinton Cody J Trustee · Indian Land, SCBuilt 1977 · S/N AA5A0473N222WCTroy Thaxton · San Diego, CAS/N AA5B-0478N225BCMontague Ronnie L · French Camp, MSBuilt 1977 · S/N AA5B0464N2269LLarrison Bryan J · Dublin, OHBuilt 1972 · S/N AA5-0156N228ERRoscioli Lamberto · Lighthouse Point, FLBuilt 1992 · S/N 10119N229ERGood Winds Aero LLC · Roseburg, ORS/N 10125N22BAKovalchuk Richard W · Rosharon, TXBuilt 1976 · S/N AA5A0238N22JTThompson Joseph Trustee · Adams, MAS/N AA5B1198N22RLFrewen Maclain S · Saint Francis, KSBuilt 1979 · S/N AA5A0856N22SVFlying Colors Airparts Inc · Leesburg, FLBuilt 1974 · S/N AA5-0630N232CPMach 182 LLC · Port Orange, FLBuilt 1976 · S/N AA5B-0129N2332TFinch Stanley F · San Marcos, TXBuilt 1978 · S/N AA5B0934N234ARHague Arsh · Orangeburg, NYBuilt 1977 · S/N AA5B0452N23JKDay William Bruce · Roach, MOBuilt 1975 · S/N AA5B-0022N241ERN241er LLC · Charlotte, NCBuilt 1992 · S/N 10120N241TTTherrell G Tony · Kannapolis, NCBuilt 1979 · S/N AA5B1113N242BWLasensky David W · Newtown Square, PAS/N 10214N242HSpruce Creek Tiger LLC · Port Orange, FLBuilt 1977 · S/N AA5B0514N244ERKeith Bryan P · Los Angeles, CABuilt 1992 · S/N 10123N244STAskew Stell B III · Durham, NCBuilt 1976 · S/N AA5A-0138N246PMBesprozvanny Randy-Alexander R · San Marcos, CABuilt 1977 · S/N AA5B-0566N247UTRegistration Pending · Xxx, OKRegistration pendingBuilt 1978 · S/N AA5B0824N249RRChrest Harry David Jr · Charleston, WVS/N AA5B-0497
Back to AD 95-19-15 R1