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 SIMA202001132004Battery Pack · inoperativeAFT OVERWING EMERGENCY LIGHTS INOP-C/A-REMOVED AND REPLACED #4 EMERGENCY BATTERY AND CHARGER IAW EMB 145 AMM 33-50-04 OPC GOOD. BATTERY CHARGER ASSY P/N 11-0049 S/N 11448 / +SDR Q2SA202001132424Light · inoperativeAIRCRAFT GROUNDED. EXTERNAL EMER LIGHTS NOT WORKING AT DOORS 1R AND 1L. EXTERNAL EMERGENCY LIGHT BULBS REPLACED AND TEST OK IAW AMM 33-51-04-960-801.SDR HNAA2020011300015Battery Pack · inoperativeMAINTENANCE FOUND FWD EMERGENCY LIGHTS INOP. MAINTENANCE REMOVED AND REPLACED #200 EMERGENCY BATTERY AND POWERSUPPLY IN REFERANCE TO W/C 33-70-19. OPTS CHECK GOOD. OK FOR SERVICE.SDR MASA2020011200018Light · inoperativeROW 21 EMER CEILING LT INOP. PLACED ON MEL.SDR AALA2020011100000Charger · inoperativeR/H FIRST CLASS SEAT EMERGENCY LIGHTS INOP. REMOVED AND REPLACED CHARGER AND BATTERY IAW MM 33-51-00. OPS CHECK GOOD.SDR DALA2020011200204Light · malfunctionedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:602 / ACARS TEXT: FRC335201602 EMERG LIGHTS FIRST CLASS CABIN COME ON INT FOR ABOUT 10 SECONDS THEN TURN OFF / INTERIOR. PULLED AND RESET C/B Z37 AND A14.TESTED EMERGENCY LTS PER AMM 33-53.OPS CHECK NSDR AALA2020011539026Light · faultyAIRCRAFT WAS NOT GROUNDED: EMERGENCY CEILING LIGHTS AT ROW 17 AND 21 AREA DIM. MAINTENANCE TROUBLESHOT EMERGENCY CEILING LIGHTS AND REPLACED LIGHTS PER AMM 33-50-01.SDR DALA2020011500315Housing · brokenSHIP 3843 SEAT 37D EMERGENCY LIGHT HOUSING BROKEN. CORRECTIVE ACTION: REPLACED DAMAGED EMERGENCY LIGHT HOUSING AT SEAT 37D. OK FOR SVC. REMOVED AND MEL CLEARED.SDR DALA2020011400271Battery Pack · discharged5 BATTERY PACKS DID NOT ILLUMINATE THEIR GROUP OF EMERGENCY LIGHT FOR 15 MIN PER JOB CARD 3351-7004. CORRECTIVE ACTION: R/R'D BATTERY PACKS PER AMM 33-51.SDR DALA2020011300236Battery · dischargedTHE LT AND RT OVERWING EXIT IDENTIFIER SIGNS ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY/ POWER PACK IAW AMM 33-51. OPERATIONAL CHECKS ARE NORMAL.SDR WX0A2020011373456Light · unsecureFA REPORTS ESCAPE PATH LIGHTING ON FLOOR MID A/C EXITS CAME OFF. RE-SECURED ESCAPE STRIP LIGHTING ON MID FLOOR A/C EXITS IAW AMM 25-60-00.SDR SWAA2020011340406Cover · missingCAPTAIN SIDE "EXIT" SIGN COVER MISSING AT ROW 15. / INSTALLED COVER PER AMM.SDR SIMA202001131003Lamp · inoperativeRH EXTERNAL OVERWING EMERGENCY LIGHT FAILS TO ILLUMINATE.-C/A-REMOVED AND REPLACED RH OVER WING EMERGENCY LIGHT LAMP IAW AMM 33-50-01. OPS CHECK GOOD, NO FURTHER DEFECTS NOTED.SDR SIMA202001131001Inverter · inoperativeEMERG LITE AT ROW 3 INOP-C/A-REMOVED AND REPLACED AC-DC EMERG INVERTER IAW 33-50-11 OPS CK GOODSDR SIMA202001131002Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT IAW AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPC GOOD. NO FURTHER DEFECTS NOTED. END.SDR DALA2020011300227Cover · missing(LOG 6335378) DURING INSPECTION FOUND EXIT PLACARD BY 1R DOOR MISSING. R/R EMERGENCY LT COVER AT 1R PER B737 AMM 33-51. OPS CHECK NORMAL.SDR CALA2020011300144Charger · inoperativeEMERGENCY ESCAPE PATH AISLE LIGHTING IS INOPERATIVE FROM SEAT 07C TO 20C. FOUND BATTERY PACK POWER SUPPLY INOPERATIVE FOR LEFT SEAT SECTION ROW 07 TO 20. REPLACED POWER SUPPLY BATTERY CHARGER ASSY PER AMM 33-51-07-862-054. OPS CHECK OF EMERGENCY LIGHTS NOW NSDR DALA2020012213462Lens · unsecureFLOOR EMERGENCY LIGHT LENS UNSECURE. INSTALLED THE LIGHT LENS. OK FOR SERVICE.SDR DALA2020012213461Lens · detachedFLOOR EMERGENCY LIGHT LENS DETACHED. INSTALLED THE LIGHT LENS. OK FOR SERVICE.SDR N6WA20200114001Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 12 INOP. DEFERRED ROW 12 OVERHEAD EMERGENCY LIGHT ON OPEN CONTROL 70066277 PER MEL 33-51-01B-2A CAT C. AUTHORIZED BY MXCSDR SWAA2020011340437Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. / R&R BATTERY PER AMM.SDR SWAA2020011340436Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. / R&R BATTERY PER AMM.SDR SWAA2020011340435Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. / R&R BATTERY PER AMM.SDR SWAA2020011340434Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. / R&R BATTERY PER AMM.SDR SWAA2020011340433Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. / R&R BATTERY PER AMM.SDR SWAA2020011340432Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1671. / R&R BATTERY PER AMM.SDR SWAA2020011340386Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. / R&R BATTERY PER AMM.SDR SWAA2020011340351Light · inoperativeL2 DOOR EMERGENCY LIGHT INOP EXTERIOR. / RELAMPED LIGHT PER AMM.SDR SIMA202001130004Lamp · inoperativeLH OVERWING INSPECTION LIGHT INOP-C/A-REMOVED AND REPLACED LH OVERWING INSPECTION LIGHT LAMP IAW EMB AMM 33-44-02-000-801-A AND 33-44-02-400-801-A. OPS CHECK GOOD. END.SDR SIMA202001130003Charger · inoperativeBATTERY POWER SUPPLY #2 INOP-C/A-REMOVED AND REPLACED #2 BATTERY POWER SUPPLY IAW EMB 140AMM 33-5-04. OPPS CHECK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1ASMI S/N 68789SDR SIMA202001130002Battery Pack · inoperativeBATTERY POWER SUPPLY #1 INOP-C/A-REMOVED AND REPLACED BATTERY POWER SUPPLY IAW EMB 140 AMM 33-50-04. BATTERY CHARGER ASSY P/N 11-0049 S/N 17495SDR DALA2020011300226Lens · missing(LOG 6451952) DURING INSPECTION FOUND CENTER EXIT SIGN MISSING AT ROW 22. INSTALLED SERVICEABLE EMERGENCY EXIT SIGN LENS AT ROW 22. OPS CHECK OK.SDR MASA2020011100016Light · missingRH O-WING EMER EXIT SIGN MISSING 1 BULB. RELAMPED LTS.SDR MASA2020011100015Light · inoperativeEMER EXIT SIGN AT PAX DOOR ONE BULB INOP RELAMPED LTSSDR MASA2020011100014Light · inoperative14 AC EMERG EXIT SIGN 2 BULBS INOP PLACED ON MELSDR DALA2020011000185Battery · discharged(LOG 6472064) DURING INSPECTION FOUND EMERG. PATH LIGHTS AFT RT SECTION OF A/C INOPERATIVE. REMOVED & REPLACED LIGHTING PATH BATTERY & FUSES FOR BACK RT SIDE OF A/C AMM 33-51. OPS CK NORMAL.SDR DALA2020011000184Battery · dischargedTHE CEILING PANELS 1-8, 11-13, AND OVERWING EXIT EMERGENCY LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERIES AT B5-227, B5-120, B5-231, AND REPLACED THE POWER SUPPLY UNIT B5 -227 REF B717 AMM 33-51. OPERATIONAL CHECK IS GOOD. (LP #6727999)SDR FDEA202001100107Unknown · malfunctionedEMERGENCY LIGHT TEST FAIL ON POST FLIGHT. PERFORMED ADJUSTMENT/TEST OF EMERGENCY LIGHTING. EMERGENCY LIGHTING PASSED MULTIPLE TIMES(3) WITH NO FAULTS. REF AMM 33-50-00-5. OK FOR SERVICE.SDR MASA2020011000013Battery Pack · dischargedALL EMERG LIGHTS INOP. CHARGED BATTERIESSDR MASA2020040212217Light · inoperativeSVC DOOR EMER LIGHTS INOP 3 OUT OF 5 BULBS- RELAMPED SVC DOOR EMER LT. OPS TEST GOODSDR SWAA2020011340431Battery · dischargedFORWARD L/H GALLEY EMERGENCY LIGHT BATTERY INOP. / R&R BATTERY PER AMM.SDR SWAA2020011340375Charger · inoperativeFORWARD L/H GALLEY EMERGENCY LIGHT CHARGER INOP. / R&R CHARGER PER AMM.SDR SWAA2020011340332Sign · looseFORWARD ENTRY DOOR EMERGENCY EXIT SIGN LOOSE. / SECURED SIGN IAW SIP.SDR AALA202001109001Light · inoperativeAIRCRAFT WAS NOT GROUNDED: R2 DOOR EXTERIOR SLIDE LIGHT INOPERABLE. MAINTENANCE RELAMPED SLIDE LIGHT PER AMM 33-51-06.SDR SIMA202001109002Battery Pack · inoperativeLH AND RH EXTERNAL OVERWING EMERGENCY LIGHTS INOP-C/A-#4 BATTERY POWER SUPPLY REMOVED AND REPLACED IAW EMB 140 AMM 33-50-04. OPS CHK GOOD. CHARGER ASSY BATTERY P/N BA5-0933-901 S/N C02369SDR SIMA202001109004Light · inoperativeLH EXTERNAL CENTER FAIRING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED LH EXTERNAL CENTER FAIRING EMERGENCY LIGHT IAW EMB 145 AMM 33-50-10. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED.SDR SIMA202001109003Light · inoperativeMAIN DOOR OVERHEAD EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED MAIN DOOR OVERHEAD EMERGENCY LIGHT IAW AMM TASK 33-50-06-000-801-A AND 33-50-06-400-801-A. OPC GOOD. END.SDR AALA202001109004Light · brokenAIRCRAFT NOT GROUNDED: EMERGENCY EXIT LT BROKEN AT L-4 DOOR. REMOVED AND REPLACED L-4 DOOR EMER EXIT LIGHT ASSY IAW AMM 33-50-00.SDR AALA202001109005Light · brokenAIRCRAFT NOT GROUNDED: EMERGNCY EXIT LIGHT BROKEN AT R-4 DOOR. REMOVED AND REPLACED R-4 DOOR EMERGY LIGHT ASSY IAW AMM 33-50-00.SDR QXEA2020011000021Light · inoperativePHOTOLUMINESCENT LIGHT INOP ON FLOOR NEAR 2A AND 1C ( PHOTOLUMINESCENT ESCAPE ROUTE MARKING SYSTEM ).
Back to JASC 3350