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.

N961TETiger Fliers LLC · Island Park, NYBuilt 2004 · S/N 10240N9623UBare Michael J · Paola, KSBuilt 1975 · S/N AA5-0823N9628UEvans Luis M · Locust Grove, GAS/N AA50828N962TEPayne Mark Howard · Spring, TXBuilt 2004 · S/N 10241N9630UWright Brent C · Boulder Creek, CAS/N AA5-0830N9631UCross Scott · Scott Township, PABuilt 1975 · S/N AA5-0831N9635UCarmichael Donald L · Carlisle, INBuilt 1975 · S/N AA5A-0001N9636LWest Main Auto Sales Inc · Tupelo, MSBuilt 1974 · S/N AA5-0636N9636USchroeder Wolf Udo · Rochester, NYBuilt 1975 · S/N AA5A-0002N9639UAslaksen Jay P · Richmond, TXBuilt 1975 · S/N AA5A-0005N9641UHunt David C · Middlebury, CTBuilt 1975 · S/N AA5A-0007N9647UWilhite Randall D · Plainville, MABuilt 1975 · S/N AA5A-0013N964TEBedard Robert L · Bolivar, OHBuilt 2005 · S/N 10243N9652UFry Anthony J · Rocky River, OHBuilt 1975 · S/N AA5A-0018N9653USteffen Todd M · Wind Lake, WIBuilt 1975 · S/N AA5A-0019N9654URealty Investment Co Ltd · Hilo, HIBuilt 1975 · S/N AA5A-0020N9656ULanglois Zachary J · Deerfield, NHBuilt 1975 · S/N AA5A-0022N9657ULetourneau University · Longview, TXS/N AA5A-0023N9658URegistration Pending · Spencer, NERegistration pendingBuilt 1975 · S/N AA5A-0024N9659LMoffatt Thomas · Dallas, GABuilt 1974 · S/N AA5-0659N9662UT & J Services Inc · Wilmington, DEBuilt 1975 · S/N AA5A-0028N9663UMaxfield Ronald · Mechanicsville, VABuilt 1975 · S/N AA5A-0029N9664UBoan Timothy C · Berryville, VABuilt 1975 · S/N AA5A-0030N9665UDurning Robert · Riddle, ORBuilt 1975 · S/N AA5A-0031N9668ULewis Leno B · Richlands, NCBuilt 1975 · S/N AA5A-0034N966TELewis Everett Donald Jr · Comfort, TXBuilt 2005 · S/N 10245N9670USchrader Edmon A · Benton, KSBuilt 1975 · S/N AA5A-0036N9671UGuy Jeffrey · Centerburg, OHS/N AA5A-0037N9672UKelley Christopher M · Gilbert, SCBuilt 1975 · S/N AA5A-0038N9676URedwood Aircraft LLC · Santa Rosa, CABuilt 1975 · S/N AA5A-0042N9677UPierce Jeff · Henrietta, TXBuilt 1975 · S/N AA5A-0043N9679UThorn Eric Miller · Arlington, VABuilt 1975 · S/N AA5A-0045N9683UNorris Tracy N · Channelview, TXBuilt 1975 · S/N AA5A-0049N9685UCochran Brad · Humboldt, TNBuilt 1975 · S/N AA5A-0051N9687UHelms Jacob · New River, AZBuilt 1975 · S/N AA5A-0053N9689UHappy Landings LLC · Edmond, OKBuilt 1976 · S/N AA5A-0055N9690ULearjetjohn Flying Club LLC · Athens, ALBuilt 1975 · S/N AA5A-0056N969SHDominguez Philip · Brooklyn, NYBuilt 1977 · S/N AA5B-0418N9701UStearns Edwin B Jr · Eloy, AZS/N AA5A-0101N9702ULyons William S IV · Castle Rock, COBuilt 1976 · S/N AA5A-0102N9712UUnruh Ronald E · Pampa, TXBuilt 1976 · S/N AA5A-0112N9713URoderick Richard · Farmington, NMBuilt 1976 · S/N AA5A-0113N9714UWeyers Gregory J · Lakewood, WIBuilt 1976 · S/N AA5A-0114N9717UBas Part Sales LLC · Greeley, COBuilt 1976 · S/N AA5A-0117N9718UStacey Dave · Vancouver, WABuilt 1976 · S/N AA5A-0118N9719UButler Jon M · Berrien Springs, MIBuilt 1976 · S/N AA5A-0119N9721UWood Lisa L · Wrightsville, PABuilt 1976 · S/N AA5A-0121N9725UHubbard George E · Philadelphia, PABuilt 1976 · S/N AA5A-0125N9727UGarvin David M · Seymour, TNS/N AA5A-0127N9728UGrrumman LLC · Salem, ORBuilt 1976 · S/N AA5A-0128
Back to AD 95-19-15 R1