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.

N5877LFlyboys Aviation LLC · Sioux City, IABuilt 1972 · S/N AA5-0077N5878LGomez Blanco Rafael · Lakewood, CABuilt 1972 · S/N AA5-0078N5879LN5879l LLC · Lewes, DEBuilt 1972 · S/N AA5-0229N5882LBreazeale Peter · Orangeburg, SCBuilt 1972 · S/N AA5-0082N5883LOst Kenneth Alan · Langhorne, PABuilt 1972 · S/N AA5-0088N5889L100 Rads Corporation · Omaha, NES/N AA5-0089N5890LSturgeon Kenneth V · Winter Garden, FLBuilt 1972 · S/N AA5-0240N5891LAlldridge Thomas H · Cochranville, PABuilt 1972 · S/N AA5-0091N5893LHegwood Jonathan E · Petal, MSBuilt 1972 · S/N AA5-0093N5894LTrueblood Terry L · Effingham, ILBuilt 1972 · S/N AA5-0094N5895LWatkins Marion D · Mcdonough, GABuilt 1972 · S/N AA5-0095N5897LCulver Christopher J · Rockmart, GABuilt 1972 · S/N AA5-0097N5898LLamer Benjamin W · Ada, MIBuilt 1972 · S/N AA5-0098N591JPReed Douglas W · Kingwood, TXBuilt 1976 · S/N AA5B0361N5965LRegistered aircraftBuilt 1972 · S/N AA5-0255N599JRuleman Daniel T · Arlington, TNBuilt 1978 · S/N AA5B0740N59GTMarianas Mission Aviation Inc · Tamuning, GUBuilt 1975 · S/N AA5B-0028N59WMHudson River Wings LLC · Montclair, NJBuilt 1991 · S/N 10037N5TUMorse Stuart G · Port Orange, FLS/N AA5B0501N5VYFeatherstone Tony W · Denton, TXBuilt 1973 · S/N AA5-0462N5XWLewis Everett D · Comfort, TXBuilt 2004 · S/N 10242N6010LBergstrom Robert L · Amelia, VABuilt 1972 · S/N AA5-0110N6011LBiondich Amy Sue · Rubicon, WIBuilt 1972 · S/N AA5-0111N6012LCloudkicker Lc · Sioux Falls, SDBuilt 1972 · S/N AA5-0112N6013LCraven Jeremy A · Winter Garden, FLBuilt 1972 · S/N AA5-0113N6015LWade Rolla R · Kingsport, TNBuilt 1972 · S/N AA5-0115N6019LSparrow Hawk Aviation LLC · Moraine, OHBuilt 1972 · S/N AA5-0119N6020LJenkins David B · Hemet, CABuilt 1972 · S/N AA5-0120N6023LLysogorski Edward P · Bridgeport, MIS/N AA5-0123N6026LDolan Kathleen M · Sunnyside, WABuilt 1972 · S/N AA5-0126N6033LEberhardy Mark J · Greenville, WIS/N AA5-0133N6034LSunflower Sport Aviation LLC · Fort Leavenworth, KSFirst renewal noticeBuilt 1972 · S/N AA5-0134N6037LRaphael Craigen Michael · Point, TXBuilt 1972 · S/N AA5-0137N6039LMilovich Edwin G · Lebanon, PABuilt 1972 · S/N AA5-0139N6040LPopio John A · Marysville, OHBuilt 1972 · S/N AA5-0140N6041LAirspeed Marketing LLC · Phoenix, AZBuilt 1972 · S/N AA5-0141N6043LVans Aero LLC · Newburgh, INS/N AA5-0143N6044LMercado Juan T II · Angier, NCBuilt 1972 · S/N AA5-0144N6045LStoll Russell J · Amherst, NYS/N AA5-0145N6047LFisher Sandra · Discovery Bay, CABuilt 1972 · S/N AA5-0147N6050LPerry David · Onancock, VABuilt 1972 · S/N AA5-0150N6051LMiller Lyndon · Georgetown, TXBuilt 1972 · S/N AA5-0151N6052LHoward William R · Newnan, GABuilt 1972 · S/N AA5-0152N6058LMccune William D · Tehachapi, CABuilt 1972 · S/N AA5-0158N6062LFoo Flyers LLC · Charlotte, NCBuilt 1972 · S/N AA5-0162N6064LBohannon Jessica · Tomball, TXBuilt 1972 · S/N AA5-0164N6066LBrown Andy · Cypress, TXBuilt 1972 · S/N AA5-0166N6070LPloski Greg · Prospect, CTFirst renewal noticeBuilt 1972 · S/N AA5-0170N6072LLawrence Blake C · Monument, ORBuilt 1972 · S/N AA5-0172N6073LKottke Benjamin P · Central Point, ORBuilt 1972 · S/N AA5-0173
Back to AD 95-19-15 R1