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 SWAA2019011528421Light · inoperativeAFT ENTRY WAY EMERGENCY EXIT LIGHT BULBS BURNED OUT. R&R BULB IAW AMM.SDR SWAA2019011528420Light · inoperativeRT OVERWING EXIT LIGHT BULB BURNED OUT. R&R BULB IAW AMM.SDR HNAA2019011500014Light · inoperativeDIS 907 33-51 0005890 12JAN19 RIC CLOSE LT WING OVER WING EMERGENCY LIGHT DOES NOT ILLUMINATE. FACT 12JAN19 10:56 RIC
R/R LT OVER WING EMERGENCY LIGHT ASSY IN REF TO AMM 33-50-10-000/400-801-A. PERFORMED OPS CHECK NO ISSUES FOUND AT THIS TIME P/N ON LSDR ASAA2019011227754Lens · looseEXIT SIGN COVER BELOW WINDOW, ROW 17ABC, LOOSE AND FALLS OFF. GROUNDED - YES. REMOVED & REPLACED WORN DUAL LOCK ON LANYARD COVER FOR EMG EXIT @ 17ABC AS NEEDED.SDR DALA2019011400246Lens · missingSHIP 689 EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. CORRECTIVE ACTION: REINSTALLED COVER. (0901517)SDR SIMA20190112003Light · inoperativeFLOOR PROXIMITY STRIP LIGHT INOP. C/A-REMOVED AND REPLACED THE FLOOR PROXIMITY STRIP LIGHT IAW AMM 33-50-12.SDR SIMA20190112002Sign · inoperativeDURING PS-1 CHECK FOUND CEILING EMERGENCY SIGN INOP. C/A-REMOVED AND REPLACED AFT EMERGENCY SIGN ON CEILING PANEL IAW AMM 33-50-15. OPC GOOD.SDR SWAA2019011428393Lens · looseCENTER AISLE OVERHEAD EMERGENCY EXIT LIGHT LENS COVER LOOSE. SECURED LENS PER SIP.SDR SWAA2019011428386Lens · looseLT OVERWING EMERGENCY EXIT LIGHT ADJACENT EXIT DOOR LENS LOOSE. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2019011428384Sign · looseR2 DOOR EMERGENCY EXIT SIGN LOOSE. REPAIRED SIGN PER EA.SDR SWAA2019011428373Light · inoperativeLT AFT LOWER EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER SIP.SDR DALA2019011400228Battery Pack · discharged(LOG 4326507) DURING INSPECTION FOUND LT FWD AND AFT OVER WING EMERGENCY HATCH EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED LT FWD AND AFT OVERWING EMERGENCY HATCH EMERGENCY BATTERY PACK PER AMM 33-51 OPS CHECK GOOD.SDR ASOA201901127007Battery · dischargedTYS A/C WAS IN FOR A SERVICE CHECK THE INSPECTOR FOUND THE FWD PROX STRIPS FAIL THE OPS CHECK. MAINTENANCE R/R THE FWD PROX STRIP BATTERY IAW AMM 33-50-04;IPC REF. 33-50-04 FIGURE 1 ITEM 30. OPS CHECK GOOD AND WAS RELEASED.SDR SCNA20190111003Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACKS M1673 AND M1672 INOP. REMOVED, REPLACED, AND OPS CHECKED GOOD (M1673) AND (M1672).SDR SIMA20190111003Light · inoperativeFLOOR EMERGENCY LIGHT AT SEAT 14-16 INOP. C/A-REMOVED AND REPLACED FLOOR EMERGENCY LIGHT AT SEAT 14-16, OPC GOOD, IAW AMM 33-50-12SDR SIMA20190111002Battery · dischargedREAR EXTERNAL EMERGENCY LIGHTS INOP. C/A-RAR EXTERNAL EMERGENCY LIGHT IAW AMM 33-50-10. REMOVED AND REPLACED NR 4 BATTERY POWER SUPPLY IAW AMM 33-50-04 AND 33-50-00. OPS CHECKS GOOD.SDR SWAA2019011428392Cover · missingR1 DOOR LOWER EXIT SIGN MISSING DIRECTIONAL ARROW. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2019011428391Sign · missingL1 DOOR LOWER EXIT SIGN MISSING DIRECTIONAL ARROW. R&R SIGN PER AMM.SDR SWAA0147010128383Light · inoperativeR2 EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR REXA2019011000096Light · missingCENTER CEILING EMER EXIT LIGHT IS MISSING SMALL WHITE LIGHT LENS AND BULB. REPLACED CNT CEILING PANEL EMER EXIT WHITE LENS AND BULB IAW AMM 33-51-14. OPS CHECK ACCOMPLISHED ON W/O 1016610-2000-0009 S/N: 6285015.SDR I5EA2019012201Battery Pack · dischargedDISCREPANCY: L1, R1 DOOR EXIT IDENTIFIER LIGHT INOP. CORRECTIVE ACTION: INSTALLED SERVICEABLE BATTERY PACK AT STA. 400, POWER SUPPLY REF. PEELS WIRING DIAGRAM BR2013-P7373HP-3/-6 REV. C AND AMM 33-51-51, TEST OK.SDR Q2SA20190110401Battery Pack · dischargedAIRCRAFT GROUNDED. RT DR1 BATTERY PACK CAPACITY CHECK FOUND EMERGENCY LIGHTS AND SIGNS STAY ON LESS THAN 15 MINUTES. RT DR1 BATTERY PACK REPLACED AND TEST OK AS PER AMM 33-51-06.SDR Q2SA20190110400Battery Pack · dischargedAIRCRAFT GROUNDED. LT DR1 BATTERY PACK CAPACITY CHECK FOUND EMERGENCY LIGHTS AND SIGNS STAY ON LESS THAN 15 MINUTES. LT DR1 BATTERY PACK REPLACED AND TEST OK AS PER AMM 33-51-06.SDR YENA201901100020Battery Pack · failedFLT 2066, RSW-BOS. FDW BATTERY PACK FAIL ( ESPU); R & R FWD (EPSU) EMERGENCY BAT LIGHT IAW AMM 35-51-00. OPS CHECK GOOD.SDR ASAA2019011027759Lens · detachedMID CABIN OVERWING EMERGENCY SIGN LEGENDS KNOCKED OFF FIXTURE. GROUNDED - YES. REINSTALLED EMERGENCY SIGN. OPS CHECK OKAY.SDR AALA201901142002Battery Pack · inoperativeBATTERY PACK WOULD NOT CHARGE. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE BATTERY PACK IAW STANDARD PRACTICES AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2019011400239Light · inoperativeEMERGENCY LIGHTS AT SEAT 38F ARE INOPERATIVE. REPLACED LIGHT ASSEMBLY AT 38F. SYSTEM OPERATION IS NORMAL.SDR SWAA2019011428390Strip · damagedRT FORWARD FLOOR PHOTO ILLUMINATION STRIP DAMAGED. R&R STRIP PER DWG.SDR DALA2019011100201Battery · discharged(LP# 5069295) LEFT EPSU BATTERY FAULT. REMOVED AND REPLACED EPSU BATTERY IAW MM. OPERATION CHECKS OK.SDR CALA2019011300082Light · inoperativeCEILING EEL BETWEEN SEAT 39 INOP. RELAMPED REF AMM 33-51-03-960-801. INSPECTED LIGHT OPS CHECK GOOD REF AMM 33-51-03-960-801.SDR CALA2019011300080Lens · missingSEAT 4AB EEL PATHWAY LIGHT LENS MISSING. REPLACED DAMAGED LENS AND RELAMPED REF AMM 33-51-11. INSPECTED REF AMM 33-51-11.SDR CALA2019011300079Light · inoperativeDOOR 2L EXT EEL INOP. RELAMPED REF AMM 33-51-04-960-801. OPS CHECKED OK. INSPECTED OPS CHECK GOOD.SDR CALA2019011300078Battery Pack · dischargedEMER EXIT LIGHTS BETWEEN 16DEF AND 23 DEF INOP INCLUDING OVERWING EXITS. REPLACED BATTERY PACK REF AMM 33-51-06-960-805. OPS CHECKED OK. INSPECTED EMERGENCY LIGHTS REF AMM 33-51-06-960-805.SDR CALA2019011300077Battery Pack · dischargedREF NR LP 9130048, B777-33-3-6026 EMER PWR SUPPLY M33093 AT DOOR 1L FAILED. BATTERY PACK CAPACITY CHECK EMER PWR SUPPLY M33093 AT DOOR 1L BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2019011300075Battery Pack · failedREF NR LP 9130424,B777-33-3-6026 - LT DR1 EMER SUPPLY M33424 CAPACITY CHECK FOUND FAIL. LT DR1 EMER PWR SUPPLY M33424 BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2019011300074Charger · failedREF NR LP 9130423,B777-33-3-6026 LT DR1 EMER PWR SUPPLY M33424 CHARGER FOUND FAIL. LT DR1 EMER PWR SUPPLY M33424 CHARGER REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR DALA2019011100182Lens · damaged(LOG 0898375) DURING INSPECTION FOUND EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. SECURED EXIT LENS. CHKS GOOD.SDR HNAA2019011100012Light · dimMAIN DOOR EMERGENCY LIGHT IS DIM. R&R'D LIGHT ASSY IAW 33-50-10.SDR SIMA20190110001Light · inoperativeROW 6 CEILING EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED ROW 6 CEILING EMERGENCY LIGHT BULB IAW 33-50-08-000-801-A AND 33-50-08-400-801-A. OPS CHECK GOOD. END.SDR XMXR20191211004Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR AALA201901165007Battery Pack · no testLEFT EMERGENCY LIGHTS BETWEEN SEATS 20B TO 28B FAILED AN OPS CHECK. MAINTENANCE REPLACED THE BATTERY PACK IAW STANDARD PRACTICES, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201901165006Charger · no testLEFT EMERGENCY LIGHTS BETWEEN SEATS 20B TO 28B FAILED AN OPS CHECK. MAINTENANCE REPLACED THE CHARGER IAW STANDARD PRACTICES, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR IPXA2019010937682Terminal · looseINSPECTION TYPE:ASE FWD LWR ENTERT DOOR EMERGENCY LT INOP. ITEM DEFERRED PER MEL 33-51-05-1 C/N M658930 ASSIGNED. **SUPPLEMENTAL SDR** PERF'D VISUAL, FOUND LOOSE TERMINAL ON EMERGENCY LIGHT, RECRIMPED TERMINAL IAW ESPM 20-30-11-0101, OK FOR SVC.SDR DALA2019011300214Lens · unsecureEMERGENCY FLOOR LIGHT DAMAGE AT 2C. RESECURED LENS AT 2C. OK FOR SVC.SDR IPXA2019011037692Light · missingINSPECTION TYPE:N/A EMERGENCY EXIT LIGHT HAS 1 BULB MISSING. RELAMPED EMERGENCY EXIT LIGHT PER MM 51-00-00. OPS CHK GOOD.SDR SWAA2019011128370Light · inoperativeL1 DOOR EXTERNAL EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR DALA2019010900164Fuse · blownSHIP 694 ON S/C FOUND EMERG PATH LIGHTS INOP ON SEATS 18-22. CORRECTIVE ACTION: REPLACED FUSE ON POWER SUPPLY M733 REF WDM 33-51-13. (5229908)SDR SWAA2019011028363Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2019011028362Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2019011028361Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.
Back to JASC 3350