AD 2012-17-06

Registered aircraft · 2,157

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

N2DVLewis Paul A · Spring, TXBuilt 1960 · S/N 24-1679N2RTBarnett Keri Trustee · Brownfield, TXBuilt 1969 · S/N 24-4830N2SVPiper J D · Lawrenceville, ILBuilt 1963 · S/N 24-3428N3030WZadnik Gary R · Vacaville, CAS/N 24-3534N309WPMcmahon Peter · Brookfield, CTBuilt 1961 · S/N 24-2955N313MWClover George S · Catheys Valley, CABuilt 1959 · S/N 24-1637N31WHDerbecker David G · Katy, TXBuilt 1969 · S/N 24-4810N320JLInspired Oasis LLC · Salem, ORBuilt 1969 · S/N 244886N3228PPopejoy Marc · Fort Scott, KSBuilt 1958 · S/N 24-294N322JK & M Aviation LLC · West Liberty, KYS/N 24-1316N325CVajdos Nicholas · Karnes City, TXS/N 24-1082N330JGCultra LLC · Naples, FLS/N 24-3042N333CBSecondary Minimums Task Force LLC · Kalispell, MTBuilt 1971 · S/N 24-5003N333CXFlying Bs LLC · Canby, ORBuilt 1967 · S/N 24-4720N33DNRegistered aircraftBuilt 1969 · S/N 24-4896N33PHPine Creek Adventures Inc · Benton, PABuilt 1959 · S/N 24-1451N344TXCline Lyndi · Royce City, TXBuilt 1966 · S/N 24-4478N345HPMarek Gary A · Lemont, ILBuilt 1961 · S/N 24-2508N346RMHansen Alexander G · Glendale, CABuilt 1958 · S/N 24-929N354PCLund Vern E · Madera, CABuilt 1964 · S/N 24-3611N3632PAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1969 · S/N 24-3632N36RDProflight Inc · Wilmington, DEBuilt 1958 · S/N 24-490N3764XAerialsmith LLC · Dunedin, FLS/N 24-4973N3783Midwest Fling Service Inc · Elgin, NEBuilt 1963 · S/N 24-3553N37HEBjbipbip Corp Trustee · Wilmington, DES/N 24-4514N38AGBaxter Kyle W · Tumwater, WABuilt 1959 · S/N 24-1259N397PCPapadopoulos Gustave · Summerland Key, FLBuilt 1962 · S/N 24-3189N3HMTalley John T · Clifton, TXBuilt 1965 · S/N 24-4277N3HRDow Glendal R Trustee · Bedford, TXBuilt 1962 · S/N 24-3126N3MSCarter Zac · Atlanta, GABuilt 1960 · S/N 24-1747N3SDDanish John S · Hooksett, NHBuilt 1958 · S/N 24-380N3SGN3sg Enterprises Inc · Wilmington, DEBuilt 1960 · S/N 24-2036N40193Rearden Logic Inc · Denver, COBuilt 1959 · S/N 24-1239N409LAAnderson Wilma (Lori) · Blue Mound, ILS/N 24-1494N40JSAir Flight Enterprises Inc · South Daytona, FLS/N 24-3269N40RSSaul Gregory D Jr · Glenrock, WYBuilt 1960 · S/N 24-2031N40VKSimply Living LLC · Fort Myers, FLBuilt 1966 · S/N 24-4473N417BHHugel Bohdan · Selma, NCBuilt 1962 · S/N 24-3108N41AEBowen Haldor S · Sandpoint, IDS/N 24-637N41LPulliam Oscar E Jr · Moscow, TNBuilt 1958 · S/N 24-351N4236PRegistration Pending · Chandler, AZRegistration pendingS/N 24-1260N4250Leafgreen Jeff A Trustee · Lander, WYBuilt 1959 · S/N 24-894N4284Clements Eric C · Sheridan, WYBuilt 1965 · S/N 24-4284N430MMMersereau Iden H · Goodyear, AZBuilt 1966 · S/N 24-4525N431ABAirtrust LLC - 18 - Series 18 Trustee · Sheridan, WYS/N 24-4156N434BBElgin Engineering LLC · Arlington, TXBuilt 1966 · S/N 24-4536N43TLT M L Aircraft Inc · Narrowsburg, NYBuilt 1971 · S/N 24-5001N4483CRich Aden Gene · Sequim, WABuilt 1959 · S/N 24-1257N44PCGenocchio Anthony F · New Port Richey, FLBuilt 1965 · S/N 24-4124N4563VMercer Alexander David · San Diego, CABuilt 1958 · S/N 24-129
Back to AD 2012-17-06