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.

N5348TDavis Samuel T · Malad City, IDS/N 18-8009009N5348UC3 Shadow LLC · Columbus, OHBuilt 1984 · S/N 21064874N5348VKavon Clinreg LLC · Palm Beach Gardens, FLBuilt 1980 · S/N 172RG0511N5348YWheeler Robert T · Silt, COBuilt 1980 · S/N 21064176N53491Crossbrook LLC · Willoughby, OHBuilt 1981 · S/N 17274764N53494Gandarillas Andrew J · Toledo, WABuilt 1981 · S/N 17274765N5349B39 Bravo LLC · Wilmington, DEBuilt 1988 · S/N E-2416N5349DFisher Randall A · Salem, OHBuilt 1979 · S/N 17272537N5349EHutchison Herbert IV · Wichita, KSBuilt 1959 · S/N D-5831N5349LHart Brad S · Elephant Butte, NMS/N 28-4652N5349USilver Ace Aviation · Toccoa, GAS/N 5092N5349XBegrow Adroaldo Dorivaldo · Gulf Shores, ALBuilt 1986 · S/N 5110N534APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843754N534BWBilmar Avionics Inc · Kissimmee, FLS/N G-63N534CACoast Flight Training And Management Inc · San Diego, CABuilt 2019 · S/N 2881278N534CBZahler Steven E · Manning, SCBuilt 1953 · S/N 53-4154AN534CDAdvanced Tree Care Inc · Lincolnshire, ILBuilt 2005 · S/N 1623N534DBBerry Darrel · Camden, TNBuilt 1958 · S/N CG-207N534DMBarnstorm/T-34 LLC · Jacksonville, FLBuilt 1955 · S/N G-750N534EGilday Aviation LLC · West Harrison, INS/N D-7825N534EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13165N534FLeiser Harry W · Rome, PABuilt 1965 · S/N T210-0109N534FLGray Gary G · Kansas City, MOBuilt 1971 · S/N 28-7125364N534JJanysek James M · Hobson, TXBuilt 2015 · S/N 13891N534KSKent State University · Stow, OHBuilt 2012 · S/N 172S11241N534LU.S. Department Of The Interior · Boise, IDBuilt 2015 · S/N CC18-0075N534MFSky Solutions LLC · Detroit, MIBuilt 2006 · S/N 11534N534MPJones David C · Williston, VTBuilt 1991 · S/N 10066N534PCSutton Brad · Vallecito, CABuilt 1975 · S/N 18264394N534QKenney Aviation LLC · Osterburg, PABuilt 1968 · S/N TC-1176N534RBCloud 9 Wings LLC · Webberville, MIBuilt 1953 · S/N G-300N534RHAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13473N534SASpur Aviation Services Lc · Twin Falls, IDBuilt 1968 · S/N 1816-22N534TLakeview Aviation Inc · Sanborn, NDBuilt 1961 · S/N CD-321N534WCPrenter Christian E · Hermosa Beach, CABuilt 2002 · S/N 60473N534YWahl Charles S · Cameron Park, CAS/N BG-70N53507Flight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N 17274769N5350KCenterline Aviation LLC · Oklahoma City, OKBuilt 1980 · S/N 17274076N5350LN5350l LLC · Statesville, NCFirst renewal noticeBuilt 1968 · S/N 28-4653N5350SSilver Tree LLC · Southern Pines, NCS/N R18201551N5351Robinson Herb · Snowflake, AZBuilt 1997 · S/N 073N53511Didia Robert · Fraser, MIBuilt 2004 · S/N 0864N53512Rapp Steven B · Hawthorne, CABuilt 2004 · S/N 0868N5351DSplan David L · Mccall, IDS/N 50249N5351EDelta Vee LLC · Savannah, GABuilt 1959 · S/N D-5832N5351HHayes Jeffery M · Yatesville, GABuilt 1975 · S/N 17265411N5351QBarrett Dannie P · Halfway, ORS/N 17261778N5352BRegistered aircraftBuilt 1958 · S/N 24-406N5352EEvergreen Aviation & Space Museum & Captian · Mcminnville, ORBuilt 1986 · S/N 5105N5352KPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 17274077
Back to AD 2007-04-19 R1