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 DALA2019051603065Light · inoperativeEMERGENCY ESCAPE PATH LIGHT INOP AT 11D. REPL LIGHT ASSY PER AMM 33-53. OPS CHECK GOOD. (LP5504375)SDR ASOA201905165069Sign · inoperativeDURING MX INSPECTION THE EMERGENCY EXIT LIGHT ABOVE FLT ATTENDANT SEAT WILL NOT ILLUMINATE. MX REMOVED AND REPLACED EXIT MARKING SIGN ASSEMBLY WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2019051732784Lens · unsecureEXIT SIGN LENS FROM OVERWING FELL OFF. REATTACHED COVER IAW AMM.SDR SWAA2019051732757Lens · missingRT OVER WING EXIT LIGHT LENS FORWARD OF DOOR MISSING. R&R LENS PER MM.SDR AALA201905179009Lens · missingAIRCRAFT WAS NOT GROUNDED: R1 DOOR EMERGENCY LIGHT LENS WAS MISSING. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 35-51-01.SDR SIMA20190516001Light · inoperativeCOCKPIT CEILING EMERGENCY LIGHT INOP. C/A-RELAMPED COCKPIT CEILING EMERGENCY LIGHT OPC GOOD AMM 35-50-00.SDR DALA2019051603062Power Supply · inoperative(AIRCRAFT 5811, L/P 5646771) DURING SVC CK FOUND EMERGENCY BATT POWER SUPPLY M11383 INOP. R/R PWR SUPPLY & BATTERY POS M11383 REF AMM 33-51. OPS NML.SDR WX0A2019051773395Sign · missingEMERGENCY EXIT SIGN IN ROW 12F MISSING. INSTALLED EMERGENCY EXIT SIGN. OPS CHECK GOOD. A/C OK FOR SERVICE."SDR DALA2019051603052Battery Pack · discharged(LOG 5004387) DURING INSPECTION FOUND F/C SEAT EMERG LIGHTS INOPERATIVE. R/R BATTERY PACK F/C PER AMM 33-50.SDR SWAA2019051732767Light · inoperativeLT EXTERIOR OVERWING LIGHT (L6) INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019051732763Cover · crackedR1 DOOR EXIT DOOR LIGHT CRACKED. R&R COVER IAW SIP.SDR SWAA2019051732761Light · inoperativeRT BULLNOSE EMERGENCY LIGHT INOP AT SEAT 22. RELAMPED EMERGENCY LIGHT PER AMM.SDR UIEA2019051704221Battery · dischargedEMERGENCY EXIT LIGHT OVERHEAD AT ROW 20 & 25 INOP. 13-26 AND ROW 8 PER AMC INSPECTION.(<P>R&R EMERGENCY LIGHT BATTERY ASSY M736 IAW AMM 33-51-07. PERFORMED OPS CHECK IAW AMM 33-51-07. NO DEFECT FOUND. ALL LIGHTS TO THIS ASSY OPERATING AT THIS TIME.</P>)SDR UIEA2019051704222Power Supply · inoperativeR1 EXTERIOR EMERG EXIT LIGHT INOP.(<P>R/R EMERGENCY LIGHT BATTERY PWR SUPPLY IAW AMM 33-51-07. OPS TEST GOOD IAW AMM 33-61-07.</P>)SDR UIEA2019051704223Battery · inoperativeL1 EMERGENCY LIGHT (EXTERIOR) INOP.(<P>RELAMPED L1 EXIT LIGHT WITH (767 BULB), NO HELP. TS TO BAD BATTERY ASSY. R&R AS PER AMM 33-51-07 AND OPS CHECK OK. </P>)SDR SIMA20190515004Flashlight · inoperativeAFT F/A FLASHLIGHT INOP. C/A-FLIGHT CREW PLACARED PER MEL 25-53 AUTH#050500-C MOC#696734. REMOVED AND REPLACED THE FA'S FLASHLIGHT IN THE AFT CABIN IAW AMM 33-50-16. OPC GOOD. MEL RESTORED.SDR DALA2019051603060Light · missing(AIRCRAFT 5809, L/P 5917702) UNDER SEAT EMERGENCY LIGHT AT SEAT 30D MISSING. REPLACED EMEGENCY LIGHT AT 30D IAW AMM 33-51 OPS CKS GOOD.SDR HNAA2019051600143Light · inoperative641 33-51 0022950 15MAY19 RIC CLOSE CEILING EMERGENCY LIGHT ABOVE MAIN DOOR DOES NOT ILLUMINATE. 28916 00 NGR FACT 15MAY19 11:29 RIC R/R MAIN DOOR EMERGENCY LIGHT IN REF TO AMM 33-50-06-000/400-801-A. P/N ON LIGHT 1317 P/N OFF LIGHT 1317.SDR SWAA2019051632744Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PER MM.SDR SWAA2019051632740Housing · crackedCENTER CABIN OVERHEAD EMERGENCY EXIT LIGHT HOUSING CRACKED. R&R LIGHT HOUSING IAW AMM.SDR SWAA2019051632728Light · inoperativeR1 DOOR SLIDE EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR AALA201905169004Sign · brokenAIRCRAFT WAS NOT GROUNDED: EXIT SIGN TO THE LEFT OF AFT GALLEY DOOR (LEFT SIDE) WAS IN PIECES ON THE COUNTER. MAINTENANCE REPLACED L2 DOOR EMERGENCY EXIT LIGHT PER AMM 33-51-01.SDR AALA20190516001Module · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS 20D THROUGH 25D WERE VERY DIM. MAINTENANCE REPLACED CHARGER AND BATTERY (MODULE) PER AMM 33-51-07.SDR 29GA2019051600001Light · looseFLIGHT 9008 FLL/MCO REPORT: FLOOR LEVEL EMERGENCY LIGHT STRIP LOOSE ON LEFT SIDE AROUND ROW 3. CORRECTIVE ACTION: RESECURED EMERGENCY LIGHT STRIP IAW AMM 33-50-20.SDR DALA2019051503018Light · inoperativeSEAT 3CD E/E LIGHTS INOP. RELAMPED SAME PER AMM 33-53. CKS GOOD. (LP5818198)SDR SIMA201906124003Light · cracked#1 AND #4 RH ISLE FLOOR EXTRUSION CRACKED-C/A-COMPLETE:REMOVED AND REPLACED #1 AND #4 RH ISLE FLOOR EXTRUSION IAW EMB 145 AMM 33-50-12SDR SIMA2019061214002Light · cracked#1 EMERGENCY FLOOR LIGHT EXTRUSION CRACKED-C/A-COMPLETE:REMOVED AND REPLACED #1 EMERGENCY FLOOR LIGHT EXTRUSION IAW EMB 145 AMM 33-50-12SDR SIMA2019061214004Light · brokenFLIGHT DECK EMERGENCY LIGHT ASSEMBLY BROKEN REQUIRES REPLACEMENT. OLD PART TEMP INSTALLED UNTIL PROCUREMENT OF NEW ASSEMBLY.-C/A-COMPLETE:REMOVED AND REPLACED EMERGENCY LIGHT IN FLIGHT DECK IAW EMB 145 AMM 33-30-01.SDR SWAA2019052232850Light · crackedEMERGENCY EXIT LIGHT COMMON TO THE FORWARD GALLEY CRACKED. R&R LIGHT IAW AMM.SDR SWAA2019052232814Light · crackedEMERGENCY EXIT LIGHT COMMON TO THE FORWARD LAV CRACKED. R&R LIGHT IAW AMM.SDR R61A201905140496Power Unit · inoperativeEMERGENCY LIGHT BATTERY FAULT EICAS MESSAGE BEFORE 15 MINUTE TIME LIMIT DURING FUNCTIONAL CHECK OF EMERGENCY LIGHTS. R&R FWD RT EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01.SDR SWAA2019051732766Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK M1674 DISCHARGED. R&R BATTERY PACK M1624 PER AMM AND WDM.SDR SWAA2019051732765Charger · inoperativeEMERGENCY LIGHT BATTERY PACK M1670 DISCHARGED. R&R CHARGER ASSEMBLY PER AMM AND WDM.SDR SWAA2019051732764Battery Pack · dischargedR1 DOOR EMERGENCY LIGHT AFT ON THE EXTERIOR INOP. R&R BATTERY PACK M1674 PER AMM AND WDM.SDR DALA2019051503061Guard · damaged(AIRCRAFT 6704, L/P 5442654) EMERGENCY LIGHT SWITCH GUARD ON OVERHEAD DAMAGED. REPLACED SWITCH GUARD. CHECKS GOOD. OK FOR SVC.SDR HNAA2019051600142Light · inoperative656 33-51 0003170 14MAY19 SBY CLOSE RT LATERAL PANEL EMERGENCY LIGHT INOP. 30100 00 CRH FACT 14MAY19 09:32 SBY R&RED RT LATERAL PANEL EMERGENCY LIGHT LIGHT BULB IAW AMM 33-50-10-000-801-A AND 33-50-01-700-801-A. P/N ON BULB 1317 P/N OFF BULB 1317.SDR SWAA2019051632749Light · dimRT OVERWING EXIT SIDEWALL LIGHT DIM. RELAMPED EXIT LIGHT PER AMM.SDR SWAA2019051632743Light · dimLT OVERWING EXIT SIDEWALL LIGHT DIM. RELAMPED EXIT LIGHT PER AMM.SDR SWAA2019051632727Lens · unsecureL1 DOOR EXIT LIGHT LENS UNSECURED. R&R LIGHT ASSEMBLY PER MM.SDR AALA201905169013Battery · dischargedAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS 26D THROUGH 36D INOPERATIVE. MAINTENANCE REPLACED CHARGER (SEE AALA201905169007) AND BATTERY ASSEMBLY PER AMM 33-51-07.SDR AALA201905169012Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY MARKERS AT 4L (SEE AALA201905169006) AND 4R DOOR INOPERATIVE. MAINTENANCE PERFORMED SATISFACTORY OPERATIONAL CHECK OF 4L AND 4R DOOR MARKERS PER AMM 33-51-10.SDR AALA201905169011Battery · dischargedAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS IN FIRST CLASS WERE VERY DIM. MAINTENANCE REPLACED CHARGER (SEE AALA201905169005) AND BATTERY ASSEMBLY PER AMM 33-51-07.SDR AALA201905169007Charger · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS 26D THROUGH 36D INOPERATIVE. MAINTENANCE REPLACED CHARGER AND BATTERY ASSEMBLY (SEE AALA201905169013) PER AMM 33-51-07.SDR AALA201905169006Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY MARKERS AT 4L AND 4R (SEE AALA201905169012) DOOR INOPERATIVE. MAINTENANCE PERFORMED SATISFACTORY OPERATIONAL CHECK OF 4L AND 4R DOOR MARKERS PER AMM 33-51-10.SDR AALA201905169005Charger · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS IN FIRST CLASS WERE VERY DIM. MAINTENANCE REPLACED CHARGER AND BATTERY (SEE AALA201905169011) ASSEMBLY PER AMM 33-51-07.SDR DALA2019051503035Lens · unsecure(AIRCRAFT 681, L/P 1073555) EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS: 2R / EMERGENCY PLACARD FELL OFF ON TAKEOFF ROLL. / INTERIOR. RE SECURED R2 DOOR EXIT LENS PER AMM 33-51.SDR SWAA2019051532721Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PER MM.SDR SWAA2019051532720Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER MM.SDR SWAA2019051532719Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PER MM.SDR SWAA2019051532716Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER MM.
Back to JASC 3350