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.

N2981TKool-E5 LLC · Valdosta, GABuilt 1966 · S/N 355N2981YBeebe Michael · Rangeley, MEBuilt 1962 · S/N 18253981N29821Jks Enterprises Inc · Park Rapids, MNBuilt 1972 · S/N 18261233N2982ASkywagon Pilots Inc · Santa Clara, CABuilt 1953 · S/N 30182N2982KHalcomb Billy J · Pond Creek, OKBuilt 1980 · S/N 18053146N2982LBurgdorf Brandon M · Evansville, INBuilt 1967 · S/N 670341N2982XSale Reported · Lakeland, FLSale reported, canceledS/N 17700382N2983FHalle Michael P · Livingston, TXBuilt 1966 · S/N 18257083N2983PEastgate Motors Inc · Salem, ORS/N 18-4521N2983TSlatter Lowell J · Buhl, IDBuilt 1966 · S/N 356N2983XEagle Sky Patrol Inc · Deadwood, SDBuilt 1969 · S/N 17701365N2983ZFisher Charlton D · Houston, TXBuilt 1959 · S/N 18-7094N2984CRosser Brian K · Minden, NVBuilt 1954 · S/N 30884N2984YRondeb Aircraft LLC · Wilmington, DEBuilt 1962 · S/N 18253984N29859Dangelo Thomas M · Plymouth, MIBuilt 1976 · S/N 14038N2985CBraham John P · Fairbanks, AKBuilt 1954 · S/N 30885N2985LHeskett Sean D · Steamboat Springs, COBuilt 1967 · S/N 670344N2985THuskey Ryan J · Guthrie, OKBuilt 1967 · S/N 059N2985XFrazier James R · Adamsville, TNBuilt 1967 · S/N 17700385N2985YJones Aviation Inc · Biggs, CABuilt 1962 · S/N 18253985N2986AMorris Blain E · Delta Junction, AKBuilt 1953 · S/N 30186N2986EYbarguen Johnny C · Rosenberg, TXBuilt 1982 · S/N 18268225N2986KSmith John F III · Middletown, DEBuilt 1980 · S/N 18053149N2986PBentley Aero Inc · Wilmington, DEBuilt 1955 · S/N 18-4499N2986RArmstrong Dustin L · Hobbs, NMS/N 28R-35375N2986ZWharton Betty E · Amarillo, TXFirst renewal noticeBuilt 1959 · S/N 18-7100N2987CYount Lawrence F · Shelton, WABuilt 1954 · S/N 30887N2987FRegistered aircraftBuilt 1966 · S/N 18257087N2987PSmall Mark B · Walla Walla, WAS/N 18-4500N2987TDaly Arthur P · El Paso, TXBuilt 1966 · S/N 360N2988BLongobardo Anthony · San Clemente, CABuilt 2012 · S/N 1002N2988FTaf Aerial Services LLC · Beeville, TXBuilt 1966 · S/N 18257088N2988KMelvin Perry D · Warner Robins, GABuilt 1980 · S/N 18053151N2988PKadrmas Ryan · Dickinson, NDFirst renewal noticeBuilt 1955 · S/N 18-4501N2988RSpilman Kathleen M · Mandan, NDBuilt 1970 · S/N 28R-35671N2988TSwiftmeyers LLC · Benton Harbor, MIBuilt 1966 · S/N 361N2988XDoyle Thomas P · San Diego, CABuilt 1968 · S/N 17700388N2989Reavely Richard T · Madison, CTBuilt 1969 · S/N M-1274N2989MInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 32-7840062N2989TMid America Museum Of Aviation And Transportation · Sioux City, IABuilt 1966 · S/N 362N2989XLabadie Enrique L · Tucson, AZBuilt 1967 · S/N 17700389N298ACEagle Prairie Flyers LLC · Eau Claire, WIFirst renewal noticeBuilt 1999 · S/N 1259-99N298BCFlight School Of Gwinnett · Lawrenceville, GABuilt 1978 · S/N ME-59N298CACurtis Caleb K · Pittsfield, MEBuilt 2025 · S/N 80473N298CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283020N298CSCirrus Sr22 Somex Inc Trustee · Wilmington, DEBuilt 2005 · S/N 1408N298DBButler John P · Hazelhurst, WIBuilt 2005 · S/N 18281595N298DCVadnais Kenneth · Santa Barbara, CABuilt 2016 · S/N 13936N298FMStuart Scott · Lincoln, NEBuilt 2016 · S/N E-4098N298FSChupp Aaron · Gallipolis, OHBuilt 2016 · S/N 001
Back to AD 2007-04-19 R1