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 UIEA2019052104245Light · inoperativeDOOR 5 LAV. FWD FLOOR EMERGENCY LIGHT #2 AND #3 INOP. (COUNT FROM LT).(<P>EMERGENCY LIGHT REPLACED. OPERATIONAL CHECK NORMAL IAW AMM 33-51-00.</P>)SDR UIEA2019052104246Light · inoperativeDOOR 2R RT LAV. FLOOR EMERGENCY LT PIN BROKEN (COUNT FROM RT).(<P>EMERGENCY LIGHT REPLACED. OPERATIONAL CHECK NORMAL IAW AMM 33-51-00.</P>)SDR UIEA2019052104247Light · inoperativeSEAT 7AC EMERGENCY LIGHT BULB MISSING. (<P>EMERGENCY LIGHT LAMP REPLACED. OPERATIONAL CHECK NORMAL IAW AMM 33-51-00.</P>)SDR UIEA2019052104248Light · inoperativeSEAT 41HK EMERGENCY LT INOP.(<P>EMERGENCY LIGHT LAMP REPLACED. OPS CHK, TEST NORMAL IAW AMM 33-51-00.</P>)SDR UIEA2019052104249Light · inoperativeL3 DOOR CEILING EMERGENCY LIGHT INOP. (<P>REMOVED AND REPLACED LAMP. OPS CHECK NORMAL IAW AMM 33-51-00.</P>)SDR UIEA2019052104251Battery Pack · dischargedDOOR 4 GALLEY BOTH SIDE EXIT SIGN INOP. (<P>REMOVED AND REPLACED DOOR 4 GALLEY EXIT SIGN BATTERY PACK. OPERATIONAL TEST RESULT NORMAL AS PER AMM 33-51-00.</P>)SDR DALA2019052203137Lens · looseDOOR 3R EMERGENCY EXIT COVER DIFFUSER LENS LOOSE. SECURED COVER DIFFUSER LENS. LP 1085127SDR AALA201905229009Light · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT EMERGENCY LIGHT AT ROW AT 3L DOOR INOPERATIVE. MAINTENANCE REPLACED LIGHT PER CMM 25-33-55.SDR AALA201905229004Light · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 1C EMERGENCY ROW LIGHT BROKEN. MAINTENANCE REPLACED SEAT LIGHT PER STANDARD PRACTICES.SDR SIMA20190521001Light · inoperativeLT OVERWING EMERGENCY LIGHT INOP. C/A-RAR LT OVERWING EMERGENCY LIGHT LAMP IAW AMM 33-50-10. OPS CHECK GOOD, NO FURTHER DEFECTS NOTED.SDR MASA2019052111868Light · inoperativeROW 14DF FLOOR EMER LIGHT 1 BULB INOP. PLACED ON MEL.SDR MASA2019052111867Light · inoperativeROW 14AC FLOOR EMER LT 2 BULBS INOP. PLACED ON MEL.SDR MASA2019052111866Light · inoperativeROW 14 EMERG EXIT SIGN 1 BULB INOP. RELAMPED.SDR ASAA2019052029427Light · defectiveF/A REPORT LIGHT COVER FELL OFF NEAR AFT LEFT LAV BETWEEN JUMPSEAT/LAV. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY ON LT AFT LAV. OPS CHECK GOOD. THIS CLEARS PLT DEFERRAL.SDR DALA2019052103174Cradle · defectiveSHIP 6817 INFLIGHT EMERGENCY LIGHT ILLUMINATED IN MID CABIN SECTION (ECONOMY COMFORT) FOR ABOUT 3 MINUTES, THEN EXTINGUISHED. NO INDICATIONS OF EMERGENCY LIGHT UNARMED. TURNING ALL LIGHT ON AT F/A SWITCHES TURNED ALL LIGHTS ON BUT NOT OFF. SAME FROM COCKPIT. CSDR DALA2019052103161Light · inoperativeONE OVERWING EXIT HANDLE LIGHT INOP, R/R LIGHT ASSY.SDR SWAA2019052332942Spring · brokenAFT FLIGHT ATTENDANT SEAT CONTROL PANEL EMERGENCY LIGHT SWITCH COVER SPRING BROKEN. R&R SPRING PER SIP.SDR SWAA2019052332925Sign · unsecureLT EXIT ROW SIGN FELL OFF. REATTACHED SIGN PER SIP.SDR SWAA2019052332923Sign · looseMID CABIN EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER SIP.SDR AALA201905219006Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY LIGHT BATTERY TEST FAILED 10WL, 14WL, AND 13WL. REPLACED EMERGENCY LIGHT POWER SUPPLY AT 13WL AND BATTERIES AT 10WL AND 15WL IAW AMM 33-51-38. (SEE SDR # AALA201905229027 & AALA201905229026).SDR AALA201905229026Battery · dischargedAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY LIGHT BATTERY TEST FAILED 10WL, 14WL, AND 13WL. REPLACED EMERGENCY LIGHT POWER SUPPLY AT 13WL AND BATTERIES AT 10WL AND 15WL IAW AMM 33-51-38. (SEE SDR # AALA201905229027 & AALA201905219006).SDR AALA201905229027Battery · dischargedAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY LIGHT BATTERY TEST FAILED 10WL, 14WL, AND 13WL. REPLACED EMERGENCY LIGHT POWER SUPPLY AT 13WL AND BATTERIES AT 10WL AND 15WL IAW AMM 33-51-38. (SEE SDR # AALA201905219006 & AALA201905229026).SDR AALA201905219013Power Supply · faultedAIRCRAFT WAS GROUNDED: EMERGENCY POWER SUPPLY UNIT LEFT FAULT. MAINTENANCE REPLACED POWER SUPPLY UNIT PER AMM 33-51-38.SDR IPXA2019052142318Power Supply · faultedINSPECTION TYPE:NA EMERG BATT & LO MSG DURING TEST. REPLACED EMERG BATT POWER SUPPLY PER MM 33-51-01. OPS CHK GOOD PER TASK 33-51-01. OPS CHK GOOD PER TASK 33-51-01-700-802. IPC 33-51-01-05.SDR AALA201905219014Battery Pack · faultedAIRCRAFT WAS NOT GROUNDED: EPSU BATTERY FORWARD LEFT FAULT. MAINTENANCE REPLACED FORWARD LEFT EMERGENCY LIGHT BATTERY PACK PER AMM 33-51-38.SDR HALA2019052100251Battery Pack · dischargedON OVERNIGHT CHECK, GWD OVERHEAD EMERGENCY LIGHTS INOP. REMOVED AND REPLACED EMERGENCY BATTERY PACK AT ROW 7 ER AMM 33-51-03. OPS CHECK GOOD. OK FOR SVC.SDR MASA2019052011864Unknown · malfunctionedEXIT ROW 13 BOTH SIDES EXIT LIGHTS INOP. CNDSDR MASA2019052011861Battery · dischargedFWD FA FLASHLIGHT INOP. REPLACED BATTERY.SDR MASA2019052011860Battery · dischargedROW 13 AND 14 EMERG EXIT SIGNS INOP. ALLOWED BATTERIES TO CHARGE WITH CREW. OPS NORMAL. NFAR.SDR SWAA2019052132891Light · inoperativeAFT RT FUSELAGE EMERGENCY LIGHT INOP. RELAMPED AFT RT FUSELAGE EMERGENCY LIGHT IAW AMM.SDR SWAA2019052132890Terminal · dirtyUNDER WING EMER LIGHT ON RT SIDE INOP. FOUND TERMINAL TO BULB DIRTY. CLEANED CONTACT OP CK GOOD. PER AMM.SDR SWAA2019052132884Lens · missingLT MAIN CABIN DOOR EMERGENCY EXIT SIGN (LOWER) LIGHT COVER MISSING. INSTALLED LENS COVER IAW AMMSDR IPXA2019052042273Sign · inoperativeINSPECTION TYPE:NA EMERGENCY EXIT SIGN ABOVE L1 DOOR INOP. R&R DOOR SIGN MODULE IAW AMM 33-51-13/0401. REPAIRED WIRING TO DOOR SIGN IAW ESPM 20-33-00/201 CONFIG 01. OPS CKS GOOD. EFF SOURCE REF: IPC 33-51-04-09B.SDR VNAA2019051911101Battery Pack · dischargedEMERGENCY LIGHTS FLASH THEN DIM WHEN SELECTED ON. R/R #2 BATTERY PACK IAW AMM 33-51-17-000/400-801. OPS CK GOOD.SDR SWAA2019052433015Battery Pack · dischargedEMERGENCY LIGHTS CONTROLLED BY BATTERY PACK M1670 INOP. REMOVED AND INSTALLED BATTERY PACK M1670 IAW AMM.SDR DALA2019052103160Light · inoperativeSHIP 6701 SEAT 38D EMERGENCY LIGHT INOP. CORRECTIVE ACTION: RPLD LIGHT ASSY AT 38D PER AMM 33-51. (5421780)SDR DALA2019052003158Light · inoperativeSHIP 6704 ROW 33 SEAT EMER LIGHT INOP. CORRECTIVE ACTION: FOUND SEAT LIGHT ASSY OPEN. REMOVED/REPLACED LIGHT ASSY. (5442672)SDR JJBA20190519009Light · inoperativeSERVICE DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LIGHT BULB. OPS CHECK SAT.SDR SWAA2019052332937Lens · crackedLT OVERWING ESCAPE LIGHT LENS CRACKED. R&R LENS IAW SRM.SDR CALA2019052000797Epsu · faultyMIDDLE OVERHEAD EMERGENCY LIGHT INTERMITTENTLY TURNS ON UNCOMMAN DED A3NB-33-3-6012 PER NR 9290608 T/S MIDDLE OVERHEAD EMERGENCY LIGHTS AND FOUND LT EPSU (11WL) TO BE BAD REMOVED AND REPLACED LT EPSU (11WL) IAW AMM 33-51-34-000-001-A AND 33-51-38-400-001-A OP SDR ASAA2019051929406Lens · unsecureEXIT SIGN FELL OFF AT ROW 16 CENTER AISLE. GROUNDED - YES. REINSTALLED COVER ASSY OK FOR SERVICE.SDR SWAA2019052132903Light · inoperativeLT OVERWING ESCAPE HATCH EXTERNAL EMERGENCY LIGHT IS INOP. REPLACED LT OVERWING ESCAPE HATCH EXTERNAL EMERGENCY LIGHT IAW AMM 3.SDR SWAA2019052132888Light · inoperativeEMERGENCY LIGHT AFT OF RIGHT WING INOP. RELAMPED EMERGENCY LIGHT AFT OF RIGHT WING IAW AMM.SDR DALA2019052003101Light · cracked(LOG 1081766) DURING INSPECTION FOUND CRACK GALLEY 1 AND 4 EMERGENCY LIGHT ASSY AT FWD GALLEY AREA. REPLACED LIGHT ASSY EMERGENCY AT GALLEY 1 AND 4 AT FWD GALLEY AREA (2E/A) ASPER DWG BR2800-737-8-DL-UKA REV.R AND PERFORMED OPERATIONAL TEST EMERGENCY LIGHT ASPSDR SIMA20190519001Light · inoperativeMOST AFT EMERGENCY LIGHT STRIP INOP. C/A-REMOVED AND REPLACED AFT FLOOR PROXIMITY LIGHT IAW AMM 33-50-12. OPC IS GOOD.SDR SIMA20190519002Light · inoperativeWING TO FUSELAGE EMERG LIGHT LT AFT INOP. C/A-WING TO FUSELAGE LT AFT EMERG LIGHT RELAMPED IAW AMM 33-50-10 OPC GOOD.SDR SIMA20190519004Light · inoperativeAFT AISLE EMERGENCY LIGHT INOP. C/A-AFT AISLE EMERGENCY LIGHT BULB REPLACED IAW AMM 33-50-08. LIGHTING TEST GOOD.SDR SIMA20190519003Inverter · inoperativeAFT 3 EMERGENCY FLOOR STRIPS INOP. C/A-REMOVED AND REPLACED NR 6 INVERTER IAW AMM 33-50-11 OPS CHECK GOOD.SDR SWAA2019052032875Power Supply · inoperativeL2 DOOR EMERGENCY LIGHT WILL NOT TURN ON. R&R POWER SUPPLY PER AMM.SDR SWAA2019052032860Light · inoperativeRT AREA EMERGENCY LIGHT INOP AT ROW 8. RELAMPED LIGHT PER AMM.
Back to JASC 3350