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.

N9729UDriscoll Cindy M · Savannah, TNBuilt 1976 · S/N AA5A-0129N9730USherry-Aire LLC · Sidney, MTBuilt 1976 · S/N AA5A-0130N9731UNatale Louis H · Cedar Park, TXBuilt 1976 · S/N AA5A-0131N9734USls Aviation LLC · Poquoson, VABuilt 1976 · S/N AA5A-0134N9735UFreeman George W · Wolcottville, INBuilt 1976 · S/N AA5A-0135N9744UPilot Farm LLC · Grant, NEBuilt 1976 · S/N AA5A-0144N9747UHenrie Edwin A · Benton, KSBuilt 1976 · S/N AA5A0147N9748UQuiet Birdmen LLC · Lanoka Harbor, NJBuilt 1976 · S/N AA5A-0148N9749UBowman Jason C · Bellbrook, OHBuilt 1976 · S/N AA5A-0149N9751UCox Glenn E · Denton, NEBuilt 1976 · S/N AA5A-0151N9752UBg Aero Ltd Co · Coyle, OKBuilt 1976 · S/N AA5A-0152N9753UJ&M Aviation LLC · Atkinson, NEBuilt 1976 · S/N AA5A-0153N9757UFairchild James C · Pinson, TNS/N AA5A-0157N9760UFitzgerald John P · Pittsburgh, PABuilt 1976 · S/N AA5A-0160N9767UBrndiar John · Monticello, KYS/N AA5A-0167N976MSStaten Joseph A · Kitty Hawk, NCBuilt 1976 · S/N AA5B0353N9770UPlegge Timothy E · Granbury, TXBuilt 1976 · S/N AA5A-0170N9773UEnos Matthew · Jackson, MOBuilt 1976 · S/N AA5A0173N9776UMurphy James J · Winston Salem, NCBuilt 1976 · S/N AA5A-0176N9777UFlippo Pete · Meeker, OKBuilt 1976 · S/N AA5A-0177N9779UZauner Paul F · Hanover, MABuilt 1976 · S/N AA5A-0179N9780URichmond Airport Inc · West Kingston, RIBuilt 1976 · S/N AA5A-0180N9788UShell James W · Florence, KYS/N AA5A-0188N9790UParrish Rudolph S · Bath, MEBuilt 1976 · S/N AA5A-0190N9791UWoods Joe · Newalla, OKBuilt 1976 · S/N AA5A-0191N9793UMiyasaki Michael · Sacramento, CABuilt 1976 · S/N AA5A-0193N9794UBrown Joe T · Blevins, ARS/N AA5A-0194N9795UDargatz Marvin R · Las Vegas, NVBuilt 1976 · S/N AA5A-0195N9798UKuhagen Garth H · Courtland, CABuilt 1976 · S/N AA5A0198N9799UGoff Vernon L · Omaha, NEBuilt 1976 · S/N AA5A0199N97DVWaugh Terry R · Phoenix, AZBuilt 1977 · S/N AA5B0455N9800UHarvey Mallory · Baxley, GABuilt 1976 · S/N AA5A0200N9802UStoll John E · Summerville, SCBuilt 1976 · S/N AA5A0202N9809UPatterson Jody J · Moab, UTBuilt 1976 · S/N AA5A-0209N9810USlack Travis · Liberty Township, OHBuilt 1976 · S/N AA5A-0210N9811UHoxworth William D · Westminster, COBuilt 1976 · S/N AA5A-0211N9815UHonsinger Gary · Wesley Chapel, FLBuilt 1976 · S/N AA5A-0215N9816UCheetah Air LLC · Edinburg, NDBuilt 1976 · S/N AA5A-0216N9818UGainous David C · Port Saint Joe, FLBuilt 1976 · S/N AA5A-0218N9819UFruehwirth Kevin · Spring, TXBuilt 1976 · S/N AA5A0219N9821UCoquimbo Capital Holdings LLC · Sandy, UTBuilt 1976 · S/N AA5A0221N9822UMoyer Curtis · Bedford, INBuilt 1976 · S/N AA5A0222N9823UMorrow Robert C · Edgewater, FLBuilt 1976 · S/N AA5A0223N9824UPurpose Flight International LLC · Wilmington, DEBuilt 1976 · S/N AA5A0224N9827UFiedler William K · Greensboro, GABuilt 1976 · S/N AA5A0227N9828UAble Gary N · Houston, TXBuilt 1976 · S/N AA5A0228N9834UN9834u Owners LLC · Lakewood, COS/N AA5A0234N9840UHeusser David G · Independence, ORBuilt 1976 · S/N AA5A0240N9843UStorrud Jerrel T · Corvallis, MTS/N AA5A0243N9845UKlingberg Roger R · Cross Plains, TXBuilt 1976 · S/N AA5A0245
Back to AD 95-19-15 R1