AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-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:2007-04-19-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.

N31536Island Air Taxi LLC · Put In Bay, OHBuilt 1978 · S/N 32-7840132N3153BSeverson James A Jr · Tualatin, ORBuilt 1983 · S/N P21000834N3153CCulver Marc D · Anchorage, AKBuilt 1954 · S/N 30952N3153DN3153d LLC · Middletown, DEBuilt 1955 · S/N 31951N3153HChristensen David R · Brigham Cit, UTBuilt 1982 · S/N 663N3153LMiller James R · Parowan, UTBuilt 1965 · S/N 310J0153N3153PWhiskey Mike Aviation LLC · Merrimac, WIBuilt 1994 · S/N E-2884N3153QMaine Mold & Machine Inc · Hartford, MEBuilt 1967 · S/N 18258153N3153TRegistered aircraftBuilt 1967 · S/N 17700453N3154CMitchell Barry C · Sagle, IDBuilt 1954 · S/N 30953N3154DJohnson Daniel P · Pardeeville, WIS/N 31952N3154FMetcalf Management Inc · St George, UTBuilt 1994 · S/N EA-564N3154LOnisko Aidan C · Williams, CAS/N 310J0086N3154RKuchera Ray A · Rockdale, TXBuilt 1967 · S/N 18258554N31551Hawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2006 · S/N 11451N3155BCountry Development LLC · Lebanon, ORBuilt 1995 · S/N 18026CN3155CNolan Michael William Jr · Silver Spring, MDBuilt 1954 · S/N 30954N3155DNervino Blake · Turlock, CABuilt 1955 · S/N 31953N3155FHansen Jeremy · Burlington, COBuilt 1966 · S/N 18257255N3155QLandro Rebecca · Puyallup, WAS/N 18258155N3155REnright Matthew R · Skiatook, OKBuilt 1967 · S/N 18258555N3155SSterling Flight Training LLC · Jacksonville, FLBuilt 1978 · S/N 28-7890525N3155TRobbins Charles R · Trout Creek, MTBuilt 1967 · S/N 17700455N3155YBult Equipment LLC · Monee, ILBuilt 2006 · S/N 4095N3155ZKrejci Dwight D · Wheatland, WYBuilt 1959 · S/N 22-7102N31563Hfd Aviation LLC · Salem, VABuilt 1978 · S/N 28-7816561N31565Datema Steven K · Susanville, CABuilt 1978 · S/N 28-7816563N31569Snyder Bradley R · Johnstown, PABuilt 1978 · S/N 32-7840133N3156CMarshall Robert L · Pine River, MNBuilt 1954 · S/N 30955N3156GBlack Ops Aviation LLC · Moorhead, IABuilt 2006 · S/N 1666N3156PLumley William · Delray Beach, FLBuilt 1957 · S/N 23-1087N3156RChamplain Robert F · Canton, ILBuilt 1967 · S/N 18258556N3156TSpring Mitchell L · Saint Cloud, FLBuilt 1967 · S/N 17700456N3156XBack Country Aviation LLC · Jupiter, FLS/N 20700376N3156YGrant Robert N · Pollock Pines, CABuilt 1962 · S/N 18254156N3156ZSale Reported · Wellsville, UTSale reported, canceledBuilt 1959 · S/N 22-7103N31571Cg Air LLC · Mason City, IABuilt 1978 · S/N 32-7840134N31573Miller Gerald L · Selinsgrove, PABuilt 1978 · S/N 32R-7885103N3157GBrushpopper Aviation LLC · Annona, TXBuilt 2006 · S/N 11531N3157HBroughton Tim · Lucas, TXBuilt 2006 · S/N 11499N3157QVowell Gregory · Coffeyville, KSBuilt 1967 · S/N 18258157N3157THollrah Kenneth R · Enid, OKBuilt 1967 · S/N 17700457N3157UDavison Cornelius Harry Jr · Phoenix, AZBuilt 1962 · S/N 18254557N3157YBrennand R44 LLC · Neenah, WIFirst renewal noticeS/N 12053N3157ZIvy James E · Alba, TXS/N 22-7104N31581Lesher Jesse L · Walton, KYBuilt 1978 · S/N 28-7816565N31583Redel Michael R · Gasquet, CABuilt 1978 · S/N 28-7890470N31586Nichols Jan L · Bonham, TXS/N 7835N31589Redemption Leasing LLC · Kodiak, AKBuilt 1978 · S/N 32-7840135N3158FTw Enterprises Inc · Naperville, ILBuilt 1966 · S/N 18257258
Back to AD 2007-04-19 R1