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.

N2903DBecker Paul J · Spring Hill, FLBuilt 1979 · S/N 28-7990542N2903FSawyers Ricky Dean · Tazewell, VABuilt 1966 · S/N 18257003N2903LSchillinger Bradley Charles · Honeoye Falls, NYBuilt 1967 · S/N 670066N2903QTwin Fiddle Investment Aeronautics LLC · Atlanta, GABuilt 1978 · S/N 18503540N2903XBrowning Mcpherson Aviation LLC · Auburn, KYBuilt 1967 · S/N 17700303N29047State College Pilots Club · Philipsburg, PABuilt 1974 · S/N 17264096N29049Weiman Magnus · Lynchburg, VABuilt 1979 · S/N 28-7990429N2904MLange Keith J · Wasilla, AKBuilt 1946 · S/N 12-1318N2904QBoley Richard J · Hayward, WIBuilt 1978 · S/N 18503541N29056Land Of Lakes Aviation LLC · Eagle River, WIBuilt 1974 · S/N 17264097N29059Ens Aviation LLC · Marshall, TXBuilt 1968 · S/N U206-1043N2905ASutton Aircraft Salvage LLC · Palmer, AKBuilt 1953 · S/N 30105N2905BHawley Timothy J · Ashland, OHBuilt 1979 · S/N 32-7940194N2905ECappadona Roy · Iliamna, AKBuilt 1978 · S/N 17271369N2905LSteel Alan P · Odessa, TXBuilt 1967 · S/N 670299N2905PSimpson Danny R · Waunakee, WIBuilt 1955 · S/N 22-3172N2905RKlassen Thomas · Corpus Christi, TXS/N 310G0105N2905TZephyr Enterprises Inc · Wilmington, DEBuilt 1966 · S/N 306N2905XRudy Schmitt · Brookshire, TXBuilt 1967 · S/N 17700305N2905ZWmh Aviation LLC · Buckley, WABuilt 1978 · S/N 358-78N29061Swalling Frederick M · Anchorage, AKBuilt 1968 · S/N U206-1045N29062Jackson Stephen D · Pennsboro, WVBuilt 1979 · S/N 28-8011054N29068Jd Flying LLC · Bellingham, WABuilt 1968 · S/N U206-1049N2906CNewman Dan A · Oak View, CABuilt 1954 · S/N 30806N2906LHogue Aviation LLC · Dover, PABuilt 1967 · S/N 670300N2906MFry Steven G · Eagle River, AKBuilt 1946 · S/N 12-1321N2907Cizek Joseph E · Wasilla, AKBuilt 2017 · S/N 2016N29070Buzick Carey B · Fargo, NDBuilt 1978 · S/N R18200639N29076Flight Dynamics LLC · De Leon Springs, FLBuilt 1987 · S/N 1022N2907CPiedmont Southern Associates Inc · Clayton, GABuilt 1954 · S/N 30807N2907GWestern Antique Aeroplane And Automobile Museum · Hood River, ORBuilt 1959 · S/N 262N2907PWickenheiser John D · Newport, MIBuilt 1955 · S/N 22-3175N2907RFricks Cline Thomas Jr · Toccoa, GABuilt 1969 · S/N 28R-35324N2907ZCabana Robert D · Cocoa, FLBuilt 1978 · S/N 377-78N29084D E C Holdings · Hansen, IDBuilt 1972 · S/N 21059798N2908CWilliams Daniel P · Afton, WYBuilt 1954 · S/N 30808N2908FCooprider Lee W Trustee · Littleton, MABuilt 1966 · S/N 18257008N2908GGraves Sam · Tarkio, MOBuilt 1959 · S/N 263N2908LGurney Stephen E · Niceville, FLBuilt 1967 · S/N 670302N2908PHull Mahlon B · Sedro Woolley, WABuilt 1955 · S/N 22-3176N2908TRegistered aircraftBuilt 1966 · S/N 309N2908UBarrett H Gould · Myrtle Beach, SCS/N 1023N29098Gill Stuart W Jr · Kingsport, TNBuilt 1979 · S/N 28-7990436N2909ARasor William E · Brookville, OHBuilt 1953 · S/N 30109N2909BIsland Hoppers Inc · Glenridge, NJBuilt 1979 · S/N 32-7940196N2909CHall Michael A · Spirit Lake, IDBuilt 1954 · S/N 30809N2909QHelman Tom · Evanston, WYBuilt 1979 · S/N 28-7916533N2909TSmith David W · Milaca, MNS/N 314N290AMWheaton Megan E · Orchard Park, NYS/N 2096N290CAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0297
Back to AD 2007-04-19 R1