AD 2017-15-05

Registered aircraft · 2,146

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:2017-15-05')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-15-05')
  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.

N1188YSkylark Flight Training LLC · Panama City, FLBuilt 1964 · S/N 30-403N1189PParks Eric · Matthews, NCBuilt 1955 · S/N 23-203N118BLEdge Aviation LLC · Hawthorne, FLBuilt 1965 · S/N 30-913N1197PPenley Steven A · Corinth, TXBuilt 1955 · S/N 23-212N11KYKlad-Air LLC · Catlett, VABuilt 1966 · S/N 30-1181N11MPAtwill Brock · Paragould, ARBuilt 1972 · S/N 27-4821N11MTSpeedy Aviation LLC · Liberty, SCBuilt 1978 · S/N 27-7854064N11PYCuller John T · Arvada, COBuilt 1964 · S/N 30-533N11PZCentral Virginia Flyers LLC · Palmyra, VABuilt 1971 · S/N 27-4699N11QTAv8rs LLC · Sugar Valley, GABuilt 1968 · S/N 30-1780N11TDDuflo Spray Chemical Inc · Lowville, NYBuilt 1960 · S/N 27-271N11YYAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1967 · S/N 30-1573N1206APelham Aircraft LLC · Dallas, TXBuilt 1966 · S/N 301206N1207PN73481 LLC · Ault, COBuilt 1955 · S/N 23-223N120DUnited States Air Force Owner · Hanscom Afb, MABuilt 1972 · S/N 27-4799N1210PRegistration Pending · Independence, MORegistration pending, pending cancellationBuilt 1955 · S/N 23-226N1215PTucker Robert B · Melba, IDFirst renewal noticeBuilt 1955 · S/N 23-234N1217Pendley Rory G · Torrance, CABuilt 1955 · S/N 23-237N121SLLadet David E · Lavonia, GABuilt 1969 · S/N 27-4475N1220BWash Steven M · Austin, TXBuilt 1957 · S/N 23-1161N122DDBeacon Hill Leasing LLC · Plymouth, MIBuilt 1977 · S/N 27-7754120N1231PTwin Oaks Airpark Inc · Hillsboro, ORBuilt 1955 · S/N 23-251N1234PThomas Steven E · Libertyville, ILBuilt 1955 · S/N 23-255N1236Entwistle Brian V · Knoxville, TNS/N 30-1167N123PJacobs Michael · Jay, OKBuilt 1955 · S/N 23-397N123PVSandlapper Aviation Of De Inc · Bennington, VTBuilt 1973 · S/N 27-7305039N1249VAguilar Perez Jose L · Newton, MABuilt 1976 · S/N 27-7654046N1255PJones Jamie · Grants Pass, ORS/N 23-281N12595Cornell Terry Jason · Bloomsburg, PABuilt 1971 · S/N 27-4725N125YDsr-Cherokee 180 LLC · Dallas, TXFirst renewal noticeBuilt 1963 · S/N 27-2366N126MAWinter Kristin A · Spring Lake Park, MNBuilt 1969 · S/N 30-1865N126PFPylant Ruth A · Lubbock, TXS/N 30-1122N1271PWendt Aero LLC · Newberg, ORBuilt 1955 · S/N 23-301N1273PMatthews Grover C · Fairborn, OHBuilt 1955 · S/N 23-304N128LBWareham Andrew John · Wasilla, AKBuilt 1966 · S/N 30-1132N1292PEm Turbines Corp · Fort Lauderdale, FLS/N 23-327N12FSLawley Frederick E · Bozeman, MTBuilt 1966 · S/N 30-1226N12GEJ&P Master Flooring Corp · Lauderdale Lakes, FLBuilt 1974 · S/N 27-7405422N12JLGiber Kristofor D · Manvel, TXBuilt 1961 · S/N 27-404N12MPMarcus Robert L · Dallas, TXBuilt 1963 · S/N 30-284N1305PParkhill Clifton A Jr Trustee · Oxnard, CABuilt 1955 · S/N 23-345N1308BHopewell Jeffrey D · Temple, TXBuilt 1955 · S/N 23-340N130MMMighty Mike LLC · Maysville, KYBuilt 1964 · S/N 30-550N1316PMatthews Grover C · Hardinsburg, KYBuilt 1955 · S/N 23-356N1317PWhite Christopher N · Clearwater, FLBuilt 1955 · S/N 23-357N1319PCanter Russell L · Enterprise, KSBuilt 1955 · S/N 23-360N131FAJones Donald T Jr · Barrigada, GUBuilt 1968 · S/N 27-4097N131RMInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 27-7654053N131TVO'Brien Daniel H · Half Moon Bay, CABuilt 1977 · S/N 27-7754070N132CTausch Roger M · Saint Charles, MIBuilt 1963 · S/N 30-62
Back to AD 2017-15-05