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 AALA201705019011Lens · missingR4 DOOR MISSING EMERGENCY EXIT LIGHT LENS. INSTALLED THE LENS. AIRCRAFT NOT GROUNDED.SDR AALA201705019010Lens · missingCREW REPORTED THE L1 DOOR EMERGENCY LIGHT LENS MISSING. INSTALLED THE LENS. AIRCRAFT NOT GROUNDED.SDR AALA201705019009Battery Pack · dischargedFLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REPLACED THE BATTERY PACK. AIRCRAFT NOT GROUNDED.SDR IPXA2017042816600Bulb · inoperativeEMERGENCY LIGHTS AT THE L1 DOOR ARE INOPERATIVE. REPLACED THE BULBS. OPS CHECKED GOOD IAW AMM 31-51-05-962-031.SDR CALA2017042801192Power Supply · faulty1L LOWER EMER EXIT LIGHT IS FLICKERING ON AND OFF . EMER LIGHTS SWITCH IN THE ARMED POSITION. REMOVED AND REPLACED BATTERY POWER SUPPLY M1557 AWM 33-5-14 PG 2A OPS CHECK GOOD.SDR CALA2017042801191Light · brokenM1 GALLEY CTR LT & M2 GALLEY CTR RT 2EA LWR EMER LIGHTS FOUND BROKEN. REPLACE M/D A1 GALLEY CTR LT & M2 GALLEY CTR RT LWR EMER LIGHTS AND CARRY OUT OPERATION TEST FOUND NORMAL PER AMM 33-51-05-960-802 REV 79.SDR CALA2017042801190Battery Pack · dischargedSPEC NO. B777-33-3-6019 PER M/D R1 DOOR EMER LT POWER PACK(M33094) 1EA FOUND LWR CAPACITY. REPLACE M/D R1 PER EMER LT POWER PACK AND C/O OPERATION TEST FOUND NORMAL PER AMM 33-51-06-960-802 REV 79.SDR CALA2017042801189Light · brokenA4 GALLEY CTR 3E A LWR EMER LIGHTS FOUND BROKEN. REPLACE M/D A4 GALLEY CTR 3EA LWR EMER LIGHTS AND C/O OPERATION TEST FOUND NORMAL PER AMM 33-51-05-960-802 REV 79.SDR CALA2017042801188Light · brokenA & B ZONE PARTITION TTL 4EA LWR EMER LIGHTS FOUND BROKEN. REPLACE M/D ''A''&''B'' ZONE PARTITION LWR EMER LIGHTS AND CARRY OUT OPERATION TEST FOUND NORMAL AS PER AMM 33-51-05-960-802 REV 79.SDR CALA2017042801187Battery · dischargedUPPER DECK SLIDE LIGHT (RIGHT SIDE) INOPERATIVE. REPLACED FWD BATTERY, OPS CKED OK.SDR CALA2017042801186Battery · dischargedUPPER DECK EXIT DOOR LT SIDE BATTERY LIGHT INOP. REPLACED BATTERY ASSEMBLY PER AMM 33-51-04, SYSTEM WORKS NORMALLY. LIGHT OPS CHECKS OK.SDR CALA2017042801171Battery Pack · failedEMERGENCY LIGHT BATTERY PACK M1674 FAILED FUNCTIONAL CHECK. REMOVED AND REPLACED FWD EMERGENCY LIGHT BATTERY PACK M1674 IAW AMM 33-51-06 OPS CHECK GOOD.SDR CALA2017042801176Power Supply · inoperativeEMERGENCY LIGHT OUT AT ROWS 42,43,44 DEF. R&R POWER SUPPLY AND BATTERY PACK FOR SEATS 42,43,44 DEF IAW AMM 33-51-07-022-005-001 AND AMM 33-51-07-402-018-001. OPS CHK GOOD.SDR CALA2017042801174Battery Pack · dischargedEMERGENCY EXIT LIGHTS INOP AT ROWS 22-27 ABC. REMOVED AND REPLACED BATTERY PACK FOR ROWS 22-27 ABC AS PER AMM 33-51-0-201. OPS CHECK GOOD.SDR CALA2017042801172Battery Pack · dischargedDOOR ONE LT EXIT EMERGENCY LT INOP. REPLACED DOOR 1L EXIT EMERGENCY BATTERY PACK REF AMM 33-51-06-610. CHECKS GOOD.SDR CALA2017042801165Battery · dischargedEEL TEST 2 SV, FAILS EPSU BATTERY AFT L. REPLACED EPSU BATTERY AFT LEFT, REF AMM 33,51-38. EEL TEST PASS.SDR CALA2017042801163Battery · not seatedEPSU BATTERY EMER L CIDS MESSAGE DISPLAYED AFTER TEST ATA 33-51-38. RESET THE EPSU BATTERY, SYSTEM CHECKED OK PER MM 33-51-00.SDR CALA2017042801170Ballast · faultyOVERWING EXIT LIGHT ABOVE EXIT SEAT 20F BURNT OUT. REMOVED AND REPLACED OVERWING EXIT BALLAST AND BULB. 20F SIDEWALL LIGHT OK FOR SERVICE.SDR CALA2017042801185Light · dislodged1R FLOOR LEVEL EMERG EXIT LIGHT DISLODGED. RESECURED LIGHT.SDR CALA2017042801183Lens · brokenEMERGENCY LIGHT LENS BROKEN AT SEATS 20C AND 31C. REPLACED LENS.SDR CALA2017042801181Light · inoperativeLEFT FWD EMERGENCY OVERWING LIGHT INOP RELAMPED, OPS CKD NORMAL. OK TO CONTINUE.SDR CALA2017042801179Lens · missing2R DOOR CAP ABOVE EXIT LIGHT IS MISSING. INSTALLED NEW EMERGENCY LIGHT LENS AT 2R.SDR CALA2017042801177Sign · unsecure21A LOWER EMER EXIT SIGN IS HANGING BY WIRES. RESECURED EXIT SIGN. OPS GOOD.SDR CALA2017042801175Lens · brokenROW 20C BROKEN EMERGENCY PATH LITE . REPLACED LENS REF CMM 25-22-51. LIGHTS CHECK OK.SDR CALA2017042801173Light · inoperativeEMERGENCY EXIT LIGHT AT L1 DOOR EXTERIOR, INOP. REPLACE BULB 767, OPS OK.SDR CALA2017042801167Light · inoperativeSLIDE LIGHT AT DOOR 4L INOP. REMOVED AND REPLACED SLIDE LT ASSY AT 4L. OPS CHECK GOOD.SDR CALA2017042801166Light · inoperative1R SLIDE LIGHT INOP. RELAMPED R1 DOOR SLIDE LIGHT. OPS CHECK GOOD.SDR CALA2017042801164Light · malfunctionedEMER LIGHTS ARE ON IN THE CABIN NO MATTER WHAT POS THE SWITCH IS IN. TURNED OFF LIGHT AT 2L.SDR SIMA20170427006Charger · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE NR 2 BATTERY AND CHARGER IAW AMM 33-50-04 AND AMM 33-26-00. OPERATIONAL CHECKED GOOD.SDR SIMA20170427005Battery · inoperativeMAIN DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY 1 AND BATTERY CHARGER 1 IAW AMM 33-50-04 AND AMM 33-26-00. MAIN DOOR LIGHT AND EMERGENCY LIGHTS OPERATIONAL CHECKS GOOD.SDR HNAA2017042500138Bulb · inoperativeF/A PANEL EMERGENCY LIGHT SWITCH NORM INDICATING BULB INOPERATIVE. R & R THE BULB.SDR AALA20170428005Battery Pack · dischargedBATTERY PACK DOES NOT OPERATE EMERGENCY LIGHTS FOR A MINIMUM 10 MINUTES. REMOVED AND REPLACED BATTERY PACK AT LOCATION M33094 FOR FIRST CLASS SEATS IAW AMM 33-51-06 OPS CK NORMAL. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170428004Lens · missingSEAT 20C EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 20C IAW AMM 33-51-05 OPS CK NORMAL. THE AIRCRAFT WAS NOT GROUNDED.SDR SWAA2017050213506Fuse · blownAFT OF LT OVERWING EMERGENCY EXIT LIGHT INOP. R&R FUSE PER MM.SDR DALA2017050203531Light · brokenFLOOR PROX EMERGENCY ESCAPE PATH MARKING SYSTEM AT 25D IS BROKEN, REPLACED PROXIMITY LIGHT AT 25D.SDR ASAA2017042720577Lens · missingL1 DOOR EXIT IDENTIFIER LENS MISSING. GROUNDED - YES. REPLACED MISSING LENS COVER.SDR AALA201705019020Light · crackedEMERGENCY EXIT LIGHT AT R2 DOOR IS CRACKED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-57-13. OPERATIONAL CHECK GOOD.SDR AALA201705019019Light · crackedEMERGENCY EXIT LIGHT AT L2 DOOR IS CRACKED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-57-13. OPERATIONAL CHECK GOOD.SDR DALA2017043000162Sign · missingEMERGENCY EXIT SIGN MISSING. REPLACED EMERGENCY EXIT SIGN LENS COVER.SDR SWAA2017050113471Lens · missingLEFT OVERWING VERTICAL EMERGENCY EXIT SIGN COVER LENS MISSING. R & R THE LENS ASSEMBLY IAW AMM.SDR SWAA2017050113447Lens · detachedFORWARD GALLEY EMERGENCY EXIT SIGN COVER CAME OFF. REINSTALLED THE LENS IAW AMM.SDR DALA2017042803485Lens · missingFLT ATTENDANT FOUND FRONT CENTER EXIT SIGN LENS MISSING. MAINTENANCE REPLACED THE SIGN LENS. OK FOR SERVICE.SDR CALA2017042801136Light · inoperative47ABC EMERGENCY LIGHT INOP. THE 47ABC EMERGENCY LIGHT REPLACED AND C/O OP TEST. THE RESULT FOUND NORMAL REF AMM 33-50-96-004-001 REV 87 & AMM 33-50-96-704- 006 REV 87.SDR CALA2017042801135Battery · dischargedZONE ''C'' DOOR 3 LT CEILING AREA EMERGENCY LT INOP. M33405 BATTERY REPLACED AND EMERGENCY LT SYSTEM FUNCTIONAL TEST FOUND ''C'' ZONE DOOR 3 LT CEILING AREA EMERGENCY LT ''NORMAL'' REF AMM 33-51-00-710-801 REV 79.SDR AALA201704289015Light · brokenEMERGENCY EXIT LIGHT ON LAVATORY L, PLASTIC COVER BROKEN. REPLACED EMERGENCY EXIT LIGHT IAW ESO 34012. ACCOMPLISHED SATISFACTORY OPS CHECK.SDR AALA201704289014Light · brokenEMERGENCY EXIT LIGHT ON LAVATORY D, PLASTIC COVER BROKEN. REPLACED EMERGENCY EXIT LIGHT IAW ESO 34012. ACCOMPLISHED SATISFACTORY OPS CHECK.SDR AALA201704289013Lens · unsecureL1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN OFF LOWER FASTNER. SECURED EXIT LIGHT LENS IAW AMM 33-51-11. ACCOMPLISHED SATISFACTORY OPS CHECK.SDR AALA201704289029Light · inoperativeEMERGENCY EXIT LIGHT BY L2 DOOR LOWER LEFT IS INOPERATIVE. REMOVED AND REPLACED EXIT LIGHT IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR R61A201704270334Light · inoperativeCOCKPIT EMERGENCY LIGHT INOPERATIVE. R & R THE LIGHT ASSY IAW AMM 33-50-03.SDR HALA2017042800161Light · detachedEMERGENCY LIGHT STRIP NEXT TO SEAT 27H IS DETACHED. ATTACHED THE LIGHT STRIP. OPS CHECKED OK.
Back to JASC 3350