JASC 3350
Service difficulty reports · 225,886
Reports filed under 3350 · Emergency Lighting, newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '3350' ORDER BY difficulty_date DESC"
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.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '3350' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR DALA2016112109017Light · inoperativeOVERHEAD AISLE EMERGENCY LIGHTS INOP ROW 19, 23, 40. RELAMPED PER AMM 33-51-05, OPS OK.SDR DALA2016112109016Light · inoperativeCOCKPIT EMERGENCY LIGHT INOP. RELAMPED PER AMM 33-51-09, OPS OK.SDR SWAA2016112109881Lamp · inoperativeAFT ENTRY DOOR SLIDE EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW MM. .SDR SIMA20161120002Panel · inoperativePASSENGER DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LIGHT PANEL ASSY, IAW AMM 25-23-04. OPS CHECKED GOOD.SDR MASA2016112012487Light · inoperativeROW 11 CEILING LEVEL EMERGENCY FLOOD LIGHT INOP. PLACED ON MEL.SDR SIMA20161119005Light · damagedCABIN EMERGENCY LIGHTS HAD ONE DAMAGED FWD SECTION, AND ONE AFT SECTION. INSTALLED SERVICEABLE CABIN EMERGENCY LIGHT STRIPS IN THE FWD AND AFT SECTIONS OF THE CABIN IAW AMM 33-51-01.SDR HALA2016111900208Cover · looseAFT GALLEY FLOOR LIGHT NEEDS SECURING. SECURED AFT GALLEY FLOOR LIGHT COVER.SDR AALA20161122021Light · looseOVERHEAD EMERGENCY EXIT LIGHT AT ROW 22 HAS A LENS COVER THAT WILL NOT ATTACH DUE TO A LOOSE LIGHT ASSEMBLY. SECURED LIGHT BASE AND REINSTALLED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20161122004Battery · faultySEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE FOR SEATS 32H THROUGH 41H. REMOVED AND REPLACED CHARGER ASSEMBLY AND BATTERY ASSEMBLY AT M734 IAW AMM 33-60-98. REPAIRED SHORTED WIRES AT SEAT 32H. OPERATIONAL CHECK GOOD.SDR AALA20161122003Charger · faultySEAT MOUNTED EMERGENCY PATH LIGHTS INOPERATIVE FOR SEATS 32H THROUGH 41H. REMOVED AND REPLACED CHARGER ASSEMBLY AND BATTERY ASSEMBLY AT M734 IAW AMM 33-60-98. REPAIRED SHORTED WIRES AT SEAT 32H. OPERATIONAL CHECK GOOD. REFERENCE AALA20161122004 AND AALA201611SDR AALA20161121012Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT ON RIGHT FORWARD GALLEY AISLE SIDEWALL, OPPOSITE ENTRY CLOSET WALL, IS MISSING LENS COVER. REPLACED LENS COVER IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA20161121011Lens · detachedAIRCRAFT NOT GROUNDED. L2 DOOR EMERGENCY EXIT SIGN LENS COVER DETACHED. SECURED LENS COVER IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA201611219010Lens · missingEMEG LIGHT COVER MISSING AFT LEFT. REPLACED EXIT LIGHT COVERS AT DOORS 4L AND 4R. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201611219009Lens · missingEXIT LITE COVERS DOORS 4L & 4R MISSING. REPLACED EXIT LIGHT COVERS AT DOORS 4L AND 4R. THE AIRCRAFT WAS NOT GROUNDED.SDR HALA2016111900518Light · inoperativeEMERGENCY EXIT ROW LIGHT INOP FROM EAT 1A TO 24 A. REMOVED & REPLACED POWER SUPPLY ASSY M1557 & M1558 PER AMM 33-51-07. OPERATIONAL CHECK OK.SDR AALA20161121010Lens · detachedAIRCRAFT NOT GROUNDED. AFT GALLEY EMERGENCY EXIT LIGHT LENS COVER DETACHED. REINSTALLED LENS COVER IAW AMM 25-63-00. OPERATIONAL CHECK GOOD.SDR AALA20161120010Power Supply · faultyAIRCRAFT WAS GROUNDED. FORWARD LEFT OVERWING EMERGENCY LIGHTS FAIL CARD 2908 TEST FOR TIME LIMIT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M1694 IAW AMM 33-51-06. OPERATIONAL CHECK NORMAL.SDR AALA20161120009Power Supply · faultyAIRCRAFT WAS GROUNDED. FORWARD RIGHT INTERIOR OVERWING EMERGENCY LIGHTS FAIL CARD 2908 TEST FOR TIME LIMIT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M1695 IAW AMM 33-51-06. OPERATIONAL CHECK NORMAL.SDR AALA20161120008Sign · brokenAIRCRAFT WAS NOT GROUNDED. R2 DOOR AREA GALLEY EMERGENCY EXIT IDENTIFIER L1191 IS BROKEN . REMOVED AND REPLACED EXIT IDENTIFIER IAW WDM 33-51-22. OPERATIONAL CHECK NORMAL IAW AMM 33-51-00.SDR AALA20161120006Power Supply · faultyAIRCRAFT WAS GROUNDED. ROW 7 TO ROW 12 EMERGENCY LIGHTS FAIL CARD 2908 TEST FOR TIME LIMIT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M1676 IAW AMM 33-51-06. OPERATIONAL CHECK NORMAL.SDR AALA20161120005Power Supply · faultyAIRCRAFT WAS GROUNDED. AFT LEFT GALLEY EMERGENCY LIGHTS FAIL CARD 2908 TEST FOR TIME LIMIT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M1673 IAW AMM 33-51-06. OPERATIONAL CHECK NORMAL.SDR REXA2016111902252Light · inoperativeNR 3 EXTERNAL E LIGHT RIGHT SIDE INOP. R&R NR 3 EXTERNAL E-LIGHT ON RIGHT SIDE IAW AMM 33-51-21, OPS CHECK IAW AMM 33-51-00 OPS CHECK GOOD.SDR DALA2016112109048Light · inoperativeROW 1 TO 6 BOTH A/C LEFT AND RIGHT SEAT EMERGENCY LIGHTS INOP. REMOVED AND RELAMPED MULTIPLE LIGHT BULBS IAW AMM 33-00.SDR DALA2016112109014Lens · damagedEMERGENCY ISLE LIGHTS DAMAGE AT SEATS 3,6,26,27. REMOVED AND REPLACED LENS FOR EMERGENCY ISLE LIGHTS AT SEATS 3,6,26,27 PER MM 33-52.SDR SWAA2016112109890Battery Pack · inoperativeAFT DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW MM.SDR SWAA2016112109877Battery Pack · inoperativeSEAT ROW 16 & 18 EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACK IAW MM.SDR SIMA20161119001Sign · inoperativeFOUND REAR LT DOOR EMERGENCY EXIT SIGN INOPERATIVE DURING PS-1 CHECK. REMOVED AND REPLACED THE SIGN IAW AMM 33-50-13. OPS CHECKED GOOD.SDR R61A201611190679Light · intermittentCREW REPORTED THAT THE EMERGENCY LIGHT IN ROW 15 WAS INTERMITTENT. MAINTENANCE RESET AIRCRAFT AND ARMED EMERGENCY LIGHTS PER AMM AND OPS CHECKED GOOD.SDR FDEA201611194123Light · inoperativeRT FWD EMERGENCY SLIDE EVACUATION LIGHT INOP. PERFORMED EMERGENCY LIGHTS OPS CHECK IAW AMM.SDR MASA2016111912484Battery · unsecureSEVERAL EMER LIGHTS INOP. RE-SECURED BATTERYSDR MASA2016111812483Light · inoperativeLT FWD EXTERNAL EMERGENCY LIGHT INOP. REPLACED BULB.SDR SWAA2016121210408Lens · brokenFORWARD GALLEY AREA EMERGENCY EXIT LIGHT LENS BROKEN. R&R LENS IAW AMM.SDR AALA20161124002Light · inoperativeEMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY AND ACCOMPLISHED SATISFACTORY OPERATIONAL TEST IAW AMM 33-51-05.SDR AALA201611229011Light · inoperativeLEFT FWD OVERWING DOOR LIGHT ASSY INOPERATIVE. REPLACED THE LIGHT ASSY IAW AMM 33-51-15 OPS NORMAL.SDR AALA20161123002Light · inoperativeAFT EMERGENCY LIGHT AT 5D IS INOPERATIVE. REMOVED AND REPLACED SEAT LIGHT ASSEMBLY AND ACCOMPLISHED SATISFACTORY OPERATIONAL TEST IAW AMM 33-51-05.SDR AALA20161123001Light · inoperativeEMERGENCY LIGHT AT SEAT 21G IS INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSEMBLY AND ACCOMPLISHED SATISFACTORY OPERATIONAL TEST IAW AMM 33-51-05.SDR AALA20161119013Power Supply · inoperativeL2 DOOR EMERGENCY POWER SUPPLY, M33096, IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY AND ACCOMPLISHED SATISFACTORY OPERATIONAL TEST IAW AMM 33-51-06.SDR IPXA2016112110872Lamp · inoperativeLAVATORY EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP.SDR REXA2016111802255Lens · brokenLENS ON FLOOR TRACK LIGHTING AT SEAT 3A BROKEN AND MISSING SECTION. REMOVED & REPLACED FLLOR TRACK LENS AT SEAT 3A IAW AMM 33-51-0.
1
"SDR SWAA2016112209911Lens · missingL1 DOOR EXIT SIGN LENS MISSING. R & R THE SIGN ASSY IAW MM.SDR SWAA2016112209887Lens · missingEMERGENCY EXIT LIGHT LENS AT ROW 10 DEF MISSING. INSTALLED LENS IAW MM.SDR AALA20161121006Lens · looseAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN LENS IN AISLE BETWEEN SEATS 21C AND 21D IS LOOSE. SECURED EXIT SIGN LENS. OPERATIONAL CHECK GOOD.SDR AALA20161121005Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT LENS AT ROW 21 RIGHT SIDE IS DETACHED. SECURED LENS IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR DALA2016112109053Cover · looseEMERGENCY EXIT SIGN COVER LOOSE. SECURED. OPERATION CHECKS GOOD.SDR SWAA2016112109892Light · no testRIGHT EXTERIOR EMEGENCY LIGHTS FAILED TO TEST.SDR SWAA2016112109891Battery Pack · no testAFT CABIN EMERGENCY LIGHT BATTERY FAILED TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2016112109883Lens · looseFORWARD ENTRY DOOR EXIT SIGN LENS LOOSE. REPLACED THE LENS IAW MM.SDR SWAA2016112109876Lens · missingLOWER L2 DOOR EMERGENCY LIGHT LENS MISSING. INSTALLED A NEW LENS IAW MM.SDR SWAA2016112109875Lens · missingLOWER R2 DOOR EMERGENCY LIGHT LENS MISSING. INSTALLED A NEW LENS IAW MM.SDR SWAA2016112109874Lens · missingLOWER R1 DOOR EMERGENCY LIGHT LENS MISSING. INSTALLED A NEW LENS IAW MM.
Back to JASC 3350