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 SWAA2020040935925Battery Pack · dischargedEEL LIGHT INOP AT 14ABC;17ABC AND BOTH EXTERIOR OVERWING EXITS / REMOVED AND REPLACED EMERGENCY BATTERY PACK AND CHARGER AT STA 727C IAW AMM 33-51-06SDR SWAA2020040935926Light · inoperativeEMERGENCY EXIT LIGHT AT 6DEF INOP / RELAMPED EEL LIGHT AT 6 DEF IAW AMM 33-51-03SDR SWAA2020040936031Battery Pack · dischargedFWD SERVICE DOOR INNER EMERGENCY AND AFT ENTRY DOOR INNER EMERGENCY LIGHTS INOP / REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACKS FWD SVC DOOR INNER & AFT ENTRY DOOR INNER EMERGENCY LIGHTS IAW AMM 33-51-06SDR MASA2020040710147Power Unit · inoperativeL2 DOOR EXIT SIGN LIGHT INOP. R2 ELPUSDR YENA2020040840278Battery · dischargedDURING HEAVY MAINTENANCE, EPSU BATTERY 11WL FAILED OPS TEST; (REF AEROMAN NR 2020-100806 WO 2020 94/1) R & R EPSU BATTERY 11WL PER AMM 33-51-00-710-001-A OPS OK.SDR SIMA2020040604003Light · inoperativeDURING PS-2 FOUND FIRST PROXIMITY FLOOR STRIP AND NUMBER 2 EMERGENCY LIGHT INVERTER INOP-C/A-EMOVED AND REPLACED FIRST PROXIMITY FLOOR STRIP IAW EMB 145 AMM 33-50-12 AND NUMBER 2 EMERGENCY LIGHT INVERTER IAW EMB 145 AMM 33-50-11. OPS CHECK GOOD. INVERTER P/N 7SDR SIMA2020040604001Light · inoperativeEMERGENCY ENTRANCE LIGHT INOP.-C/A-REMOVED AND REPLACED EMERGENCY ENTRANCE LIGHT IAW EMB AMM 33-26-01.OPC GOOD.SDR CALA2020040600791Battery · failedDURING TEST FND ESPU BATT 10WL LOW VOLTAGE REF NON-ROUTINE NO. 9407440 - ORIGINATED SPEC NO.A3NB-33-3-6012. PERFORMED REPLACED THE BATT 10WL AND PERFORMED OPS CHK OF ESPU. THE RESULT FND ''SATIS'' AS PER AMM 33-51-38-000- 002A REV 107, AMM 33-51-38-400-002A RESDR CALA2020040600794Battery · failedDURING TEST FND ESPU BATT 13WL LOW VOLTAGE REF NON-ROUTINE NO. 9407437 - ORIGINATED SPEC NO.A3NB-33-3-6012. PERFORMED REPLACED THE BATT 13WL AND PERFORMED OPS CHK OF ESPU. THE RESULT FND ''SATIS'' AS PER AMM 33-51-38-000- 002A REV 107, AMM 33-51-38-400-002A RESDR CALA2020040600793Battery · failedDURING TEST FND ESPU BATT 12WL LOW VOLTAGE REF NON-ROUTINE NO. 9407438 - ORIGINATED SPEC NO.A3NB-33-3-6012. PERFORMED REPLACED THE BATT 12WL AND PERFORMED OPS CHK OF ESPU. THE RESULT FND ''SATIS'' AS PER AMM 33-51-38-000- 002A REV 107, AMM 33-51-38-400-002A RESDR CALA2020040600792Battery · failedDURING TEST FND ESPU BATT 11WL LOW VOLTAGE REF NON-ROUTINE NO. 9407439 - ORIGINATED SPEC NO.A3NB-33-3-6012. PERFORMED REPLACED THE BATT 11WL AND PERFORMED OPS CHK OF ESPU. THE RESULT FND ''SATIS'' AS PER AMM 33-51-38-000- 002A REV 107, AMM 33-51-38-400-002A RESDR DALA2020040602180Battery Pack · dischargedDURING SERVICE CHECK FOUND BACK CEILING EMERGENCY LIGHTS OUT EXTENDING FROM ROW 35A INTO AFT GALLEY. REPLACED BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR DALA2020040602149Battery · dischargedDURING THE SERVICE CHECK THE EMERGENCY LIGHTS AT LOCATION B5-107 WERE FOUND TO INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT BATTERIES FOR LOCATION B5-107 PER MD88 AMM 33-53. OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT RETURNED TO SERVICE. (LP #5497222 )SDR SIMA2020061843004Light · damaged#4 FLOOR PROXIMITY LIGHT FWD INCERT DAMAGE. REMOVED AND REPLACED # 4 FLOOR PROXIMITY LIGHT FWD INSERT IAW EMB 140 AMM 25-00-00 SN8281SDR SIMA2020051403003Light · inoperativeSERVICE DOOR EMERGENCY LIGHT IS INOP-C/A-REMOVED AND REINSTALLED SERVICE DOOR EXTERNAL EMERGENCY LIGHT LAMP IAW EMB 145 AMM 33-50-10. OPS-CK GOOD.SDR YENA2020040730277Light · failedFT # 6140, EWR-JFK. AS PER TC A320-25-62-44-400-007 OPERATIONAL TEST OF EMERGENCY LTS FAILED ( EPSU EXT LOAD EMERG L); R & R LH AFT EMERGENCY LIGHT ASSY IAW AMM 33-51-00 OPS TEST OKSDR YENA2020040730276Battery · failedFT # 1802, FLL-JFK. REF T/C A320-33-51-00-710-003 EPSU BATTERY 14WL AND 15WL FAIL BATTERY CAP TEST; R & R EPSU BATTERY 14WL AND 15WL BITE GOOD. NO FAULTS NOTED PER MM 33-51-00SDR YENA2020040730275Battery · failedFT # 1802, FLL-JFK. REF T/C A320-33-51-00-710-003 EPSU BATTERY 14WL AND 15WL FAIL BATTERY CAP TEST; R & R EPSU BATTERY 14WL AND 15WL BITE GOOD. NO FAULTS NOTED PER MM 33-51-00SDR YENA2020040730274Battery · failedFT # 1802, FLL-JFK. REF T/C A320-33-51-00-710-003 EPSU BATTERY 12WL AND 11WL FAIL BATTERY CAP TEST; R & R EPSU BATTERY 11WL AND 12WL BITE GOOD. NO FAULTS NOTED REF MM 33-51-00SDR YENA2020040730273Battery · failedFT # 1802, FLL-JFK. REF T/C A320-33-51-00-710-003 EPSU BATTERY 12WL AND 11WL FAIL BATTERY CAP TEST; R & R EPSU BATTERY 11WL AND 12WL BITE GOOD. NO FAULTS NOTED REF MM 33-51-00SDR YENA2020040730272Battery · failedFT # 1802, FLL-JFK. REF T/C A320-33-51-00 EPSU BATTERY 13WL AND 10WL FAILED BAT CAP TEST; R & R EPSU BATTERY 13WL AND 10WL BITE GOOD. NO FAULTS NOTED REF MM 33-51-00SDR YENA2020040730271Battery · failedFT # 1802, FLL-JFK. REF T/C A320-33-51-00 EPSU BATTERY 13WL AND 10WL FAILED BAT CAP TEST; R & R EPSU BATTERY 13WL AND 10WL BITE GOOD. NO FAULTS NOTED REF MM 33-51-00SDR SWAA2020040735757Powerpack · inoperativeEMERGENCY EXIT CABIN & EXTERIOR L/H EMERGENCY LIGHTS INOP / R/R EMERGENCY LIGHTING POWER PACK AT SEAT ROWS 11ABC & 17ABC. OPS CK GOOD IAW AMM 33-51-06SDR DALA2020040602200Epsu · faulty(AIRCRAFT 3170, L/P 6982502) ON SERVICE CHECK FOUND EPSU 11WL UNIT FAULT LIGHT ON. CORRECTIVE ACTION: REMOVED AND REPLACED EPSU 11WL AS PER A320 AMM 33-51-38.SDR SIMA2020040603002Light · inoperativeMAIN DOOR EMERGENCY LIGHT LAMP INOP-C/A-REMOVED AND REOLACED MAIN DOOR EMERGENCY LIGHT LAMP IAW EMB 145 AMM 33-50-06. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED.SDR AALA2020040659003Power Supply · inoperativeDONT PASS TEST EPSU-EMERGENCY POWER SUPPLY UNIT 13WL ON PASSENGER CREWDOOR 2L IN PASSENGER CABIN (1 EA). REPLACED EPSU 13WL ON PASSENGER CREW DOOR 2L IAW AMM 33-51-38-400-801-A.SDR CALA2020040300787Light · inoperativeEMER EXIT LOCATOR SIGN JUST AFT OF DOOR 2RH INOP. REPLACED LIGHT ASSY REF AMM 33-51-01-960-802 OPS CHECKED OK. INSPECTED EMER LOCATOR SIGN REF ANN 33-51-01-960-802SDR JJBA20200403001Placard · inoperativeSERVICE DOOR FWD EXIT IDENTIFIER EMERGENCY LIGHT INOPERATIVE. R&R SERVICE DOOR FWD EMERGENCY ILLUMINATING PLACARD. OPS CHECK SATSDR SWAA2020040635556Battery Pack · dischargedAFT RIGHT EMERGENCY LIGHTS INOP / REMOVED AND REPLACED AFT RIGHT EMERGENCY BATTERY PACK IN REF. TO AMM 33-51-06. OPS CHECKS GOOD.SDR AALA202004069024Control Unit · malfunctionedAIRCRAFT IN BASE VISIT: R2 EMERGENCY EXIT LIGHTS INOPERATIVE. PERFORMED SOFTWARE INSTALLATION OF WCU IAW DMC-B787-A-33-51-07-04A-750A-A.SDR AALA202004059008Battery Pack · dischargedAIRCRAFT IN BASE VISIT: R1 DOOR EXTERIOR LIGHT INOPERATIVE. REPLACED BATTERY PACK M2816 IAW AMM 33-51-06.SDR VNAA2020040411103Battery Pack · dischargedAFT EMERGENCY EXIT DOORS LIGHT WONT ILLUMINATE.REMOVED AND REPLACED #4 EPSU BATTERY PACK IAW AMM. OPS CHECKS GOOD.SDR SIMA202004032001Light · inoperativeMAIN DOOR EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED MAIN DOOR EMERGENCY LIGHT BULB IAW EMB 140 AMM 33-50-10. OPS CHECK GOOD.SDR CALA2020040300782Battery Pack · failedB777-33-3-7015 NO.4 RH DR M33401 EMER PWR BATTERY PACK CAPACITY CHK FAIL (LESS THAN 5MINS) REFER NR LP 9130097 NO.4 R/H DR M33401 EMER PWR BATTERY PACK REPLACED AND CHECKED FOUND NORMAL AS PER AMM 33-51-06SDR CALA2020040300781Battery · failedB777-33-3-7015 NO.2 DR R/H M33097 EMER PWR BATTERY PACK CAPACITY CHK FAIL (LESS THAN 15MINS) REFER NR LP 9130098 NO.2 DR R/H M33097 EMER PWR BATTERY PACK REPLACED AND CHECK NORMAL IAW AMM 33-51-06SDR IPXA2020040353834Light · inoperativeINSPECTION TYPE:N/ADURING AS-E FOUND CEILING ENTRY EMERGENCY LT INOP.LAMP CORRECTED AND TESTED SATIS IAW AMM 33-51-11 R. 129.02SDR KCSA202004021036Light · inoperativeR/H UPPER DECK DOOR BATTERY OK LIGHT WILL NOT TESTSDR KCSA202004021035Light · inoperativeL/H UPPER DECK DOOR BATTERY OK LIGHT WILL NOT TESTSDR AALA202004029011Light · disconnectedAIRCRAFT WAS NOT GROUNDED: EMERGENCY PATHWAY LIGHT INOPERABLE AT ROW 20LT (LIGHT ASSEMBLY REPLACED, NO EFFECT). MAINTENANCE RECONNECTED LIGHT AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-18-400-001-A.SDR UIEA2020040200511Light · inoperativeU/D L/H EMERGENCY EXIT DOOR AFT SLIDE LIGHT FOUND INOP.(<P>U/D L/H EMERGENCY EXIT DOOR AFT SLIDE LIGHT ASSY REPLACED. OPERATIONAL CHECK NORMAL IAW AMM 33-51-06.</P>)SDR UIEA2020040200512Light · inoperativeL5 DOOR SLIDE LT FOUND INOP.(<P>DOOR L5 SLIDE LIGHT BULB REPLACED. OPERATIONAL CHECK NORMAL IAW AMM 33-51-06.</P>)SDR UIEA2020040200513Light · inoperativeAFT CREW REST CEILING EMERGENCY LIGHT FOUND INOP.(<P>AFT CREW REST CEILING EMERGENCY LIGHT REPLACED. INSTALLATION TEST NORMAL IAW AMM 33-51-07.</P>)SDR UIEA2020040200514Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK (M5057)CAPACITY TEST FAILED.(<P>EMERGENCY LIGHT BATTERY PACK (M5057) REPLACED. INSTALLATION TEST NORMAL AMM 33-51-12.</P>)SDR UIEA2020040200515Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK (M7922) CAPACITY TEST FAILED.(<P>EMERGENCY LIGHT BATTERY PACK REPLACED (M7922). INSTALLATION TEST NORMAL AMM 33-51-00.</P>)SDR UIEA2020040200516Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK (M7920) CAPACITY TEST FAILED.(<P>EMERGENCY LIGHT BATTERY PACK (M7920) REPLACED. INSTALLATION TEST NORMAL AMM 33-51-00.</P>)SDR UIEA2020040200517Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK (M7924) CAPACITY TEST FAILED.(<P>EMERGENCY LIGHT BATTERY PACK (M7924) REPLACED. INSTALLATION TEST NORMAL AMM 33-51-00.</P>)SDR UIEA2020040200519Light · inoperativeL3 DOOR SLIDE LT FOUND INOP.(<P>L3 DOOR SLIDE LT REPAIRED AND OP TEST NORMAL AS PER AMM 33-51-06.</P>)SDR UIEA2020040200520Light · inoperativeL4 DOOR SLIPE LT FOUND INOP.(<P>L4 DOOR SLIDE LT REPAIRED AND TEST NORMAL AS PER AMM 33-51-06.</P>)SDR UIEA2020040200525Light · inoperativeR5 DOOR SLIDE LT FOUND INOP.(<P>R5 DOOR SLIDE LIGHT LAMP REPLACED OPERATION CHECK NORMAL AMM 33-51-06.</P>)SDR UIEA2020040200526Fuse · blownU/D R/H EMERGENCY EXIT AFT SLIDE LIGHT FOUND INOP.(<P>U/D R/H EMERGENCY EXIT AFT SLIDE LT FUSE REPLACED AND LAMP TEST NORMAL IAW AMM 33-51-00.</P>)
Back to JASC 3350