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 SWAA2020031242363Lens · missingLT OVERWING LOWER EMERGENCY LIGHT COVER MISSING. / INSTALL LIGHT LENS PER AMM 33-51-01.SDR DALA2020031201810Pin · not reported(AIRCRAFT 6808, L/P 7192809) ON SERVICE CHK FOUND FWD GALLEY EMERGENCY LIGHTS RED AND WHITE ON G2 WALL INOP. CORRECTIVE ACTION: REPLACED PIN PER BSWPM 20-42.SDR SWAA2020031142357Light · inoperativeEXTERNAL EMERGENCY LIGHT JUST AFT OF FWD ENTRY DOOR INOP RELAMPED AND CHECKED GOOD IAW MM 33-51-04SDR SWAA2020030842345Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATIONS M1668 AND M1672. R&R EMERGENCY LIGHT BATTERIES AT LOCATIONS M1668 AND M1672 PER MM 33-51-06SDR SWAA2020031142344Battery · failedPASSENGER CABIN, FOUR EMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST. R & R PASSENGER CABIN, FOUR EMERGENCY LIGHTING BATTERY PACKS (M01670, M01672, M01673 & M01675), PER AMM 33-51-06 & DWG# 33500005.SDR SIMA202003110005Light · inoperativeRH OVERWING EMERGENCY LIGHT INOP. MEL # 3329 AUTH# 03-272D-C LOGPAGE # 4507659-C/A-RAR RH OVERWING EMERGENCY LIGHT IAW EMB 140 AMM 33-50-10. OPC GOOD. MEL RESTORED.SDR SIMA202003110001Light · inoperativeR/H WING EMERGENCY LIGHT INOP-C/A-RAR R/H WING EMERGENCY LIGHT IAW EMB 145 AMM 33-50-10. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED.SDR SIMA202003110003Light · inoperativeFWD LH EXTERNAL EMERGENCY LIGHT INOP-C/A-RAR LH FWD EXTERNAL EMERGENCY LIGHT LAMP IAW EMB-145 AMM 33-50-10. OPC GOODSDR MASA2020031000107Light · inoperativeOVHD EMER LIGHT AT ROW 18 INOPSDR MASA2020031000105Light · inoperativeROW 13F EMER SIGN 1 BULB INOPSDR MASA2020031000104Light · inoperativePAX DOOR EMER FLOOR LT HAS 1 BULB INOPSDR SWAA2020031042318Light · inoperativeFOUND EMERGENCY OVERWING LIGHT AFT INOP REMOVED & REPLACED AFT EMERGENCY OVERWING LIGHT IAW AMM 33-51-04. OPS CHECK GOOD AT THIS TIME.SDR DALA2020031001745Power Supply · inoperativeEMERGENCY LIGHTS INOP FIRST CLASS & L1&L2. RPLCD FWD BAT PACK PWR SUPPLY B5-211 CKS GOOD PER MD88 AMM 33-53. (LP6452238)SDR SWAA2020041321322Battery Pack · dischargedINOP EMERGENCY LIGHT BATTERY PACKS M1672 AND M1673 AT AFT GALLEY AREA (2 EA) / REPLACED EMERGENCY LIGHT BATTERY PACKS M1672 AND M1673 AND PERFORMED OPERATIONAL TEST IAW B737-700 AMM 33-51-06-960-805. TEST IS OK.SDR FDEA2020031290507Light · inoperativeMDIS 972 33-50 6132 09MAR20 MXP FACT U LH SLIDE EMERGENCY LIGHT L25 FOUND INOP. LH SLIDE EMRGENCY LIGHT L25 LAMP (P/N 767) REPLACED IAW AMM 33-51-06-2-1. OPS CHECK SATIS. A/C OK FOR SERVICE.SDR SWAA2020031042321Battery Pack · faulty**EMERGENCY BATTERY PACK M1673 WILL NOT HOLD CHARGE REMOVED BAD BATTERY PACK M1673 AND REPLACED WITH SERVICEABLE BATTERY PACK FROM A/C 296 IAW AMM 33-51-06-960-805. PERFORMED M1673 BATTERY PACK INSTALL TEST, CHECKS GOOD IAW AMM 33-51-06-960-805 STEP 4.SDR YENA2020031090227Light · inoperativeFT # 353, FLL-SJU. EMERGENCY EXIT SIGNS L1 / R1 AND AFT GALLEY OVERHEAD EMERGENCY LIGHT BULBS INOP 31 BULBS IN TOTAL ; RELAMPED FOR PER AMM 33-50-00 ALL CHECK NORMAL. OK FOR SVC BY MCC SAI NOTIFIED. (EMERGENCY EXIT SIGNS BULBS)SDR SIMA202003109002Light · inoperative"TRANSFERRED FROM NRWC 809-CMI-04121 ITEM 1" RH OVERWING EMERGENCY LIGHT INOP-C/A-DEFERRED PER MEL 33-29. AUTH #030272D-CSDR SIMA202003109001Light · inoperativeR/H WING EMERGENCY LIGHT INOP-C/A-RAR R/H WING EMERGENCY LIGHT BULB IAW EMB 145 AMM 33-50-10. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED.SDR MASA2020031000101Light · inoperativeSVC DOOR EMER LIGHT INOP 3 OUT OF 5 BULBS. REPLAMPEDSDR DALA2020031001746Battery · dischargedSVC CK OVHD EMER LTS AFT SECTION OF CBN INOP. RPLD BATTERIES IN CHARGERS B5-106 AND B5-107 PER MD88 AMM 33-53 LT OPN NML. (LP6958463)SDR DALA2020030901702Battery · dischargedCEILING EMERGENCY LIGHTS FROM SEAT 1 TO 4 AND SEATS 21 TO 25 ARE INOP. R & R EMERGENCY LIGHT BATTERIES AT SEAT 4 C/C & 24 E/D PER MD 88 AMM 33-53 OPS CHECKS GOOD. (LP6475675)SDR DALA2020030901701Battery · dischargedOVERHEAD EMER LIGHT INOP FROM SEAT 10-13. R/R BATTERIES IN EMER LIGHT BATT PACK PER MD 88 33-53 OPS CKS GOOD (LP7180077)SDR AALA2020031199001Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FORWARD OUTBOARD FLIGHT ATTENDANT SEAT FLASHLIGHT DID NOT FLASH. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 25-60-00.SDR DALA2020031101792Cover · detached(AIRCRAFT 6822, L/P 6960476) EXIT LIGHT COVER AT ROW 36 DETACHED FROM CEILING. CORRECTIVE ACTION: SECURED LIGHT COVER AND ASSEMBLY.SDR DALA2020031101788Battery Pack · discharged(AIRCRAFT 5808, L/P 6739409) MULTIPLE EMERGENCY LIGHTS INOP NEAR FWD OVERWING EXIT. CORRECTIVE ACTION: FOUND BATTERY PACK M11487 CHARGE LOW. REMOVED & REPLACED BATTERY PACK.SDR UIEA2020031100399Light · inoperativeL2 DOOR EMERGENCY LIGHT INOP (EXTERNAL).(<P>RELAMPED L2 DOOR EMERGENCY LIGHT. OPS CHECK OK IAW AMM 33-51-00/705.</P>)SDR AALA202003109020Battery · dischargedAIRCRAFT NOT GROUNDED: EMER L EPSU (11WL) FAILED ON EPSU SYS TEST. REPLACED EPSU BATTERY AT EMER L EPSU (11WL) IAW AMM 33-51-38.SDR AALA202003109019Battery · dischargedAIRCRAFT NOT GROUNDED: FWD L EPSU (10WL) FAILED ON EPSU SYS TEST. REPLACED EPSU BATTERY AT FWD L EPSU (10WL) IAW AMM 33-51-38.SDR MASA2020031000099Light · inoperativeFIRST CLASS CEILING EMER FLOOD LT INOP. RELAMPEDSDR MASA2020031000100Light · inoperativeROW 13AC EMER EXIT LIGHT ONE BULB INOP. PLACED ON MELSDR AALA202003099003Control Unit · faultyAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT SYSTEM WAS NOT WORKING AT ROWS 37 THROUGH 39. MAINTENANCE REPLACED CONTROL UNIT UNDERNEATH SEAT 39D PER AMM DMC-B787-A-33-51-07-01A-720A-A AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA202003099002Control Unit · faultyAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT SYSTEM WAS NOT WORKING AT ROWS 16 THROUGH 18. MAINTENANCE REPLACED CONTROL UNIT UNDERNEATH SEAT 18D PER AMM DMC-B787-A-33-51-07-01A-720A-A AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2020030942247Lens · unsecureFWD ENTRY DOOR EXIT LIGHT COVER FELL OFF INSTALLED FWD ENTRY DOOR LIGHT LENS PER S.I.P.SDR SIMA202003098002Light · inoperativeFOUND RH OVERWING EMERGENGY LIGHT INOP DURING PS-2-C/A-RAR EMERGENCY LIGHT BULB IAW AMM 33-50-10SDR SWAA2020041429946Light · brokenEMERGENCY EXIT LIGHT ON FWD LAV AFT EXTERIOR WALL IS BROKEN / REMOVED AND INSTALLED NEW EMERGENCY EXIT LIGHT ON FWD LAV AFT EXTERIOR IAW AMM 33-51-01-960-802 AND PERFORMEED TEST ON EMERGENCY LIGHT ON FWD LAV AFT EXTERIOR IAW AMM 33-51-01-960-802. OP CHECK IS GSDR AALA2020031189009Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: BATTERY PACK DOOR 1L INOPERABLE. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-06.SDR 7C7A2020031100002Power Supply · inoperativeEMERGENCY LIGHTS ON IN ARM POSITIONSDR ASOA2020031075009Light · inoperativePILOT REPORTED CEILING EMER LIGHT BY EXIT ROW NOT ILLUMINATING. MX RELAMPED CEILING EMER LIGHT OPS CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR AALA2020031089008Battery · failedAIRCRAFT GROUNDED - EMERGENCY LIGHT SIGN OVER DOOR 2L INOPERATIVE. REMOVED AND REPLACED WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNIT BATTERY PER AMM DMC-B787-A-33-52-07-02B-520A-A, DMC-B787-A-33-51-07-02B-720A-A, OPS TEST OK. OK FOR SERVICE.SDR DALA2020031001748Unknown · malfunctionedEXIT GREEN LIGHTS IN CABIN DID NOT ILLUMINATE DURING APPROACH. REF LOG 6661300. CYCLED AIRCRAFT POWER. EXIT LIGHTS OPS CHK NORMAL. AIRCRAFT OK FOR SVC IAW A220 BD500 J24-01. (LP# 6661301)SDR SWAA2020030942276Battery Pack · faultyALL EMERGENCY LIGHTS ASSOCIATED WITH M1674 BATTERY PACK COME ON MOMENTARILY. REMOVED, REPLACED AND PERFORMED GOOD OPERATIONAL TEST OF M1674 EMERGENCY LIGHT BATTERY PACK. ALL EMERGENCY LIGHTS ARE OPERATIONAL. ALL IAW AMM 33-51-06-960-805.SDR SWAA2020030942243Cover · out of positionAFT SERVICE DOOR EMER EXIT FLOOR LEVEL SIGN HAS ARROW POINTING WRONG DIRECTION R7R AFT SVC DOOR EMERG. EXIT LIGHT COVER IAW AMM 33-51-01SDR SWAA2020030942242Lens · brokenR/H EMERGENCY EXIT LENS COVER BROKEN R& R/H EMERGENCY EXIT LIGHT ASSEMBLY PER M/M 33.51.04.SDR SWAA2020030942238Battery Pack · dischargedBOTH FWD OVER WING EXIT LIGHTS AND FWD EMER LIGHTS INOP R+R BOTH FWD L/H R/H STA 500C+7 BATTERY PACKS PER MM 31-51-00. EMER LTS OPS NORMALSDR DALA2020030901736Battery Pack · dischargedEMERGENCY PATH ESCAPE LIGHTS ARE DIM. REPLACED BATTERY PACK M9011. SYSTEM OPERATION IS NORMAL.SDR SIMA202003097001Battery · dischargedLH AND RH OVER WING EMERGENCY LIGHTS WILL NOT ILLUMINATE-C/A-RE-LAMPED RH OVER WING EMERGENCY LIGHT NO FIX. RAR BATTERY AND CHARGER #4 IAW WC 33-700-19 OPC CHECK GOODSDR ASOA2020030973027Battery · dischargedDURING ROUTINE MAINTENANCE THE EMERGENCY LIGHTING OVER WING AND AISLE LIGHTS WERE INOPERATIVE. MAINTENANCE REPLACED THE #4 EMERGENCY LIGHT BATTERY. OPERATIONAL CHECKS WERE GOOD.SDR JJBA202003097001Power Supply · dischargedLH & RH EXTERNAL AFT EMERGENCY LIGHTS INOPERATIVE. R&R BATTERY POWER SUPPLY #4. OPS CHECK SAT.SDR DALA2020031301835Lens · missingEMERGENCY EXIT COVER DIFFUSER LENS MISSING, INSTALLED NEW COVER
Back to JASC 3350