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.

N9934UOrr David L · Port Angeles, WAS/N AA5A0334N9936USale Reported · Wailuku, HISale reported, pending cancellationBuilt 1977 · S/N AA5A0336N9938UBurton Kenneth G · Hebron, INBuilt 1977 · S/N AA5A0338N9939UGlover Joseph · Defuniak Springs, FLBuilt 1977 · S/N AA5A0339N9941UParsons Stephen · Wellington, FLBuilt 1977 · S/N AA5A0341N9942UHawke Ronald Trustee · Mi Wuk Village, CABuilt 1977 · S/N AA5A0342N9943URandall Steve · Oakland, CABuilt 1977 · S/N AA5A0343N9948UDully David F W · Fernandina Beach, FLBuilt 1977 · S/N AA5A0348N9955UMatteson Gary E · Monmouth, ORBuilt 1977 · S/N AA5A0355N9957UTurner Steven R · Westfield, INBuilt 1977 · S/N AA5A0357N9959UGunji Harold H · Lawrenceville, GABuilt 1977 · S/N AA5A0359N9960UFletchair Inc · Comfort, TXBuilt 1977 · S/N AA5A0360N9961UAam Leasing LLC · Zeeland, MIBuilt 1977 · S/N AA5A0361N9962UJones Randall Bryan · Palm City, FLBuilt 1977 · S/N AA5A0362N9963URansom James R · Modesto, CABuilt 1977 · S/N AA5A0363N9965UEdward Brent M · Meridian, IDBuilt 1977 · S/N AA5A0365N9967ULoughney Matthew T · Mount Juliet, TNBuilt 1977 · S/N AA5A0367N9969UBlair Denton Cassity III · Morehead, KYBuilt 1977 · S/N AA5A0369N9970URowe John W · Waunakee, WIS/N AA5A0370N9973UAerospace Trust Management LLC Trustee · Wilmington, DES/N AA5A0373N9977UBarrington Edward A · Carson City, NVS/N AA5A0377N997VBBrandon Greg V · Georgetown, TXBuilt 1976 · S/N AA5B-0382N9981UExpedition Air LLC · Antioch, CABuilt 1977 · S/N AA5A0381N9983UMorel Marc G · Ocklawaha, FLS/N AA5A0383N9984URichards William · West Jefferson, OHS/N AA5A0384N9985UBlue Barren Flight Club LLC · Glasgow, KYS/N AA5A0385N9986UFreeman Andrew G · Fairhope, ALS/N AA5A0386N9989UKantz Roger Travis · Friendswood, TXS/N AA5A0389N9992UCarey International Aviation Services LLC · Long Beach, NYS/N AA5A0392N9994UKaczmarek John F · Weatherford, TXBuilt 1977 · S/N AA5A0394N9995UAero Cats Of New Hampshire LLC · Plainfield, NHBuilt 1977 · S/N AA5A0395N9996USapir Kfir · Las Vegas, NVBuilt 1977 · S/N AA5A0396N9997UGuth Giora · Lexington, MABuilt 1977 · S/N AA5A0397N9999UMcgee Allen C · Charlotte, NCBuilt 1977 · S/N AA5A0399N999EDAero Design Works LLC · Ormond Beach, FLBuilt 1975 · S/N AA5B-0188N999SRRaybob Ltd · Demarest, NJBuilt 1978 · S/N AA5B0862N99YTWind Walker LLC · Tucson, AZBuilt 1971 · S/N AA5-0005N9JSAuburn Flight Time LLC · Auburn, ALS/N AA5A-0378N9YZTwo-Two-Uniform Club Inc · Oxnard, CABuilt 1975 · S/N AA5-0822
Back to AD 95-19-15 R1