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.

N28677Allen Michael P · Glasgow, KYS/N AA5B0748N28678Rubino Daniel A · Marion, KYBuilt 1977 · S/N AA5B0679N28682Mcclure Glenn E · Convoy, OHBuilt 1978 · S/N AA5B0754N28683Siry Steven · Santa Barbara, CABuilt 1978 · S/N AA5B0755N28684Loveless Anesthesia Pllc · Conway, ARS/N AA5B0756N28688Jennings Jared Alan · Tacoma, WABuilt 1978 · S/N AA5B0757N28692Heidi'S House LLC · Woodstock, GABuilt 1978 · S/N AA5B0759N28696Clark Brian David · Cumming, GAS/N AA5B0761N28697Saddler Harry · Berkeley, CABuilt 1978 · S/N AA5B0762N28699Mizner Michael D · Richfield, UTS/N AA5B0764N286GRGinal Ronald T DBA · Essex Junction, VTBuilt 1978 · S/N AA5B0763N28703Barney Diane J · Mojave, CABuilt 1978 · S/N AA5B0765N28705S & M Aviation Inc · Barefoot Beach, FLBuilt 1978 · S/N AA5B0766N28712Raduns Deirdre Eychner · Kearneysville, WVBuilt 1978 · S/N AA5B0769N28719Keleher Daniel Bradley · Orion, ILBuilt 1978 · S/N AA5B0773N28720Souther Van S · Northville, MIBuilt 1978 · S/N AA5B0774N28722Meyer Scott David · Plano, TXBuilt 1978 · S/N AA5B0775N28732Oreilly Michael · Lemont, ILBuilt 1978 · S/N AA5B0782N28733Halkenhauser Douglas G · Denville, NJBuilt 1978 · S/N AA5B0783N28739Velednitsky Boris · Bridgewater, NJBuilt 1978 · S/N AA5B0785N28740Fliegend Corp · Indianapolis, INBuilt 1978 · S/N AA5B0786N28742Registered aircraftBuilt 1978 · S/N AA5B0787N28743Kamer Norman M · Newark, CABuilt 1978 · S/N AA5B0788N28745Ferraro Jeffrey T · Mckinney, TXBuilt 1978 · S/N AA5B0789N28747Vogt Gary L · Auburn, CABuilt 1978 · S/N AA5B0790N28749Struve Gregory P · Eagan, MNBuilt 1978 · S/N AA5B0791N28752Wood Bennett A · Sugar Land, TXS/N AA5B0792N28758Halstrick Richard W · Newtown, PABuilt 1978 · S/N AA5B0794N28760Davis Jeffrey B · Overgaard, AZBuilt 1978 · S/N AA5B0795N28763Suter Steven A · Santa Rosa, CABuilt 1978 · S/N AA5B0796N28765Hart Lewis W DBA · Rexburg, IDBuilt 1978 · S/N AA5B0798N28768Registered aircraftBuilt 1978 · S/N AA5B0799N28769Cook Jeff E · Woodway, TXBuilt 1978 · S/N AA5B0800N28770Stieber Chris D · Aurora, COBuilt 1978 · S/N AA5B0704N28771Markham Gregory T · Bedford, VABuilt 1978 · S/N AA5B0678N28777N28777 Partnership G.P. · Charlotte, NCBuilt 1978 · S/N AA5B0808N28778Frank David T Trustee · San Diego, CAS/N AA5B0809N28779Fowler Greg · Freeport, FLBuilt 1978 · S/N AA5B0810N28780Lewis Scott C · Los Angeles, CABuilt 1978 · S/N AA5B0811N28786Taylor Peter M · Hollywood, FLBuilt 1978 · S/N AA5B0814N28787White Richard Y · Raleigh, NCBuilt 1978 · S/N AA5B0815N28791Gulfstream Aerospace Corp · Savannah, GABuilt 1978 · S/N AA5B0817N28792Ryan David Patrick · Dripping Springs, TXBuilt 1978 · S/N AA5B0818N28794Barnes Gregory R · Waco, TXBuilt 1978 · S/N AA5B0819N28797Pacific Crest Ventures LLC · San Francisco, CABuilt 1978 · S/N AA5B0820N28800El Tigre Aviation LLC · Brookfield, WIS/N AA5B0821N28803Candeletti James J · Forked River, NJBuilt 1978 · S/N AA5B0823N28806Creisler Vincent L · Kent, WABuilt 1978 · S/N AA5B0825N28807Haight Donald E · Trumbull, CTBuilt 1978 · S/N AA5B0826N28809Cox Terry J Trustee · Missouri City, TXBuilt 1978 · S/N AA5B0833
Back to AD 95-19-15 R1