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.

N9846UFerrell Joseph R Jr · Christiansburg, VABuilt 1976 · S/N AA5A0246N9848UHenley Jimmy · Linden, NCBuilt 1976 · S/N AA5A0248N9849UStaples L E · Granbury, TXBuilt 1976 · S/N AA5A0249N9850UHagan Kenton Lee · Fayetteville, ARS/N AA5A0250N9851UPaul Brian K · San Angelo, TXBuilt 1976 · S/N AA5A0251N9852UWilkening Robert E · Mesa, AZBuilt 1976 · S/N AA5A0252N9853USherwin Robert A · Redondo Beach, CABuilt 1976 · S/N AA5A0253N9854UPatterson James B · Euless, TXBuilt 1976 · S/N AA5A0254N9855UGlennon John J · Holland, MABuilt 1976 · S/N AA5A0265N9856UBuell Scott T · Floral City, FLBuilt 1976 · S/N AA5A0256N9861UWalther Joseph A · Aledo, TXBuilt 1976 · S/N AA5A0261N9863UHedin John A · Charlotte, NCBuilt 1976 · S/N AA5A0263N9864USiegrist Dean P · Tarpon Springs, FLBuilt 1976 · S/N AA5A0264N9868UMcgrail Ryan N · Blair, NES/N AA5A0268N9869UJtg Aviation LLC · Las Vegas, NVBuilt 1976 · S/N AA5A0269N9870UStanton Jerry J · Sunrise Beach, TXBuilt 1976 · S/N AA5A0270N9873UCheetah Flyers LLC · Huntersville, NCS/N AA5A0273N9877UNaval John A · Auburn, WABuilt 1976 · S/N AA5A0277N9878URock N Roll Flying Club LLC · Omaha, NEBuilt 1976 · S/N AA5A0278N9880USeay Herbert C · Port Saint Joe, FLBuilt 1976 · S/N AA5A0280N9881UChristensen Myra J Storms · Pierre, SDBuilt 1976 · S/N AA5A0281N9882UNordbye Newell · Eden Prairie, MNBuilt 1976 · S/N AA5A0282N9885USchneider Fred M Jr · Fishkill, NYBuilt 1977 · S/N AA5A0285N9891UQuattlebaum Taylor · Vilas, NCS/N AA5A0291N9892USeymour Robert L Jr · Ada, OHS/N AA5A0292N9893UImproving Lives Counseling Services Inc · Tulsa, OKBuilt 1976 · S/N AA5A0293N9896UAmaya Ricardo · Shelby, NCBuilt 1977 · S/N AA5A0296N9897UBellenoit David M · Douglas, MAS/N AA5A0297N9898UOlenick Christopher M · New Richmond, OHBuilt 1977 · S/N AA5A0298N9899UStott Rick T · Bynum, MTBuilt 1977 · S/N AA5A0299N98DGGoins Donald L · Marion, OHBuilt 1979 · S/N AA5B1058N9900UMeyer Mark · Scotts Valley, CABuilt 1977 · S/N AA5A0400N9906UBerger Stanley F · Saint Paul, MNBuilt 1977 · S/N AA5A0306N9908UVajdak Ronnie · Wallingford, CTBuilt 1977 · S/N AA5A0308N9909UDibble Robb A · Kirkland, WABuilt 1977 · S/N AA5A0309N9910USky West Aviation Inc Trustee · Albuquerque, NMS/N AA5A0310N9911USandlapper Venutures Inc · Walhalla, SCBuilt 1977 · S/N AA5A0311N9913UThomason David F · Poplar Grove, ILBuilt 1977 · S/N AA5A0313N9914UBroderick James Edward · Baltimore, MDBuilt 1977 · S/N AA5A0314N9915UBest Oren · Sunfield, MIBuilt 1977 · S/N AA5A0315N9918USpencer Robert E · Independence, ORBuilt 1977 · S/N AA5A0318N9919UFuller Michael D · Columbia, MDBuilt 1977 · S/N AA5A0319N9920LLarson Kris Kendrick · Fullerton, CAS/N AA5-0670N9920UQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N AA5A0320N9921UKing Dennis D · Venice, FLBuilt 1977 · S/N AA5A0321N9927USpotts James J · Henderson, NVBuilt 1977 · S/N AA5A0327N9928ULarson John B · Bloomington, MNBuilt 1977 · S/N AA5A0328N9930UCoffield Grant E · Mars, PABuilt 1977 · S/N AA5A0330N9931ULett John S · Elk Grove, CABuilt 1977 · S/N AA5A0331N9933UMullins Russell H · Lagrange, GAS/N AA5A0333
Back to AD 95-19-15 R1