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.

N474WBPhillips Kenneth R · Brackettville, TXBuilt 1974 · S/N 21-74N474ZGarcia Robert Jr · Blanco, TXBuilt 1957 · S/N D-5220N47508Beverly Flight Center LLC · Middleton, MABuilt 1977 · S/N 28-7816086N47509Bartow Municipal Airport Development Authority · Bartow, FLBuilt 1977 · S/N 28-7890083N4750A22av Group LLC · Austin, TXS/N 22-3895N4750BConley Michael A · Mount Blanchard, OHS/N 31648N4750DGraves Frank C · Nocona, TXBuilt 1957 · S/N 34850N4750FSouth Dakota Skydivers Inc · Sioux Falls, SDBuilt 1966 · S/N P206-0350N4750NSaez Brian · Gilboa, NYBuilt 1979 · S/N 18267337N4750PKenefick Christopher Keith · Rosamond, CABuilt 1960 · S/N 27-288N4750QDelaware C Plane Inc · Wilmington, DES/N 185-1204N4750UHancock Stephen E · Yulee, FLBuilt 1964 · S/N 18051450N4751AZielinski Joseph Jr · Johannesburg, MIBuilt 1956 · S/N 22-3896N4751BRegistered aircraftBuilt 1955 · S/N 31649N4751DMoore Johnathan D · Guymon, OKBuilt 1957 · S/N 34851N4751LBoyd Aero Services LLC · Claremore, OKS/N 28-4080N4751QHofer Bruce L · Freeman, SDBuilt 1976 · S/N 18802508N4751TAerial Perspective LLC · Mount Holly, NJBuilt 1981 · S/N R18201751N4751UPlano Daniel W · Willow, AKBuilt 1964 · S/N 18051451N47525Swanson Michael T · Melbourne, FLBuilt 1977 · S/N 28-7816088N4752CShannon Alton P · Intl Falls, MNBuilt 1955 · S/N 31650N4752KAraiza Fernando A · Tucson, AZBuilt 1979 · S/N P21000283N4752LR & T Aviation Inc · White Lake, NCBuilt 1967 · S/N 28-4082N4752QBrown Timothy L · Liberty Lake, WABuilt 1978 · S/N 18503553N4752SRion Aviation Corporation · Wilmington, DEBuilt 1979 · S/N R18201414N47530Irvin Air LLC · Peru, ILBuilt 1977 · S/N 28-7890089N47538Mann Robert L · Lynnwood, WABuilt 1977 · S/N 28-7816091N4753FRobertson Robin L · Murfreesboro, TNBuilt 1966 · S/N P206-0353N4753JTiki Aerospace LLC · Saint Petersburg, FLBuilt 1967 · S/N MB-197N4753MPalotas Anne Marie · Napa, CABuilt 1978 · S/N CE-780N4753NSimmons Todd B · Cowley, WYBuilt 1979 · S/N 18267340N4753UTurchan Robert H · Scottsdale, AZBuilt 1983 · S/N 21064811N47543Hays Cory W · Beaumont, TXBuilt 1977 · S/N 28-7890091N47544Maxair Inc · Coxs Creek, KYS/N 28-7890092N4754AIndigo Air LLC · Gulf Breeze, FLBuilt 1980 · S/N 340A1024N4754EJrm Property LLC · Taylors, SCS/N 18268268N4754JDevendorf Donald A Jr · Prescott, AZBuilt 1967 · S/N MB-201N4754NBrentco Aerial Patrol Inc · Canton, OHBuilt 1979 · S/N 18267341N4754SNichols William R Jr · Austin, TXBuilt 1979 · S/N R18201416N47553Turbine Mentor LLC · Granbury, TXBuilt 1977 · S/N 32R-7880012N47557M & M Aircraft LLC · Cresson, TXBuilt 1977 · S/N 34-7770414N47559Valiair Lc Trustee · Casper, WYBuilt 1960 · S/N 47559N4755KPhilmar LLC · Oshkosh, WIBuilt 1979 · S/N P21000286N4755LBarnes John R · Waka, TXS/N 28-4085N4755QCook Alfred M · Juneau, AKBuilt 1967 · S/N 185-1212N4755WAdobe Enterprises Of Osceola LLC · Okeechobee, FLBuilt 1976 · S/N 14085N47560Vy Aviation LLC · Beverly, MABuilt 1977 · S/N 28-7816096N47562Screen Printing USA Inc · Plymouth, PABuilt 1977 · S/N 28-7890093N47564Orourke James K · Omaha, NEBuilt 1977 · S/N 28-7890094N4756CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 21063613
Back to AD 2007-04-19 R1