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.

N26253Tompkins Robert G · Panacea, FLBuilt 1979 · S/N AA5A-0819N26255Wren Donald F · West Chester, OHBuilt 1977 · S/N AA5A0485N26256Yokley James E · Missouri City, TXS/N AA5A0487N26257Katz Matthew · Los Angeles, CAS/N AA5A0490N26266Laing Michael · Greenwood, INS/N AA5A0496N26268David G Mcalpin Trustee · Mishawaka, INS/N AA5A0497N26270Cochran Donald E · Gardner, KSS/N AA5A0498N26273Gasiorowski Mark A · Buford, GABuilt 1977 · S/N AA5A0500N26276Williams Adam L · Greensboro, NCS/N AA5A0501N26278Bal-Air LLC · Boca Raton, FLBuilt 1977 · S/N AA5A0502N26280Myles Keith H · Bolton, MAS/N AA5A0503N26282Hubbard John D · Gardner, KSS/N AA5A0504N26292Qualitair LLC Trustee · MichelstadtBuilt 1977 · S/N AA5A0508N26294Dennen Corey M · Troup, TXS/N AA5A0509N26297Hunter Danny L · Gulfport, MSBuilt 1977 · S/N AA5A0510N26298Champaign Sharon E · New Holstein, WIBuilt 1977 · S/N AA5A0511N26299Ferraris Robert · Tinton Falls, NJBuilt 1977 · S/N AA5A0512N26300Boyer Steven L · Wooster, OHBuilt 1977 · S/N AA5A0513N26304Cobra Kai Inc · Wichita Falls, TXBuilt 1977 · S/N AA5A0522N26308Registered aircraftBuilt 1977 · S/N AA5A0489N26314Allen James R · Glasgow, KYBuilt 1978 · S/N AA5A0529N26323Peachtree Builders LLC · Waterford, NYS/N AA5A0534N26330Davis Timothy Scott · Lexington Park, MDBuilt 1978 · S/N AA5A0536N26334Mullins Donald · Pounding Mill, VAS/N AA5A0537N26337Munson Andreas C · Seattle, WABuilt 1978 · S/N AA5A0538N26349Bonnell Corey K · Waxahachie, TXBuilt 1978 · S/N AA5A0540N26353Scoggin Gerald W III · Port Saint Lucie, FLS/N AA5A0541N26360Stickney John M · Chapin, SCBuilt 1978 · S/N AA5A0543N26368Parker Dennis A · Charlevoix, MIBuilt 1978 · S/N AA5A0544N26380Downey Matthew R · Colorado Springs, COBuilt 1977 · S/N AA5A0404N26384Farley Robert W · Warwick, MABuilt 1978 · S/N AA5A0553N26387Masco Howard N · Huntsville, ALBuilt 1978 · S/N AA5A0555N26389Wilson Billy Joe · Granite Falls, NCBuilt 1978 · S/N AA5A0556N26390Rucker Roger D · Pembroke Pines, FLBuilt 1978 · S/N AA5A0557N26396Vergona John T · Canton, MIBuilt 1978 · S/N AA5A0561N26398Fenton David W · Kihei, HIBuilt 1978 · S/N AA5A0562N26401Mann James R · Waikoloa, HIBuilt 1978 · S/N AA5A0565N26406Registration Pending · Valdosta, GARegistration pendingBuilt 1978 · S/N AA5A0568N26407Colvin Daniel A · Dayton, TNBuilt 1978 · S/N AA5A0569N26410Villanueva Francisco B · Leavenworth, KSBuilt 1978 · S/N AA5A0570N26411Cheetah LLC · Burlington, IABuilt 1978 · S/N AA5A0571N26412Pelican Fisheries Corp · Mount Pleasant, SCBuilt 1977 · S/N AA5A0493N26414Ambrose Douglas · Indio, CABuilt 1978 · S/N AA5A0578N26415Khano Maurice S · Kennesaw, GABuilt 1978 · S/N AA5A0579N26422Cressey Aaron · Silverton, ORBuilt 1978 · S/N AA5A0582N26423Poulnott William · Milledgeville, GABuilt 1978 · S/N AA5A0583N26424Ormanian Austin · Canton, MIBuilt 1978 · S/N AA5A0584N26427She Runs I Fly LLC · Cincinnati, OHBuilt 1978 · S/N AA5A0585N26440Nester Christopher J · Mount Washington, KYBuilt 1978 · S/N AA5A0591N26450Km Aero Inc · Kalispell, MTBuilt 1978 · S/N AA5A0596
Back to AD 95-19-15 R1