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 SWAA2019012128626Sign · brokenMID CABIN EXIT SIGN ON CEILING BROKEN. R&R SIGN PER AMM.SDR IPXA2019012138096Light · inoperativeINSPECTION TYPE:N/A L1 EMERGENCY EGRESS LIGHT INOP. RELAMPED L1 EMERGENCY EGRESS LIGHT REF MM CH 33 51 06 OPS CHECK GOOD.SDR HNAA2019012100021Terminal · not seatedDISCREPANCY: EMERGENCY FLOOR LIGHTS ROW 2 AND 3 INOP. CORRECTIVE ACTION: RESEATED TERMINAL ENDS ON EMERG. FLOOR LIGHT ROW 2, RESECURED LIGHT STRIP WITH RETAINED HARDWARE.SDR MASA2019012011671Light · inoperativeSERVICE DOOR EMERGENCY LT BULB INOP. REPALCED BULB.SDR YENA2020012390040Battery · no testEPSU BATTERY FAILED A CAPACITY CHECK. R&R EMERGENCY LIGHT BATTERY AT (11WL) AND (12WL) IAW AMM 33-51-38. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR DALA2019012200467Lens · unsecureSHIP 663 DOOR 2 L EXIT LENS FELL OFF. CORRECTIVE ACTION: REINSTALLED LENS PER AMM 33-51. (5037488)SDR DALA2019012200452Lens · missing(AIRCRAFT 7007, L/P 5272497) EMERGENCY PATH PROXIMITY LIGHT LENS COVER MISSING AT 25R 4L GALLEY BY 57B FWD SIDE 3L LAV CLEAR. 4R DOOR AREA AFT SIDE OF GALLEY RED. AOG ORDERED P/N 0203173-001 CLEAR 10 EA AND P/N 0203173-002 RED FROM MSP DOMESTIC STORES TO AIRCRSDR DALA2019012200449Fuse · blown(AIRCRAFT 7007, L/P 5272498) OVHD EMERGENCY LIGHTS INOP AT 35R AND 40R. REPLACED FUSE IN POWER SUPPLY REF WDM 33.51. CHECKS OK.SDR ASAA2019011927869Lens · detachedEXIT SIGN BY L1 DOOR HINGE CAME UNDONE. GROUNDED - YES. REINSTALLED EXIT SIGN LENS AS REQUIRED.SDR HALA2019011900029Lens · missingOVERHEAD EMERGENCY LIGHT LENS MISSING ABOVE ROW 39 RIGHT. REPLACED LENS. LP 5400900SDR SIMA20190119005Light · inoperativeDURING PS-1 CHECK, FOUND AFT EXTERIOR EMERGENCY LIGHTS INOP. C/A- REMOVED AND REPLACED BATTERY HOLDER ASSEMBLY AND BATTERY CHARGER ASSEMBLY IAW AMM 33-50-04. OPS CHECK FAIL. NO FIX. DEFERRED PER MEL. FOUND NR 1 FUSE ON POWER SUPPLY BLOWN. REMOVED AMD REPLACED SDR SIMA20190119004Light · inoperativeLT EXTERIOR OVERWING EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED LT EXTERIOR OVERWING EMERGENCY LIGHT IAW AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPS CHECK GOOD.SDR SWAA2019012128630Light · dimLT OVERWING EXIT LIGHT DIM. RELAMPED WINDOW LIGHT PER MM.SDR SWAA2019012128628Light · inoperativeL1 DOOR SLIDE EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR HNAA2019012100022Light · inoperativeNDIS 651 33-51 0007180 19JAN19 SBY CLOSE EMERGENCY LIGHT ON L/H WING TO FUSELAGE LATERAL PANEL IS INOP. FACT 19JAN19 12:51 SBY
R&R LIGHT BULB AT SAID LOCATION AND RESECURED THE COVER USING RETAINED HARDWARE. P/N ON: 1317 P/N OFF:1317SDR MASA2019011911669Battery · dischargedMID CABIN FWD EXIT SIGN INOP. CHARGED BATTERIES.SDR DALA2019011900444Epsu · inoperativeDURING SVC CK SEVERAL EMERGENCY LIGHT INOP, REPLACED EPSU (13WL)SDR YENA201901180031Battery · failedFLT 391, BOS-TPA. EPSU 12WL BATTERY FAILED EMER. LIGHTS SYS. TEST; REPLACED BATTERY AT EPSU 12WL. EMER. LIGHTS SYS TEST GOOD.SDR DALA2019012100428Battery · low voltageLLCR EMERGENCY LIGHTS ARE INOPERATIVE. MAINTENANCE FOUND BATTERY WITH LOW VOLTS AND REPLACED. SYSTEM OPERATION IS NORMAL.SDR DALA2019012100422Power Supply · inoperativeON SERVICED CHECK FOUND EMERGENCY LIGHTS AT SEATS 21-31 INOPERATIVE. POWER SUPPLY M9009 IS BAD. REPLACED SAME. SYSTEM OPERATION IS NORMAL.SDR DALA2019012000408Sign · missing(LOG 4326528) DURING INSPECTION FOUND EXIT ROW SIGN MISSING. REPLACED EXIT SIGN OK FOR SERVICE.SDR SWAA2019012228790Lens · unsecureLT REAR EMERGENCY EXIT SIGN LENS FELL OFF AT ROW 16. REINSTALLED LENS PER MM.SDR SIMA20190118001Inverter · inoperativeFOUND EMERGENCY EXIT LIGHT IN FWD CABIN BY GALLEY INOP. C/A-REMOVED AND REPLACED EMERGENCY LIGHT DC/AC INVERTER 1 IAW AMM 33-50-11. OPC GOOD.SDR SWAA2019012128673Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01675. R&R BATTERY PACK PER AMM.SDR SWAA2019012128672Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01668. R&R BATTERY PACK PER AMM.SDR SWAA2019012128671Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01669. R&R BATTERY PACK PER AMM.SDR SWAA2019012128670Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01670. R&R BATTERY PACK PER AMM.SDR SWAA2019012128669Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01673. R&R BATTERY PACK PER AMM.SDR SWAA2019012128668Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01674. R&R BATTERY PACK PER AMM.SDR SWAA2019012128657Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01672. R&R BATTERY PACK PER AMM.SDR SWAA2019012128629Switch · missingAFT GALLEY EMERGENCY LIGHT GUARD SWITCH MISSING. INSTALLED GUARD SWITCH PER SIP & CMM.SDR SWAA2019012128627Light · inoperativeRT FUSELAGE EXTERIOR EMERGENCY EXIT LIGHT JUST AFT OF WING INOP. RELAMPED LIGHT ER AMM.SDR SWAA2019012128621Cover · missingRT LOWER OVERWING EXIT SIGN COVER MISSING. R&R COVER IAW AMM.SDR HNAA2019012100024Light · defectiveNDIS 906 33-20 0006990 18JAN19 SBY CLOSE SERVICE DOOR EMERGENCY LIGHT IS FLICKERING. FACT 18JAN19 10:36 SBY R&R LIGHT BULB AT SAID LOCATION AND RE-SECURED THE COVER.SDR HNAA2019012100023Light · inoperativeNDIS 906 33-20 0007020 18JAN19 SBY CLOSE MOST FWD FLOOR EMERGENCY LIGHT STRIP IS INOP. FACT 18JAN19 10:40 SBY R& R MOST FWD LIGHT STRIP IAW AMM TASK NUMBERS 33-50-12-00-801-A AND 33-50-12-400-801-A.SDR MASA2019011811668Light · inoperativeROW 6 OVHD EMER LIGHT INOP. PLACED ON MEL.SDR CALA2019011800124Power Supply · faultyEPSU BATTERY EMER L FAULT ON AAP WHEN EMERGENCY LIGHT OPS CHECK IS COMPLETED. REPLACED LEFT EMER PWR SUPPLY AND BATTERY PER AMM 33-51-38. TEST OK. ROTABLE PARTS CHANGE WAS INDICATED - TT # 1248304 SN OFF 8072 IPC REFERENCE # POWER SUPPLY, C OFF 31-3350-9-9001SDR DALA2019011800336Battery Pack · dischargedTHE OVER WING EMERGENCY LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE OVER WING EMERGENCY LIGHTS BATTERY PACK IAW AMM 33-54. OPERATIONAL CHECK WAS GOOD. (LP #4842898)SDR YENA2019021217027Socket · inoperativeFT # 788, SEAT 13 C EMERGENCY LIGHT INOP; R & R SEAT 13 C EMERGENCY LIGHT SOCKET ASSY PER AMM 31-51-18. OPS CHECK GOOD.SDR DALA2019011700466Lens · brokenSHIP 663 DOOR 2L EMERGENCY LIGHT LENS IS BROKEN. CORRECTIVE ACTION: REINSTALLED 2L DOOR EMERGENCY LIGHT COVER PER AMM 33-51. (5037484)SDR ASAA2019011727870Sign · unsecureEXIT/SALIDA SIGN OVERHEAD AISLE AT EXIT ROW FELL OFF. GROUNDED - YES. SECURED EXIT/SALIDA SIGN.SDR YENA201901170029Battery · failedFLT 1391, BOS-TPA. EPSU 10WL BATTERY FAILS EMERGENCY LIGHT SYSTEM TEST; R & R EPSU 10WL BATTERY IAW MM 33-51-38, EMERG LIGHT SYSTEM CHECKS OK.SDR YENA201801170027Socket · defectiveFLT 788, SXM-JFK. SEAT 13 C EMERGENCY LIGHT INOP; R & R SEAT 13 C EMERGENCY LIGHT SOCKET ASSY PER AMM 31-51-18. OPS CHECK GOOD.SDR DALA2019012200410Light · broken(LP# 5278828) SEAT 21D EMERGENCY LIGHT BROKEN. FWD TO MCO/PLAC PER MEL 33-50-03A. 21JAN, INSTALLED NEW EMERGENCY LIGHT ASSEMBLY IN 21DEG IAW MM. OPERATION CHECKS NORMAL.SDR SROM2019F00121Fuse · openINTERIOR EMERGENCY EXIT LIGHT ROW 10DEF (R) AND 12DEF (R) IS INOPERATIVE.SDR SWAA2019012128677Button · brokenAFT EMERGENCY EXIT LIGHT BUTTON BROKEN. INSTALLED BUTTON PER SIP AND CMM.SDR SWAA2019012128615Light · inoperativeLT WING EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR HNAA2019012100025Light · inoperativeDIS 642 33-51 0002620 17JAN19 RIC CLOSE COCKPIT CEILING EMERGENCY LIGHT DOES NOT ILLUMINATE. FACT 17JAN19 08:11 RIC R/R LAMP FOR COCKPIT CEILING EMERGENCY LIGHT IN REF TO AMM 33-50-05-000/400-801-A. OPS CHECK GOOD OK FOR SERVICE. P/N ON LAMP, 1317
PSDR IPXA2019011737974Light · inoperativeINSPECTION TYPE:N/A EMERGENCY LIGHT HAS FIVE INOP BULBS. RELAMPED FIVE BULBS IN EMERGENCY LIGHT PER AMM 33-51-01-2.SDR MASA2019011711665Light · inoperativeBOTTOM EXIT SIGN ROW 13DF 2 BULBS OUT. RELAMPED.
Back to JASC 3350