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 SIMA20180116003Battery Pack · failedFLOOR EMERGENCY LIGHTS FROM ROW 1 TO ROW 7 INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW 33-50-04. AND PERFORMED AN OPS CHECK IAW WC 33-700-17. OPS CHECKED GOOD.SDR N6WA2018011601Light · inoperativeFORWARD AISLE FLOOR EMERGENCY LIGHT INOPERATIVE.SDR AALA201801199019Lens · brokenEMERGENCY LIGHT COVER AT FOWARD ENTRANCE FELL OFF AND WAS BROKEN. MAINTENANCE REPLACED FORWARD ENTRY THRESHOLD LIGHT ASSEMBLY, AND PERFORMED A SATISFACTORY OPS CHECK IAW MM 33-29-00-960-803.SDR AALA201801229014Lens · missingEMERGENCY LIGHT ON SEAT 14D, THE LENS WAS MISSING. INSTALLED THE LENS. AIRCRAFT WAS GROUNDED.SDR AALA201801199007Sign · missingEXIT SIGN AT FWD ENTRY SERVICE DOOR IS MISSING. REPLACED EMERGENCY EXIT SIGN IAW MM 33-51-02.SDR AALA201801199034Light · inoperativeEMERGENCY LIGHTS OUT AT SEATS 21D, 22D, AND 25D. MAINTENANCE REPLACED THE EMERGENCY LIGHTS. PERFORMED A SATISFACTORY OPS CHECK.SDR AALA201801199033Light · inoperativeEMERGENCY LIGHTS OUT AT SEATS 21D, 22D, AND 25D. MAINTENANCE REPLACED THE EMERGENCY LIGHTS. PERFORMED A SATISFACTORY OPS CHECK.SDR AALA201801199020Lens · missingLIGHT LENS BELOW THE FORWARD ENTRY DOOR EXIT LIGHT MISSING. MAINTENANCE REPLACED THE LENS. PERFORMED A SATISFACTORY OPS CHECK.SDR AALA201801169021Light · inoperativeEMERGENCY LIGHTS OUT AT SEATS 21D, 22D, AND 25D. MAINTENANCE REPLACED EMERGENCY LIGHTS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201801189021Battery · inoperativeFOUND FAULT MESSAGE BAT/EPSU 15WL ON MCDU WHEN PERFORMING EMERGENCY BATTERY OPERATIONS TEST. REPLACED EMERGENCY BATTERY AT DOOR 2L PER AMM 33-51-38.SDR DALA2018011700309Bracket · detachedSEAT 39D EMERGENCY LIGHT BRACKET DANGLING BELOW SEAT. ATTACHED THE EMERGENCY LIGHT TO THE SEAT.SDR DALA2018011700292Light · out of positionEXTERIOR EMERGENCY LIGHTS POS R1 AND R2 INOP. FOUND LOOSE CONNECTION AND REPOSITIONED BULBS AND CKD OK PER AMM 33-51.SDR SWAA2018011819146Cover · looseRT OVERWING BULKHEAD EXIT LIGHT COVER LOOSE. SECURED COVER PER SIP.SDR SWAA2018011819145Lens · detachedR1 FORWARD SIDEWALL EXIT LIGHT LENS DETACHED. SECURED LENS PER EA.SDR SWAA2018011819140Lens · brokenR2 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. R&R LIGHT ASSEMBLY PER MM.SDR UIEA2018011700083Lens · missingRT ISLE OVERHEAD EMERGENCY LIGHT LENS MISSING AT ROW 12. INSTALLED THE LENS IAW AMM 33-21-00.SDR ASAA2018011523179Lens · detachedEMERGENCY EXIT SIGN LENS FELL OFF IN THE AFT GALLEY, RIGHT SIDE. ACFT GROUNDED. INSTALLED A NEW SIGN LENS ASSY IAW AMM 33-51-01.SDR AALA201801169041Shroud · damagedROW 20C EMERGENCY LIGHT SHROUD DAMAGED. REPLACED THE EMERGENCY LIGHT SHROUD.SDR AALA201801169040Shroud · damagedROW 18C EMERGENCY LIGHT SHROUD DAMAGED. REPLACED THE EMERGENCY LIGHT SHROUD.SDR AALA201801169004Shroud · damagedROW 15C EMERGENCY LIGHT SHROUD DAMAGED. REPLACED EMERGENCY LIGHT SHROUD.SDR AALA201801169032Battery Pack · inoperativeR4 DOOR, FORWARD CIDS PANEL INDICATED CHECK SLIDE PRESSURE. REMOVED AND REPLACED THE SLIDE IAW JC 26L00025010 AND REPLACED THE L1 EMERGENCY LIGHT BATTERY PACK IAW MM 33-51-38. SYSTEM CHECKED GOOD.SDR AALA201801169031Cap · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT CAP AT 9D IS BROKEN OFF AND MISSING. REMOVED AND REPLACED EMERGENCY LIGHT SEAT 9D. OPERATIONS CHECK GOOD.SDR SIMA20180115004Bulb · inoperativeRIGHT OVERWING FWD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-50-10. OPS CHECKED GOOD.SDR AALA201801169003Housing · brokenEMERGENCY LIGHT HOUSING BROKEN. REPLACED THE EMERGENCY LIGHT HOUSING. OPS CHECKED GOOD.SDR N6WA2018011502Light · inoperativeGALLEY EMERGENCY LIGHT INOPERATIVE.SDR N6WA2018011501Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-05, OPS OK.SDR MASA2018011512917Light · unsecureROW 6 OVHD EMER LIGHT INOP. RE-SECURED LAMP.SDR CALA2018011500209Battery · failedLT FWD AND RT MID CABIN EPSU FAILED CAPACITY CHECK. REMOVED AND REPLACED LT FWD AND RT MID CABIN EPSU BATTERIES IAW AMM 33-51-38. PERFORMED EMERGENCY LIGHT CAPACITY CHECK AFTER BATTERY REPLACEMENT. OPS CHECK GOOD.SDR CALA2018011500208Power Supply · faultyEMERGENCY LIGHT TEST FAILS TEST WITH FAULT ESPU "L" REPLACED EPSU AND BATTERY AT 21L. REF TSM TASK 33-51-00-810-801 AND AMM33-51-00-710-001. CKS OK, NO FAULTS PRESENT.SDR CALA2018011500206Sign · looseOVERHEAD EXIT SIGN AFT CABIN IN VICINITY OF LIFE RAFTS LOOSE. SECURED OVERHEAD EXIT SIGN AFT CABIN IN VICINITY OF LIFE RAFTS PER AMM 33-51-02.SDR CALA2018011500205Battery Pack · dischargedROW SEAT 18 & 19ABC PATH LIGHT INOP. REMOVED AND REPLACED EMERGENCY BATTERY PACK IAW AMM 33-51-07.SDR CALA2018011500204Light · inoperativeEMER LIGHTS OVERHEAD CAUTION LIGHT BULB OUT. RELAMPED BOTH BULBS. OPS GOOD.SDR UIEA2018031500415Power Supply · inoperativeFOUND THE POWER SUPPLY FOR THE EMERGENCY LIGHTS M5168, CAPACITY FUNCTION NOT GOOD IAW AMM 33-51-04-002-009-001 & 33-51-04-402-012-001 REV 91. REPLACED EMERGENCY LIGHT POWER SUPPLY M5168 AND CONDITION CHECKED NORMAL. IAW AMM 33-51-021-202-012-001 REV 91. PERSDR SWAA2018020519518Guard · brokenAFT ATTENDANT'S PANEL EMERGENCY LIGHT SWITCH GUARD SPRING BROKEN. R&R SWITCH GUARD IAW AMM.SDR AALA201801189027Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. DOOR R-1 EMERGENCY EXIT LIGHT COVER MISSING. REPLACED R-1 DOOR EMERGENCY LIGHT ASSY. OPS CKS NORM. REF 33-51-01 AMM.SDR AALA201801189031Cover · brokenTHE AIRCRAFT WAS NOT GROUNDED. 20C BULKHEAD EXIT SIGN BROKEN. REPLACED EXIT SIGN COVER AS PER IAW AMM 33-51-09. GOOD FOR SVC.SDR AALA201801189025Battery · dischargedAIRCRAFT WAS NOT GROUNDED: RIGHT OVERWING EMERGENCY EXIT LIGHTS FAULTING (ON). MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT (SEE AALA201801169020) AND BATTERY PER AMM 33-51-38.SDR AALA201801189023Housing · missingAIRCRAFT WAS NOT GROUNDED: 2 EMERGENCY EXIT LIGHTS WERE ORIGINALLY REPORTED TO BE HANGING DOWN ROW 13 AND 14. MAINTENANCE LATER DISCOVERED AND REPLACED EMERGENCY LIGHTING HOUSINGS AT ROWS 13L (SEE AALA201801169017), 14L (SEE AALA201801189022), AND, 15L, AND PSDR AALA201801189022Housing · missingAIRCRAFT WAS NOT GROUNDED: 2 EMERGENCY EXIT LIGHTS WERE ORIGINALLY REPORTED TO BE HANGING DOWN ROW 13 AND 14. MAINTENANCE LATER DISCOVERED AND REPLACED EMERGENCY LIGHTING HOUSINGS AT ROWS 13L (SEE AALA201801169017), 14L, AND, 15L (SEE AALA201801189023), AND PESDR AALA201801169020Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT OVERWING EMERGENCY EXIT LIGHTS FAULTING (ON). MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT AND BATTERY (SEE AALA201801189025) PER AMM 33-51-38.SDR AALA201801169018Battery · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT BATTERY (10WL) WOULD NOT TEST. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY BATTERY (10WL) AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA201801169017Housing · missingAIRCRAFT WAS NOT GROUNDED: 2 EMERGENCY EXIT LIGHTS WERE ORIGINALLY REPORTED TO BE HANGING DOWN ROW 13 AND 14. MAINTENANCE LATER DISCOVERED AND REPLACED EMERGENCY LIGHTING HOUSINGS AT ROWS 13L, 14L (SEE AALA201801189022) , AND, 15L (SEE AALA201801189023), AND PSDR AALA20180115012Battery Pack · faultyTHE AIRCRAFT WAS NOT GROUNDED. FORWARD LEFT AND RIGHT OVERWING EXIT SIGNS WOULD NOT TURN OFF. REMOVED AND REPLACED EMERGENCY BATTERY PACK B5-207 PER AMM 33-53-00. OPERATIONS CHECK GOOD.SDR DALA2018011500282Sign · degradedR1 DOOR EXIT SIGN IN POOR CONDITION. REPLACED THE SIGN.SDR DALA2018011700276Battery Pack · dischargedDURING A SERVICE CHECK, FOUND FOUR EMERGENCY LIGHTS INOPERATIVE IN THE MID CABIN AREA. FOUND THE BATTERY PACK DISCHARGED BELOW SEAT 29DEF. REPLACED THE CHARGER & BATTERY PACK IAW AMM 33-51-07. LIGHTS OPERATE NORMAL.SDR AALA201801169001Battery · inoperativeAFT RT EMERGENCY FLASHLIGHT INOPERATIVE. REPLACED THE BATTERY IN THE FLASHLIGHT. OPS CHECKED GOOD. OK FOR SERVICE.SDR MASA2018011412915Light · inoperativeROW 15 CEILING FLOOD LIGHT INOPERATIVE.SDR CALA2018011400192Power Supply · inoperativeFIRST CLASS CABIN EMERGENCY LIGHTS ARE OUT. REMOVED AND REPLACED THE POWER SUPPLY IAW 33-51-03, OPS CHECKED GOOD.SDR DALA2018011400236Power Supply · inoperativeEMERGENCY LIGHT EPSU 11WL FAULTED, REPLACED THE EPSU.SDR SWAA2018020819563Lens · looseAFT EMERGENCY SIGN LENS FOUND LOOSE AT ROW 15. SECURED THE LENS IAW MM.
Back to JASC 3350