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 CALA2018120202483Battery Pack · defectiveDEFECTIVE BATTERY PACK M6759, BEHIND THE KICK PANEL, BELOW THE 4TH WINDOW AFT OF THE 2ND AIR COND RISER (L SIDE). STA 841 WL 204 LBL 95 (NEXT TO SEAT 20A IN CURRENT CABIN CONFIG). BATTERY PACK REMOVED PER AMM 33-51-07. BATTERY PACK AND POWER SUPPLY REMOVED ANDSDR CALA2018120202482Battery Pack · defectiveDEFECTIVE BATTERY PACK M734, RIGHT HAND SIDE OF AIRCRAFT 20 WINDOWS AFT EMERGENCY SCAPE WINDOW, STA 1384 WL 204 RBL 95 (BEHIND KICK PANEL AT SEAT 42L WITH CURRENT CABIN CONFIG). POWER SUPPLY AND BATTERY PACK REMOVED AND REPLACED IAW AMM 33-51-07 OPS NOW NORMALSDR CALA2018120202481Light · detachedSEAT 20D EMERGENCY LIGHT ASSY DETACHED FROM STRUCTURE. RESECURED LIGHT ASSEMBLY WITH NEW LENS COVER. FUNCTION TEST OF EMERGENCY LIGHTS SYSTEM IS NORMAL AT THIS POSITION. OK FOR FURTHER USESDR CALA2018120202480Light · unsecureSEAT 6D EMERGENCY LIGHT NOT SECURED WILL REQUIRE LIGHT LENS COVER. DEFERRED REQUIREMENTS CONTAINED IN MEL 3351C COMPLIED WITH OK. ITEM ISSDR CALA2018120202478Sign · crackedEXIT IDENTIFIER BASE FND CRACK AT DOOR L2 AFT & DOOR R3 AFT. EXIT IDENTIFIER REPLACED AT DOOR L2 AFT & DOOR R3 AFT, C/O EMERGENCY LT OPERATIONAL TEST, THE RESULT FND NORMAL AS PER AMM 33-51-01-960-802 REV84.SDR MASA2018113011566Light · inoperativeROW 11 EMERGENCY FLOOD LT INOP. PLACED ON MEL.SDR MASA2018113011563Lamp · inoperative1 LAMP INOP CENTER AISLE EMERG EXIT LIGHT. RELAMPEDSDR MASA2018113011562Lamp · inoperativeLEFT SIDE OVER-WING EMERG EXIT LIGHT INOP. RELAMPEDSDR MASA2018113011561Light · inoperativeROW 15 EMERG OVERHEAD FLOODLIGHT INOP. PLACED ON MEL.SDR SWAA2019011528433Battery Pack · dischargedR1 DOOR EMERGENCY EXIT LIGHT FORWARD LOWER LIGHT PACK INOP. R&R BATTERY PACK PER AMM.SDR SWAA2019011528432Light · inoperativeRT OVERHEAD BIN EMERGENCY LIGHT INOP AT ROW NR 3. R&R BULB PER AMM.SDR SWAA2019011028283Light · inoperativeLT INBOARD OVERWING EMERGENCY EXIT LIGHT INBOARD UPPER LIGHTS INOP. R&R BULB PER MM.SDR SIMA201812149007Light · damagedLH #6 FLOOR PROXIMITY LIGHT DAMAGED-C/A-REMOVED AND REPLACED #6 FLOOR PROXIMITY LIGHT STRIP IAW EMB 145 AMM 33-50-12.SDR SIMA2018121029004Wire · broken#4 FLOOR EMERGENCY LITE STRIP HAS BROKEN WIRE-C/A-RAR #4 EMERGENCY LITE STRIP IAW EMB 145 AMM 33-50-12 OCK GOODSDR SWAA2018113027260Light · inoperativeRT OVERWING ESCAPE GROUND ILLUMINATION LAMP INOP. R&R LAMP PER AMM.SDR SWAA2018113027226Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER AMM.SDR AALA201811309012Sign · damagedEXIT SIGN AT THE MAIN ENTRY DOOR FLOOR PANEL WAS BROKEN AWAY FROM THE MOUNTING SCREW. SECURED EXIT SIGN AND INSTALLED NEW LENS IAW 33-51-13. OPS CHECKED GOOD.SDR DALA2018112906904Charger · inoperativeEMERGENCY LIGHTS AT ROWS 15AB-21AB ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY CHARGER AND PACK AT ROW 20AB. SYSTEM OPERATION IS NORMAL.SDR SWAA2018122027753Sign · brokenAFT ENTRY OVERHEAD PANEL EXIT SIGN MOUNT BROKEN. R&R SIGN PER AMM.SDR SWAA2018113027249Battery · failedLT FORWARD EMERGENCY BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2018113027224Cover · looseEMERGENCY EXIT LIGHT GUARDED COVER SWITCH LOOSE. R&R COVER IAW SIP.SDR DALA2018120396990Light · brokenSHIP 5804 4L DOOR EMERGENCY LIGHT BROKEN. CORRECTIVE ACTION: REMOVED AND REPLACED 4L DOOR EMERGENCY LIGHT EXIT SIGN PER B757 AMM 33-51. CKS GOOD. (5138211)SDR DALA2018113006958Light · out of positionEMERGENCY LIGHTS ON EXIT ROWS IN WRONG POSITIONS. REPOSITIONED LIGHT ASSEMBLIES. OPERATION CHECKS GOOD.SDR DALA2018113006957Shroud · damaged20D ESCAPE PATH LIGHTING INOPERATIVE. DEFERRED TO MCO/PLAC 33-20-03A. 30NOV MCO FOUND ESCAPE PATH LIGHT OPERATIONAL BUT SHROUD DAMAGED. REMOVED AND REPLACED SHROUD. OPERATION CHECKS GOOD.SDR IPXA201811306386Lens · damagedL1 DOOR EMERGENCY EXIT LENS HOUSING WAS DAMAGED. ACCOMPLISHED EO MD11-02520-70732-A SECTION 6.A.SDR AALA201811299023Power Supply · inoperativeTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS WILL NOT TEST OK ON CIDS PANEL. REPLACED RIGHT HAND MID EMERGENCY LIGHT POWER SUPPLY UNIT 12WL PER MM 33-51-38-0401. OPERATIONS CHECK OK.SDR FDEA201811283388Battery Pack · dischargedL1 DOOR SLIDE LIGHT INOP. R&R EMERGENCY BATTERY PACK M731 PER MM 33-51-07-2, PN 2013-1A S/N 54663.SDR SIMA201811298005Light · inoperativeLH OVERWING LIGHT INOP-C/A-REMOVED AND REPLACED LH OVERWING LIGHT IAW EMB 140 AMM 33-50-10 OPS CK GOODSDR SWAA2018112927204Battery · failedEMERGENCY LIGHT BATTERY AT LOCATION M1675 FAILED CAPACITY TEST. R&R BATTERY PER AMM.SDR DALA2018112986921Lens · missing(LOG 5081930) DURING INSPECTION FOUND EMERGENCY EXIT SIGN BY ROW 22 FWD LENS MISSING. REINSTALLED FWD EMERGENCY EXIT SIGN AS PER B737 AMM 11-32. A/C OK FOR SVC.SDR DALA2018112986896Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE AT SEATS 22-27 AND ROW 30-37. REPLACED BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR DALA2018112906882Light · unknown(AIRCRAFT 7101, L/P 0844175) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:405 / INTERIOR. ALL 405 AREA LIGHTING CHECKED SATIS PLEASE REPORT FURTHER PASS SEATS: 405.SDR SIMA201811298002Light · wornPHOTOLUMINESCENT INDICATOR STRIPS WORN AT FWD GALLEY CLOSET AND SEATS 9DF-10DF AND 14DF-C/A-REMOVED AND REPLACED PHOTOLUMINESCENT INDICATOR STRIPS AT FWD GALLEY CLOSET AND SEATS 9DF-10DF AND 14DF IAW AMM 33-50-21. NO FURTHER DEFECTS NOTED.SDR DALA2018112906878Light · missingEMERGENCY PATH LIGHT STRIP ON FLOOR BY SEAT 1B IS MISSING. REPLACED EMERGENCY PATH LIGHT STRIP PER B717 AMM 33-51. (LP4717872)SDR MASA2018112811557Light · inoperativeROW 6 EMERGENCY FLOOD LIGHT INOP. PLACED ON MELSDR MASA2018112871556Bulb · inoperativeSERVICE DOOR EMER EXIT LIGHT BULB INOP. RELAMPEDSDR ASAA2018122477539Lamp · inoperativeEMERGENCY EXIT LIGHT ON MAIN CARGO DOOR OUT. GROUNDED - YES. RELAMPED EMERGENCY EXIT LIGHT ON MAIN CARGO DOOR OUT & OPS CHECKS GOOD IAW B737-700 AMM 33-51-04-960-801.SDR SWAA2018120527389Lens · crackedLT STOWBINS EMERGENCY LIGHT LENSES CRACKED BETWEEN ROW 1 TO ROW 17. R&R LENS IAW AMM.SDR SWAA2018120527384Lens · crackedRT STOWBINS EMERGENCY LIGHT LENSES CRACKED BETWEEN ROW 6 TO ROW 22. R&R LENS IAW AMM.SDR DALA201811306939Charger · inoperative(AIRCRAFT 5655, L/P 5060522) OVERWING EXITS RH SIDE ROW 26/27 DEF BOTH LOWER EMERGENCY LIGHT SIGNS INOP. REMOVED AND REPLACED RT OVERWING EXIT SIGN CHARGER IAW 33-51-07.SDR AALA2018113099024Battery · no testCIDS 1 EPSU FAILED A SYSTEM TEST. REPLACED THE BATTERY 12WL IAW AMM 33-51-38.SDR AALA2018113099017Battery · no testCIDS 1 EPSU FAILED A SYSTEM TEST. REPLACED THE BATTERY 10WL IAW AMM 33-51-38.SDR DALA2018112806926Battery · dischargedEPSU BATTERY R MESSAGE IN CIDS DIRECTOR, FOUND BATTERY FAULT LIGHT ON R EMER ESCAPE HATCH EPSU 12WL, REPLACED EPSU BATTERY.SDR DALA2018112806925Light · inoperativeROW 20 EMERGENCY LIGHT ON SEAT FRAME INOP. REPLACED ROW 29 LIGHT ASSY.SDR DALA2018112806924Light · inoperativeFWD CLOSET EMERGENCY LIGHT INOP. REPLACED LIGHT ASSY.SDR DALA2018112806923Light · shortedEPSU EXT LOAD, FOUND SHORT THROUGH LEFT OFF WING SLIDE EMERGENCY LIGHT FIXTURE, REPLACED.SDR AALA20181129004Battery Pack · no testCABIN EMERGENCY LIGHT BATTERY PACK M33406 WOULD NOT CHARGE. REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-802, AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-06-960-802.SDR SWAA2018112927222Light · inoperativeEMERGENCY EXIT LIGHT ABOVE FLIGHT DECK DOOR BULBS INOP. R&R BULBS PER AMM.SDR SWAA2018112927198Light · inoperativeL2 DOOR EXTERNAL EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR DALA2018112986886Light · inoperativeSHIP 3831 SEAT 29D UNDERSEAT EMER LIGHT INOP . CORRECTIVE ACTION: REPLACED EMERGENCY LIGHT HOUSING AT SEAT 29D EMERGENCY LIGHT OPS NORMAL PER B737 AMM 33-51. (4753912).
Back to JASC 3350