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.

N415VWDrago Christopher P · Flint, MIBuilt 1964 · S/N TC-811N415WHPaavola Troy E · Kansas City, MOS/N 28R-7435199N415WZCrimson Leasing LLC · Lenexa, KSBuilt 1978 · S/N 340A0602N41604Schuur Rodney E · Slayton, MNBuilt 1974 · S/N 28-7415290N41606My Flight LLC · Cypress, TXS/N 287415291N41609Worthington John F II · Russiaville, INBuilt 1974 · S/N 28-7405124N4160CNewman Holdings LLC · Dallas, TXBuilt 1978 · S/N R18200332N4160FYatin Servet · Weston, MABuilt 2000 · S/N 2844028N4160JIvy James E · Alba, TXS/N 28-22489N4160POgle Richard W Jr · Joplin, MOS/N 23-1645N41614Cartier Edward J Jr · Columbia, MSS/N 28-7415294N41618Evv Warrior LLC · Evansville, INBuilt 1974 · S/N 28-7415295N41619Charles City Aeronautics Inc · Charles City, IABuilt 1974 · S/N 28-7415296N4161JRegistration Pending · Hardinsburg, KYRegistration pendingBuilt 1966 · S/N 28-22490N4161PRegistered aircraftBuilt 1999 · S/N 2843309N4161ZAri Ben Aviator Inc · Fort Pierce, FLBuilt 1998 · S/N 2843129N41622Stingray LLC · Kalispell, MTBuilt 1974 · S/N 28-7415297N41623Airplanesusa LLC · Schaumburg, ILBuilt 1974 · S/N 28-7405126N4162MSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2008 · S/N 1877N4162SFiresheets William R · Zwolle, LABuilt 1975 · S/N CE-568N4162YGarrels Gregory J · Salcha, AKBuilt 1977 · S/N 242-77N41631Submissive Air Inc · Deadwood, SDBuilt 2008 · S/N 12294N41639Airmotive Service LLC · Brigham City, UTBuilt 1974 · S/N 28-7415299N4163ASalida Aviation Partnership Group · Moffat, COBuilt 1970 · S/N D-9121N4163FHammans Gail A · Hot Springs, ARBuilt 1976 · S/N 28-7725003N4163JLoera Josa · Laredo, TXS/N 28-22493N4163SLarson Family Farms LLC · Haxtun, COBuilt 1975 · S/N E-664N4163TKasper Heath · Albany, ORS/N 320D0063N41641Gunderson Roger · Fort Collins, COBuilt 1999 · S/N 2843276N41645Coastal Air Inc · Groton, CTBuilt 1974 · S/N 28-7405128N41648Russell Matthew M · Niantic, CTBuilt 1974 · S/N 28-7415304N41649Air Trek North LLC · South Saint Paul, MNBuilt 1974 · S/N 28-7415305N4164HRobertson James I · La Pine, ORBuilt 1978 · S/N 24-0623N4164JCaister Benjamin M · Saint Clair, MIS/N 28-22494N4164PSeaplanes R Fun Inc · Wilmington, DEBuilt 1959 · S/N 23-1649N4164QPollux Aviation Ltd · Wasilla, AKBuilt 2008 · S/N 12232N4164SFabien Turpaud Corp · Lewes, DEBuilt 1975 · S/N D-9753N4164YBoard Of Trustees · Savoy, ILBuilt 2000 · S/N 2843317N41650Airmotive Service LLC · Brigham City, UTBuilt 1974 · S/N 28-7415306N41657Morton Zac D · San Antonio, TXBuilt 1974 · S/N 28-7415308N4165BGood Decision Aviators LLC · Noble, OKBuilt 1975 · S/N 76-30799N4165EJauer Brant A · Saukville, WIBuilt 1999 · S/N 2843291N4165QGhiselli William A III · Woodruff, WIBuilt 1968 · S/N 310N-0065N4165S5100 Departure LLC · Beaufort, NCBuilt 1975 · S/N TE-1049N4165UInter American University Of Puerto Rico · Bayamon, PRBuilt 1998 · S/N 2843200N4165ZHollingsworth Lloyd Dan · Anchorage, AKBuilt 1965 · S/N 18-8346N41667Lewis Clifton Jack · North Branch, MIBuilt 1974 · S/N 28-7415116N41669Hogan Daniel L · Chapel Hill, NCBuilt 1974 · S/N 28-7415312N4166CBas Part Sales LLC · Greeley, COBuilt 1978 · S/N R18200334N4166FStalworth Leasing Inc · Burr Ridge, ILBuilt 1999 · S/N 2843263
Back to AD 2007-04-19 R1