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 SWAA2019052032804Battery Pack · dischargedL2 DOOR EMERGENCY LIGHT WILL NOT TURN ON. R&R BATTERY PACK PER AMM.SDR SWAA2019052032799Cover · missingLT SIDE OVER AFT GALLEY EMERGENCY EXIT COVER MISSING. R&R LIGHT ASSEMBLY PER AMM.SDR DALA2019052003084Housing · detachedPATH LIGHT AT SEAT 24D DETACHED, REPLACED EMERGENCY LIGHT HOUSING AT SEAT 24D.SDR DALA2019051903078Light · inoperativeEMER. LIGHT @ PAX 14D INOP. RELAMPED SAME CKS GOOD. (LP5722120)SDR MASA2019051911859Light · inoperativeROW 15 CEILING EMER LIGHT INOP. RELAMPED.SDR AALA20190518007Battery Pack · faultyAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS INSTALLING NEW EEL BATTERY PACK, OPS CHECK WAS GOOD. 5 HOURS LATER SHOWED FAULT LIGHT, TESTED BAD. REPLACED WITH NEW BATTERY PACK. 12 HOURS RECHECK WAS GOOD.SDR R61A201905180533Battery · dischargedEMERGENCY EXIT LIGHT NEAR L2 DOOR INOP. FERRIED TO MIA. R&R AFT LT EMERGENCY LIGHT BATTERY REF AMM 33-50-01.SDR ASAA2019051829398Lens · detachedF/A REPORTS EXIT SIGN LENS COVER MISSING @ 17A. GROUNDED - YES. INSTALLED NEW EXIT SIGN LENS COVER @ 17A.SDR AALA201905199010Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT INOPERABLE AT SEAT 6C. MAINTENANCE REPLACED LIGHT PER AMM 33-51-19.SDR IPXA2019051842236Light · brokenINSPECTION TYPE:NA DURING INSPECTION (PS-1) FOUND EMERGENCY LIGHT ASSY TYPE A EXIT ON COCKPIT ENTRY DOOR BROKEN. REPLACED EMERGENCY LIGHT ASSY TYPE A IAW AMM 33-51-01-201 REV 126.03. PN ON: 82000-08704, SN ON: TAG 00931316. EFF REF IPC 52-11-02-10A ITEM75 REV SDR SWAA2019052032883Battery Pack · dischargedLOWER FUSELAGE, AFT OF RT WING, GROUND ILLUMINATION EXIT LIGHTS INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2019052032882Power Supply · inoperativeLOWER FUSELAGE, AFT OF RT WING, GROUND ILLUMINATION EXIT LIGHTS INOP. R&R POWER SUPPLY IAW AMM.SDR SWAA2019052032881Battery Pack · dischargedLOWER FUSELAGE, AFT OF LT WING, GROUND ILLUMINATION EXIT LIGHTS INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2019052032834Power Supply · inoperativeLOWER FUSELAGE, AFT OF LT WING, GROUND ILLUMINATION EXIT LIGHTS INOP. R&R POWER SUPPLY IAW AMM.SDR SWAA2019052433011Housing · damagedR2 DOOR EMERGENCY EXIT LIGHT HOUSING DAMAGED. R&R LIGHT HOUSING IAW AMM.SDR DALA2019051703121Lens · missingFOUND EMER DOME LIGHT OVERHEAD CENTER ISLE MISSING LENS COVER, REPLACED MISSING LIGHT LENS.SDR YENA201905170279Battery · dischargedFT # 391, BOS-TPA. EMERGENCY LIGHT TEST FAILED BATTERIES AT 10WL AND 12WL; REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES AT 10WL AND 12WL PER AMM 33-51-38.SDR YENA201905170278Battery · dischargedFT # 391, BOS-TPA. EMERGENCY LIGHT TEST FAILED BATTERIES AT 10WL AND 12WL; REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES AT 10WL AND 12WL PER AMM 33-51-38.SDR REXA2019051700698Light · inoperativeDURING WALK AROUND FOUND LT FWD EXT EMERGENCY EXIT LIGHT INOP. RELAMPED LT FWD EXT EMERGENCY EXIT LIGHT IAW AMM 33-51-21 OPS CHECK GOOD.SDR SWAA2019052132894Light · inoperativeEMERGENCY EXIT LIGHT AFT OF L1 DOOR INOP. REPAIRED EXIT LIGHT ELEC WIRING PER AMM.SDR AALA201905199022Light · burnedAIRCRAFT IN BASE MAINTENANCE: BURNED EMERGENCY EXIT PATH LIGHT AT FORWARD GALLEY AREA. MAINTENANCE REPLACED PATH LIGHT PER AMM 33-51-17-400-001-A.SDR AALA201905199020Lens · missingAIRCRAFT WAS NOT GROUNDED: 12D FORWARD EMERGENCY LIGHT LENS MISSING. MAINTENANCE REPLACED LIGHT PER AMM 33-51-05.SDR AALA201905199014Light · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT 22C EMERGENCY LIGHT INOPERABLE. MAINTENANCE REPLACED LIGHT PER CMM 25-22-50.SDR AALA201905199012Lens · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY AISLE LIGHT 34C LENS MISSING. MAINTENANCE REPLACED EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-18.SDR AALA20190517004Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: OVERWING EMERGENCY LIGHT INOPERABLE IN CABIN. REPLACED BATTERY PACK PER STANDARD PRACTICES.SDR N6WA2019051702Light · inoperativeEMERGENCY FLOOD LIGHT AT ROW 15 INOP.SDR SWAA2019052032857Power Supply · inoperativeLT OVERWING EMERGENCY EXIT LIGHT INOP AT ROW 6. R&R POWER SUPPLY M1668 PER AMM.SDR SWAA2019052032856Lens · unsecureLT OVERWING EMERGENCY EXIT LIGHT LENS FELL OFF. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2019052032855Lens · unsecureOVERHEAD EXIT SIGN AT OVERWING EXIT ROW LENS FELL OFF. INSTALLED SIGN PER MM.SDR SWAA2019052032843Battery Pack · failedAFT CABIN RT EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2019052032842Sign · brokenCABIN OVERWING CEILING CENTER AISLE EXIT SIGN MOUNT BROKEN AT ROW 11. R&R SIGN PER MM.SDR SWAA2019052032841Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01672. R&R BATTERY PER MM.SDR SWAA2019052032806Sign · missingRT OVERWING EMERGENCY EXIT LOWER LIGHT MISSING DIRECTIONAL ARROW. R&R SIGN IAW MM.SDR SWAA2019052032805Light · missingCENTER CABIN CEILING EMERGENCY EXIT LIGHT MISSING. R&R LIGHT HOUSING IAW AMM.SDR SWAA2019052032803Light · inoperativeRT EMERGENCY EXIT DOOR SIGN LIGHT INOP AT SEAT 12. RELAMPED LIGHT ASSEMBLY PER AMM.SDR SWAA2019052032802Cover · unsecureLT EMERGENCY EXIT LIGHT COVER CAME OFF EXIT ROW. REINSTALLED COVER PER AMM.SDR FDEA201905171092Power Supply · inoperativeMDIS 529 33-50 6878 17MAY19 MEM FACT U DURING EMERGENCY LIGHT TEST, RECIEVED EMER BATT LOW (1). R/I 17MAY19 17:32 MEM U REASON CODE : PREMATURE REMOVAL/INSTALLATION OFF MPN: 60-4411-5 POS: ONL SRL: 0163 TAG NBR: 4G9021 ON MPN: 60-4411-5 CPN: 330SDR SWAA2019051732785Sign · looseOVER WING EXIT SIGN IN CEIL CAME LOOSE ON LANDING. R&R OVER WING EXIT SIGN PER MM.SDR CALA2019051700786Battery Pack · dischargedRED EMERGENCY LIGHTS ON PAX SEATS INOP. REMOVED AND REPLACED CHARGER ASSY AND BATERY PACK IAW AMM 33-51-06-960-805. TEST OK. RED EMERGENCY LIGHTS WORKING GOOD.SDR CALA2019051700781Battery · inoperativeTEST FOUND RT DOOR 3 EMER BATTERY DM33401 INOP REF NON-ROUTINE NO.9481334 - EA 2500-04866D OP021. REPLACED RT DOOR 3 EMERGENCY LT BATTERY, C/OUT INSTALLATION TEST OF THE NEW BATTERY, THE RESULT FOUND ''NORMAL'' REF AMM 33-51-06- 960-802 REV.86.SDR CALA2019051700780Battery · dischargedTEST FOUND EMERGENCY LIGHT M33097 CAPACITY LOW REF NON-ROUTINE NO.9479212 - EA 2500-04866D OP021. REPLACED EMERGENCY LT BATTERY M33097, C/OUT INSTALLATION TEST OF THE NEW BATTERY, THE RESULT FOUND ''NORMAL'' REF AMM 33-51-06-960- 802 REV.86.SDR SWAA2019052032880Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01675. R&R BATTERY PACK PER AMM & DWG.SDR SWAA2019052032879Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01674. R&R BATTERY PACK PER AMM & DWG.SDR SWAA2019052032878Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01673. R&R BATTERY PACK PER AMM & DWG.SDR SWAA2019052032877Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01672. R&R BATTERY PACK PER AMM & DWG.SDR SWAA2019052032876Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01669. R&R BATTERY PACK PER AMM & DWG.SDR SWAA2019052032858Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01668. R&R BATTERY PACK PER AMM & DWG.SDR SWAA2019052032840Fuse · blownR1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. R&R FUSE PER AMM.SDR 2WAA2019051600001Battery Pack · dischargedFWD CABIN EMERGENCY LIGHT BATTERY PACK INOP. R/R FWD CABIN EMERGENCY LIGHT BATTERY PACK IAW AMM 33-53-00.SDR DALA2019051603066Light · inoperativeEMERGENCY ESCAPE PATH LIGHT INOP @19D. REPL LIGHT ASSY PER AMM 33-53. OPS CHECK GOOD. (LP5822389)
Back to JASC 3350