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 MASA2016101212449Battery Pack · inoperative4D BULKHEAD EXIT SIGN WILL NOT ILLUMINATE. REPLACED BATTERY PACKSDR HNAA2016101200315Bulb · inoperativeLEFT AFT EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR HNAA2016101200314Bulb · inoperativeMOST AFT CABIN FLOOR EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR HNAA2016101200313Battery Pack · inoperativeEMERGENCY EXIT LIGHT AT PAX DOOR ENTRANCE IS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY 3351-PSI. OPS CHECKED GOOD IAW MM 33-52-00.SDR JJBA20161012014Connector · unsecureROW 18A EMERGENCY AISLE LIGHT INOPERATIVE. SEATED THE CONNECTOR. OPS CHECKED GOOD.SDR DALA2016102107454Battery Pack · dischargedFOUND EMERGENCY LIGHT BATTERY PACK M732 BAD AND REPLACED. SYSTEM OPERATION IS NORMAL.SDR DALA2016102107449Battery Pack · defectiveFOUND EMERGENCY LIGHT BATTERY PACK M738 BAD AND REPLACED. SYSTEM OPERATION IS NORMAL.SDR DALA2016102107448Battery Pack · defectiveFOUND EMERGENCY LIGHT BATTERY PACK M736 BAD AND REPLACED. SYSTEM OPERATION IS NORMAL.SDR SWAA2016101808885Cover · brokenL2 DOOR EMERGENCY EXIT DOOR SIGN LIGHT COVER BROKEN. R & R THE LIGHT IAW AMM.SDR AALA201610149015Light · broken12C EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-10. THE AIRCRAFT WAS GROUNDED.SDR ASOA201610110575Inverter · inoperativeCREW REPORTED THE EMERGENCY EXIT SIGN ABOVE FLIGHT ATTENDANT SEAT DOES NOT LIGHT UP. MX REMOVED AND REPLACED EMERGENCY LIGHT INVERTER WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2016101308750Lens · detachedR1 DOOR EMERGENCY EXIT LIGHT LENS FELL OFF. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2016101308743Battery · no testAFT RIGHT BATTERY FAILED TIME TEST. R & R BATTERY IAW AMM.SDR SWAA2016101308742Battery · no testFORWARD RIGHT BATTERY FAILED TIME TEST. R & R THE BATTERY IAW AMM.SDR SWAA2016101308734Cover · crackedR1 DOOR EMERGENCY EXIT PLASTIC COVER CRACKED. R & R THE COVER IAW MM.SDR SWAA2016101308732Lens · looseLEFT EMERGENCY EXIT BULLNOSE LENS LOOSE AT ROW 10. SECURED LENS IAW AMM.SDR AALA201610139010Lens · faulty4R DOOR EXIT LIGHT COVER. REPLACED EXIT LENS AT 4R DOOR IAW AMM 33-51-13. THE AIRCRAFT WAS NOT GROUNDED.SDR ASAA2016101118280Lamp · inoperativeBAGGAGE BIN EMERGENCY LIGHT AT 17 ABC INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS. OPS CHECKED NORMAL.SDR ASAA2016101118279Lamp · inoperativeL-1 DOOR EMERGENCY EXIT IDENTIFIER HAS INOP LAMPS. ACFT GROUNDED. REPLACED THE LAMPS. OPS CHECKED NORMAL.SDR ASAA2016101118278Battery Pack · failedWHILE COMPLETING TC 78233001, FOUND FWD AND REAR OVERHEAD LIGHTS, L1 OUTSIDE LIGHT, L1 ABOVE AND SIDE LIGHTS, L2 OUTSIDE LIGHT, L2 OVERDOOR AND SIDE LIGHT, R2 OUTSIDE LIGHT, AND R2 SIDE LIGHT DID NOT STAY ON FOR NECESSARY 15 MINUTES. ACFT GROUNDED. REMOVED ASDR ASAA2016101118277Bulb · failedEMERGENCY LIGHT LAVATORY AREA FLOODLIGHT ON AFT WINDSCREEN ADJACENT TO LAVATORY D HAS MULTIPLE LAMPS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-01-960-801. OPS NORMAL.SDR ASAA2016101118276Bulb · failedEMERGENCY LIGHT EXIT LOCATOR SIGN ADJACENT TO L-1 DOOR HAS MULTIPLE LAMPS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-01-960-801. OPS NORMAL.SDR SWAA2016101208704Sign · brokenAFT GALLEY DOOR EXIT SIGN BROKEN. REPAIRED SIGN PER SIP.SDR SWAA2016101208703Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER AMM AND DWG.SDR SWAA2016101208702Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PER AMM AND DWG.SDR SWAA2016101208701Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM AND DWG.SDR SWAA2016101208700Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM AND DWG.SDR SWAA2016101208690Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK CHARGER BASE UNIT FAILED FUNCTIONAL CHECK AT M01670. R&R BATTERY PACK PER AMM.SDR SWAA2016101208689Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM AND DWG.SDR REXA2016101101926Light · missingAIRCRAFT IS MISSING THE MOST FORWARD EMERGENCY LIGHTING ON THE LEFT SIDE OF THE AIRCRAFT. INSTALLED A NEW EMERGENCY LIGHT IAW AMM 33-51-01. OK FOR SERVICE.SDR IPXA2016101209293Battery Pack · inoperativeBATTERY PACK WILL NOT STAY ON LONGER THAN ONE MINUTE. R & R THE BATTERY PACK IAW AMM 33-51-07-902-001.SDR IPXA2016101109264Battery Pack · damagedINSPECTION TYPE: MT, EMERGENCY BATTERY PACK WILL NOT STAY ON LONGER THAN ONE MINUTE. R & R THE BATTERY PACK IAW AMM 33-51-07-902-001.SDR R61A201610110582Light · looseMAINTENANCE REPORTED THAT THE EMERGENCY LIGHT STRIP NEAR SEAT 1 D & F WAS LOOSE. MAINTENANCE SECURRED THE STRIP IAW AMM AND OPS CHECKED GOOD.SDR DALA2016101107183Battery Pack · inoperativeFWD GALLEY EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-53. OPS CHECKED GOOD.SDR DALA2016101207173Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY EXIT SIGNS AT BOTH OF THE AFT OVERWING HATCHES WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERIES. OPS CHECKED GOOD.SDR MASA2016101012444Bulb · inoperative12F EXIT SIGN ONE BULB INOPERATIVE.SDR SWAA2016101108644Light · inoperativeRIGHT OVERHEAD BIN EMERGENCY LIGHT INOPERATIVE AT ROW 6. R & R THE LIGHT IAW MM.SDR AALA20161015001Power Supply · lowAIRCRAFT IN BASE MAINTENANCE. LEFT AFT CABIN DOOR 2 EMERGENCY LIGHTS POWER SUPPLY M33099 LOW CAPACITY. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06, WDM 33-51-61 AND WDM 33-51-63. OPERATIONAL CHECKED GOOD.SDR AALA201610139003Lens · brokenAIRCRAFT WAS NOT GROUNDED. BROKEN LENS ON EMERGENCY LIGHT AT SEAT 22L. REPLACED EMERGENCY LIGHT IAW AMM 33-51-19.SDR SWAA2016101308745Fuse · inoperativeOVERWING EXIT SIDEWALL EXIT LIGHT INOPERATIVE. R & R THE FUSE IAW AMM.SDR SWAA2016101308730Cover · looseFORWARD EXIT SIGN COVER LOOSE. SECURED THE COVER IAW AMM.SDR SWAA2016101308727Fuse · inoperativeLEFT EMERGENCY LIGHT INOPERATIVE AT ROW 22. R & R THE FUSE IAW MM.SDR AALA201610139025Lens · missingEXIT PATCH LIGHT AT SEAT 3C LENS MISSING. REPLACED LIGHT LENS EMERGENCY PATH AT SEAT 3C IAW 33-50-00. OPS CK GOOD IAW GPM NO TECH REF SEE TEXT FOR MAINT OR REPAIR DONE. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201610139023Lens · missingFOUND EMERGENCY LIGHT COVER (RED) ON WALL FORWARD OF DOOR 3L MISSING. REPLACED RED LIGHT COVER AT 3L. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201610139022Lens · missingL2 DOOR EXIT LENS. INSTALLED LENS COVER AT L2 DOOR. IPC 33-51-13 IAW GPM NO TECH REF SEE TEXT FOR MAINT OR REPAIR DONE. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201610139012Light · brokenEMERGENCY LIGHT ON SEAT 22L IS BROKEN. REMOVED AND REPLACED SEAT 22L EMERGENCY LIGHT IAW AMM 33-51-19. OP CHECK IS GOOD IAW AMM 33-51-00.SDR DALA2016101107226Power Supply · inoperativeEPSU INT LOAD AFT LT INDICATION, REPLACED AFT LT EMERGENCY POWER SUPPLY UNITSDR AALA20161010012Power Supply · no testEMERGENCY LIGHTS POWER SUPPLY AT 2R DOOR FAILED FUNCTIONAL CHECK CARD 2312. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20161010011Power Supply · no testEMERGENCY LIGHTS POWER SUPPLY AT 4L DOOR FAILED FUNCTIONAL CHECK CARD 2312. REMOVED AND REPLACED POWER SUPPLY AT M33407 IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR SWAA2016101208675Battery · failedFORWARD EMERGENCY BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PER AMM.
Back to JASC 3350