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.

N334RDWrob Aero LLC · Del Rio, TXBuilt 1978 · S/N CE-837N334RLButters Brewster S · Port Orange, FLBuilt 1963 · S/N G-12N334RTHyde Alfred D III · Denton, TXBuilt 1971 · S/N CD-1263N334RVFlyrs Field Inc · Anchorage, AKBuilt 2010 · S/N 4480N334SASchaumburg Flying Club Nfp · Palatine, ILBuilt 1998 · S/N 18280393N334SCGist Sally R · Horseshoe Bay, TXBuilt 1960 · S/N 50691N334SESteeb Erik · San Luis Obispo, CABuilt 1987 · S/N CE-1111N334SPSierra Pop Air LLC · Wilmington, DEBuilt 2003 · S/N 172S9494N334TFlying Crown Aviation LLC · Fond Du Lac, WIBuilt 1955 · S/N BG-138N334TRNachtigal Michael P · Ozark, MOBuilt 1990 · S/N CE-1499N334TXMagic Mentor LLC · Canyon, TXS/N G-26N334UWalter Matthew Timothy · Bella Vista, ARBuilt 1992 · S/N CE-1685N334VHFly Fly Fly LLC · Dover, DEBuilt 1992 · S/N 2177N334WCenturion Investments Inc DBA · Chesterfield, MOBuilt 1976 · S/N U20603331N334WCFarmland Developers LLC · Jonesboro, ARBuilt 2016 · S/N 30009N334WDSouthwest Aviation Enterprises · Haslet, TXBuilt 2011 · S/N 20608334N334WSCoolidge Oliver B Trustee · Denver, COBuilt 1966 · S/N CE-79N334YWarner Aric D · Rosamond, CAS/N 18051299N3350FStrait Daniel · Sierra Vista, AZBuilt 1966 · S/N 18257350N3350SBarry Jason J · Orange, CABuilt 1969 · S/N 21059150N3350TBaxley Aviation LLC · Baxley, GABuilt 1971 · S/N 28-7125377N3350UKragseth Kyle A · Shoshone, IDBuilt 1963 · S/N 18254750N3350ZKintner Daniel S · Conyers, GAS/N 22-7290N33511Annis Aviation LLC · Gray, GABuilt 1964 · S/N TC-800N3351LGagnon Philip F · Anchorage, AKBuilt 1967 · S/N 185-1303N3351STarantino Nicholas T Jr · Union City, CAS/N 21059151N3351TTaylor Gail L · Red Bluff, CAS/N 17700651N3351WRegistered aircraftBuilt 1965 · S/N 32-193N3351XRuther Dennis A · Lake Havasu City, AZFirst renewal noticeBuilt 1966 · S/N 3370N33520Dolbeare Eric E · Nebo, ILBuilt 1975 · S/N 28-7515295N33529Moon Scott R · Plover, WIBuilt 1975 · S/N 28-7505154N3352BRey Aviation LLC · Weston, FLBuilt 1954 · S/N 18-3305N3352FDaradici Jodi A · Gilbert, AZBuilt 1966 · S/N 18257352N3352ZLoppnow Martin L · Yermo, CAS/N 22-7292N33530Lapointe Curtiss James · Powell, TNBuilt 1975 · S/N 28R-7535157N33532Williams Kevin · Irvington, ALBuilt 1975 · S/N 28-7525203N33534Two One Aviation LLC · Benton, PABuilt 1975 · S/N 28-7505155N3353PHeffron Jacob L · Little Falls, MNBuilt 1958 · S/N 23-1308N3353TDwinell Jeffrey C · Granby, MABuilt 1967 · S/N 17700653N3353UWieser Ranch Inc · Vernon, COBuilt 1963 · S/N 18254753N3353WGrigg Charles I Jr Trustee · Emporia, VABuilt 1965 · S/N 32-196N3353XBain Jonathan · Newark, DEBuilt 1966 · S/N 1078N33542Schmidt David L · Wasilla, AKBuilt 1957 · S/N 22-5108N33545Beck Brady P · Nixon, TXBuilt 1975 · S/N 28-7525206N3354QOn The Beam Aviation Inc · Hampton, GABuilt 1967 · S/N 310L-0204N3354WArocho David · Orlando, FLBuilt 1965 · S/N 32-197N3354XVirginia Aircraft Rentals LLC · Broadway, VABuilt 1966 · S/N 1079N3354YFelkins Roger C · Hillsboro, ALBuilt 1962 · S/N 18254354N3354ZJohnson Charles D · Benson, AZBuilt 1960 · S/N 22-7294N33550Nutmeg Flying Club · Stratford, CTBuilt 1975 · S/N 28-7505157
Back to AD 2007-04-19 R1