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.

N5173UKnutson Wayne R · Tioga, NDBuilt 1964 · S/N 206-0173N5173VEastern Kentucky University · Richmond, KYBuilt 2002 · S/N 172S9046N51748Planenutz LLC · Deland, FLBuilt 1980 · S/N 17274342N5174AWells Lavar W · Hanksville, UTBuilt 1956 · S/N 28174N5174EBlue Sky Pilots Inc · Salem, ORBuilt 1978 · S/N 17271752N5174GMartin William · San Antonio, TXS/N 22304N5174HFlying Finn Enterprises LLC · Wilmington, DEBuilt 1975 · S/N 17265360N5174LVentura Robert E · Ventura, CAS/N 28-4459N5174SKatzakian Trevor T · Lodi, CABuilt 1970 · S/N 28-7105028N51757Spencer John S · Indian, AKBuilt 1978 · S/N 423N51758Enstrom Instruction LLC · Newark, DEBuilt 1978 · S/N 435N5175DSlug Air LLC · White Salmon, WABuilt 1966 · S/N 18-8438N5175EWinston Jacob · Granbury, TXBuilt 1978 · S/N 17271753N5175FBroomstick Aviation LLC · Fairfield, IABuilt 2004 · S/N 0818N5175GKahn David J · Roanoke, VAS/N 22577N5175JAycock Charles C · Midland, TXS/N 340A0010N5175LAsb Industries LLC · Driggs, IDBuilt 2005 · S/N 1542N5175NArkansas Bolt Co · Little Rock, ARBuilt 1980 · S/N 18267560N5175PSbkr LLC · Greenville, PABuilt 2002 · S/N 18281155N5175SBlu Skye Distribution Inc · Mount Holly, NCBuilt 1970 · S/N 28-7105029N5175TMcclain Timothy J · Tucson, AZBuilt 1966 · S/N 147N5175YLutz Aviation LLC · Perkinsville, VTBuilt 2002 · S/N 172S9050N51768Stocker Concrete Co · Gnadenhutten, OHBuilt 1978 · S/N 446N51769Arizona Skies Aviation LLC · Scottsdale, AZS/N 443N5176EAirplane Money Pit LLC · Rexburg, IDBuilt 1982 · S/N 18268296N5176HBoyer Christopher A · Anchorage, AKBuilt 1948 · S/N 14-196N5176LMilliner Greg A · Kokomo, INBuilt 1967 · S/N 28-4462N5176RRight Rudder Flight Training LLC · La Verne, CABuilt 1979 · S/N 172RG0044N5176SNora Jet LLC · Granbury, TXS/N 28-7105030N5176TScott Judson M · Wasilla, AKBuilt 1967 · S/N 153N5176VVangorder Donna · Greenwood, ARS/N 172RG0459N51770Lrh Equipment LLC · Pendleton, ORS/N 445N51778Medical Evacuation Disaster Intervention Corps · Springdale, ARS/N 451-2N5177DCross Richard G · Brewster, MNBuilt 1958 · S/N 51277N5177EAbraham Edward C · Canadian, TXBuilt 1959 · S/N 50477N5177FPray Aviation Inc · Augusta, KSBuilt 1976 · S/N 28-7715096N5177HPomeroy Cattle Ranch LLC · Kalispell, MTBuilt 1975 · S/N 17265361N5177MElh Aviation LLC · Flint, MIBuilt 1977 · S/N TJ-116N5177NMacelvaine William Stephen · Morro Bay, CABuilt 1980 · S/N 18267561N5177PLi Steven Y · Warren, NJBuilt 1958 · S/N 24-197N5177WBuffham Daniel L · Meridian, IDBuilt 1961 · S/N 28-212N51782Ranger Lumber Corp · Springfield, MABuilt 2002 · S/N 18281096N51784Winingar Thomas M · Brock, TXBuilt 2002 · S/N 18281097N51785Photos Unlimited · Rancho Cordova, CABuilt 2002 · S/N 18281098N51787Holder Michael T · Whitesburg, GABuilt 1980 · S/N 1172N51788Rhoads Timothy C · Logan, NMBuilt 1978 · S/N 452-2N51789Breyer Charles A · Lewes, DEBuilt 1978 · S/N 454-2N5178AHale Mitchell D · Chugiak, AKBuilt 1962 · S/N 18-7483N5178EHughes Kenneth L Jr · Wasilla, AKBuilt 1959 · S/N 50478N5178GCourville Gerald K · Reeves, LAS/N 22242
Back to AD 2007-04-19 R1