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 SWAA2019082766249Lamp · inoperativeL/H EMERGENCY EXIT LIGHT #3 INOP. RELAMPED LIGHT IAW AMM.SDR ASAA2019082643479Bulb · inoperativeR/H AFT OVERWING EXIT, FWD EMERGENCY LIGHT BULB INOP. GROUNDED - YES. RELAMPED. OPS CHECK GOOD PER B737-800 AMM 33-51-01.SDR ASAA2019082643478Lens · missingRIGHT FWD OVERWING, EXIT SIGN LENS MISSING. GROUNDED - YES. REPLACED LENS IAW B737-800 AMM 33-51-01.SDR ASAA2019082643474Sign · detachedFA REPORTS FWD GALLEY EXIT SIGN IS FALLING DOWN. GROUNDED - YES. SECURED PANEL FWD GALLEY ABOVE CABIN DOOR OPS GOOD.SDR SIMA201908264002Inverter · inoperativeDURING PS-2 FOUND EMERGENCY EXIT LOCATING SIGN INOP-C/A-REMOVED AND REPLACED # 1 INVERTER IAW 145 AMM 33-50-11 OPS CHECK GOOD NO FURTHER DEFECTS NOTEDSDR DALA2019082654956Charger · inoperativeTHE EMERGENCY LIGHT BATTERY CHARGER AT 25E WENT INOPERATIVE. MAINTENANCE REPLACED THE BATTERY CHARGER IAW B717 AMM 33-51. OPERATIONAL CHECK IS GOOD. (LP #6141432)SDR SWAA2019082936426Light · inoperativeAFT ENTRY EMERGENCY EXIT LIGHT MODULE INOP. R&R LIGHT IAW WDM & AMM.SDR DALA2019082604981Battery Pack · dischargedMULTIPLE EMERGENCY LIGHTS INOP. INTERIOR AND EXTERIOR. FOUND BATTERIES DRAIN ON EMERGENCY LIGHTS. CHARGED BATTERIES. OPS CK EMERGENCY LIGHTS PER 757 AMM 33-57. OPS CK OK. (1237020)SDR SWAA2019082766325Battery Pack · inoperativeR1 DOOR EMERGENCY EXIT SIDE LIGHT INOP AT M1674. R&R BATTERY PACK IAW AMM.SDR SWAA2019082766274Light · missingL/H OVERHEAD BIN EMERGENCY LIGHT LENS MISSING AT ROW 1. INSTALLED LIGHT IAW AMM.SDR SWAA2019082766252Lamp · inoperativeR2 EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SIMA201908263003Light · inoperativeRH WING FWD EMERGENCY LIGHT INOP. REMOVED AND REPLACED RH FWD EMERGENCY LIGHT IAW AMM 33-50-10-000-801-A AND 33-50-10-400-801-A OPC GOODSDR SWAA2019082636236Sign · looseOVERWING EXIT SIGN LOOSE. / INSTALLED SIGN IAW AMM.SDR SWAA2019082636223Cover · missingPLASTIC SIGN COVER EMERGENCY EXIT AT OVERWING FELL OFF. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2019082636222Cover · missingPLASTIC SIGN COVER EMERGENCY EXIT AT OVERWING FELL OFF. / R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2019082636221Lamp · inoperativeR2 DOOR EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR HNAA2019082600237Light · inoperativeRT OVERWING EMERGENCY LIGHT DOES NOT ILLUMINATE. REPLACED OVERWING EMERGENCY LIGHT ASSY IAW AMM 33-50-10-000/400-801-A. OPS CHECK GOODSDR DALA2019082404947Cids · malfunctionedEMERGENCY LIGHTS ON LEFT SIDE OF FIRST CLASS CABIN CONTINUOUSLY ON. CYCLING EMERGENCY EXIT LIGHT SWITCH HAD NO EFFECT. RESET NBR 1 AND 2 CIDS.SDR DALA2019082875032Lens · crackedRED LENS COVER CRACKED FOR EMERGENCY LIGHT FORWARD ENTRY RIGHT LOWER CLOSET, REPLACED MISSING LENS COVERSDR DALA2019082805031Lens · damagedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED 1C, REPLACED LENS.SDR SWAA2019082736337Battery Pack · dischargedR/H EXTERIOR EMERGENCY LIGHTS AT POSITION AFT OF R/H WING OT BODY FAIRING INOP. RECHARGED BATTERY PACK PER AMM.SDR SWAA2019082736336Battery Pack · dischargedR/H EXTERIOR EMERGENCY LIGHTS AT POSITION R2 DOOR INOP. RECHARGED BATTERY PACK PER AMM.SDR SWAA2019082736293Battery Pack · inoperativeR/H EXTERIOR EMERGENCY LIGHTS AT POSITION R/H OVERWING INOP. RECHARGED BATTERY PACK PER AMM.SDR SWAA2019082736335Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2019082736334Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2019082766304Bulb · inoperativeFORWARD RT AREA LIGHT BELOW OVERHEAD BIN INTERIOR EMERGENCY LIGHT INOP. R&R BULB PER AMM.SDR SWAA2019082766303Bulb · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOP. R&R BULB PER AMM.SDR SWAA2019082736277Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PER AMM.SDR ASAA2019082623488Lens · detachedEMERGENCY EXIT SIGN, CEILING, ROW 17 CAME OFF. GROUNDED - YES. INSTALLED EMERGENCY EXIT SIGN LENS, CEILING, ROW 17 REF B737-800 AMM 33-51-01.SDR ASAA2019082623462Battery Pack · dischargedEMERGENCY LIGHT SIGNS AT L2 DOOR AREA ARE INOP. GROUNDED - YES. REMOVED AND REPLACED PERFORMED SUCCESSFUL SYSTEM OP CHECK ON EMERGENCY POWER SUPPLY M1673 IAW B737NG AMM 33-31-06-960-805.SDR ASAA2019082623461Power Supply · inoperativeEMERGENCY LIGHT SIGNS AR R1 DOOR AREA ARE INOP. GROUNDED - YES. REMOVED & REPLACED EMER, LIGHT PWR SUPPLY M1674, OPS CHECKS GOOD ALL R1 LIGHTS IAW 737NG AMM 33-51-06-960-805.SDR ASAA2019082623460Power Supply · inoperativeEMERGENCY LIGHT SIGNS AR R1 DOOR AREA ARE INOP. GROUNDED - YES. REMOVED & REPLACED EMER, LIGHT PWR SUPPLY M1674, OPS CHECKS GOOD ALL R1 LIGHTS IAW 737NG AMM 33-51-06-960-805.SDR ASAA2019082623459Battery Pack · failedEXTERIOR EMERGENCY LIGHT AT LH FWD OVERWING DOOR AREA IS INOP. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK IAW B737-NG AMM 33-51-06-960-805. OPS CHECK GOOD.SDR DALA2019082654972Sign · missingL1 EXIT SIGN GREEN RUNNING MAN MISSING P/N 90WL1, REPLACED L1 DOOR EXIT SIGN COVER.SDR SWAA201908266209Cover · missingPLASTIC SIGN COVER EMERGENCY EXIT AT OVERWING FELL OFF. R&R LIGHT ASSEMBLY IAW AMM.SDR ASAA201908230448Battery Pack · faultedEMERGENCY EXIT O/W LIGHTS OUT GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK AND CHARGER.SDR ASAA201908230447Power Supply · inoperativeEMERGENCY LIGHT SIGN AT R1 DOOR AREA INOP GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY M1674 S/N 36074, OPS CHECKED GOOD ALL R1 LIGHTS IAW B737-800 AMM 33-51-06-960-805.SDR ASAA201908230446Battery Pack · inoperativeEMERGENCY LIGHT SIGN AT L2 DOOR AREA INOP. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY M1673 S/N 66253. PERFORMED SUCCESSFUL OP CHECK ON EMERGENCY POWER SUPPLY M1673 IAW B737-800 AMM 33-51-06-960-805.SDR FDEA2019082322002Light · inoperativeSLIDE LIGHT ABOVE R1 DOOR DOES NOT ILLUMINATE WITH SLIDE ARMED. R1 DOOR ESCAPE SLIDE FLOOR RETAINER CLEANED AND TESTED IAW AMM 25-66-01 .OK.SDR AALA201908239036Light · inoperativeAIRCRAFT WAS NOT GROUNDED: INOPERATIVE FORWARD EMERGENCY LIGHT. OPENSDR DALA2019082304934Lens · unsecureEMERGENCY EXIT COVER DIFFUSER LENS IS LOOSE. RE-SECURED EXIT LIGHT COVER.SDR CALA2019082301422Sign · damagedDOOR 2R SMALL EMER EXIT SIGN ON AFT GALLEY COFFEE STAINED. REMOVED COFFEE SOAKED EXIT INDICATOR AND INSTALLED NEW ASSY. OPS CKECKED GOOD. ACP IDT INSP OF DR 2R EMER EXIT SIGN REMOVED AND CLEANED. REF GMM 09-10-05. OPS CK GOOD.SDR CALA2019082301419Lamp · inoperativeDOOR 3 LEFT, EMERGENCY LIGHT INOP. RELAMPED AND PERFOMED EMERGENCY LT. OPS TEST AS DESCRIBED IN 2SVC, LT. TESTED GOOD.SDR CALA2019082301417Lamp · inoperativeSEAT 20 AND 21 ABC FLOOR PROXIMITY LIGHT INOP. RELAMPED, REF AMM 33-51-11-960-801, OPS CHECKED OK. ACP IDT INSP OF RELAMPING OF FLOOR PROXIMITY LT AT SEAT 20 ABC AND 21 ABC. REF GMM 09-10-05 AND AMM 33-51-11-960-801, OPS CK GOOD.SDR CALA2019082301416Battery Pack · inoperativeEMERGENCY OVERWING EXIT LIGHTS INOP. REPLACED BATTERY PACK EMER PWR AND OPS CHECK GOOD, REF AMM 33-51-06-960-805. ACCOMPLISHED THE INSPECTION OF OVERWING EMERGENCY EXIT LIGHTS OPERATION. REF AMM 33-51-06-960-805.SDR HNAA2019082300235Control Module · malfunctionedEMERGENCY LIGHT NOT ARMED, EICAS MESSAGE DISPLAYED. REMOVED AND REPLACED CONTROL MODULE ASSY IAW AMM 33-21-01 SUBTASK 33-25-00-700-801-A AND 33-50-00-700-801-A. OPS CHECK GOOD,OK FOR SERVICESDR HNAA2019082300234Light · inoperativeEMERGENCY PATH LIGHT SECTION 7 INOP. R&R EMERGENCY PATH LIGHT SECTION 7 IAW AMM 33-50-12-04. OPS CHECK GOODSDR R61A201908220863Power Supply · inoperative#1 AND #3 FROM FRONT EMERGENCY LIGHTS ARE OUT. R&R ELPU #2 IAW AMM 33-50-01, OPS CHECK GOOD.SDR DALA2019082805033Lens · missingGALLEY CLOSET SIDE WALL EMER. LIGHT MISSING COVER, REPLACED FWD GALLEY CLOSET WALL EMERGENCY LIGHT COVERSDR SWAA2019082766332Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED AT M1669. R&R BATTERY PACK PER AMM.
Back to JASC 3350