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 AALA20170410004Battery Pack · dischargedDOOR R1 EMER LT POWER PACK M33094 FOUND LOW CAPACITY. DOOR R1 EMER LT POWER PACK M33094 REPLACED. INSTALLATION TEST CARRIED OUT AND RESULT NORMAL IAW AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE.SDR AALA20170410003Power Supply · dischargedDOOR R4 EMER LT POWER PACK M33408 FOUND LOW CAPACITY. DOOR R4 EMER LT POWER PACK M33408 REPLACED. INSTALLATION TEST CARRIED OUT AND RESULT NORMAL IAW AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE.SDR ASOA201704055034Relay · burnedPILOT REPORTED STRONG ELECTRICAL ODOR IN COCKPIT AFTER TAKEOFF, STRONGER A F180. .REMOVED AND REPLACED THE EMERGENCY LIGHT RELAY, OPS CHECKED GOO. ACFT WAS RETURNED TO SERVICE.SDR AALA20170407003Control Unit · faultyAIRCRAFT WAS NOT GROUNDED. AIRPLANE HEALTH MONITORING SERVICING ALERTS RECEIVED FOR WIRELESS EMERGENCY LIGHTING SYSTEM. REMOVED AND REPLACED WELS CONTROL UNIT AT R4 DOOR IAW DMC-B787-A-33-51-07. OPERATIONAL CHECK GOOD.SDR SWAA2017041013049Cover · wrong partL1 DOOR EMERGENCY LIGHT COVER MISSING RED ARROW. R & R THE COVER IAW MM.SDR SWAA2017041013032Cover · wrong partR1 DOOR EMERGENCY LIGHT COVER MISSING RED ARROW. R & R COVER IAW MM.SDR A6WA2017041044905Sign · inoperativeEMERGENCY EXIT SIGN BY SERVICE DOOR WILL NOT ILLUMINATE.SDR AALA201704069015Battery Pack · dischargedONE POWER SUPPLY BATTERY PACK BELOW LIMITS. REMOVED AND REPLACED POWER SUPPLY BATTERY PACK IAW AMM 33-51-06. OPS CKD OK. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704069014Light · damagedEMERGENCY LIGHT COVER DAMAGED AND DISCONNECTED. REPLACED EMERGENCY LIGHT ASSY AND ACCOMPLISHED REQUIRED TEST. ALL TEST NORMAL IAW 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR CALA2017040700860Lamp · inoperativeEMERGENCY LIGHT TEST FAILED. FOUND THE R4 DOOR SLIDE LIGHT LAMP INOPERATIVE. REPLACED THE LAMP AND OPS TESTED NORMAL IAW AMM 33-51-10-962-001, REV 87.SDR CALA2017040700859Lamp · inoperativeEMERGECNY LIGHT OPS TEST FAILED. FOUND L2 & R4 DOOR SILL LIGHT LAMPS INOPERATIVE. REPLACED THE LAMPS AND OPS TESTED NORMAL IAW AMM 33-51-05-962-031, REV 87.SDR CALA2017040700858Bulb · inoperativeEMERGENCY LIGHT FAILED TEST, FOUND THE EMERGENCY LIGHT INOPERATIVE AT AFT ATTENDANT CREW REST. REPLACED THE BULB AND OPS TESTED NORMAL IAW AMM 33-51-07-962-001, REV 87.SDR CALA2017040700857Bulb · inoperativeEMERGENCY LIGHT FAILED TO TEST, FOUND THE UPPER DECK RT DOOR SLIDE LIGHT INOPERATIVE. REPLACED THE BULB AND OPS TESTED NORMAL IAW AMM 33-51-06-962-040, REV 87.SDR CALA2017040700856Bulb · inoperativeEMERGENCY LIGHT FAILED TEST, FOUND 13AB & 14AB SEAT LIGHTS INOPERATIVE. REPLACED THE BULBS AND OP TESTED NORMAL IAW AMM 33-51-12-332-001, REV 87.SDR CALA2017040700854Lamp · inoperativeEMERGENCY LIGHT FAILED TEST, FOUND THE LAMP OPEN. REPLACED THE LAMP AND OP TESTED NORMAL IAW AMM 33-51-07-962-001, REV 87.SDR AALA201704079022Sign · detachedEMERGENCY EXIT SIGN AT ROW 20 HJ IS DETACHED FROM WALL. SECURED THE CAMLOCKS ON PANEL. OPERATIONAL CHECKED GOOD.SDR AALA201704079019Light · not seatedSEAT MOUNTED EMERGENCY LIGHT AT SEAT 35D IS INOPERATIVE. SEATED THE LIGHT ASSEMBLY IAW AMM 33-51-11. OPERATIONAL CHECKED GOOD.SDR AALA201704069023Lens · detachedEMERGENCY EXIT LIGHT AFT GALLEY LEFT SIDE HAS A MISSING LENS COVER. INSTALLED THE LENS. OPERATIONAL CHECKED GOOD.SDR SWAA2017040713010Lens · missingRIGHT EMERGENCY EXIT ROW VERTICAL EXIT SIGN COVER MISSING AT ROW 12. R & R THE LIGHT ASSEMBLY IAW MM.SDR ASAA2017040520375Power Supply · faultedRT AFT OVERWING EXIT AND RT FUSELAGE EMERGENCY LIGHTS INOPERATIVE. ACFT GROUNDED. FOUND POWER SUPPLY FAULTING. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR AALA201704069004Lens · missingAIRCRAFT NOT GROUNDED. RED EMERGENCY EXIT INDICATOR MISSING. AIRCRAFT RIGHT 8D. REPLACED LENS COVER.SDR AALA201704069003Power Supply · inoperativeAIRCRAFT NOT GROUNDED. EMERGENCY BATTERY POWER SUPPLY UNIT NR 2L INOPERATIVE. REPLACED EMERGENCY POWER SUPPLY NR 2.SDR AALA201704069002Cover · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT PATH MARKER L1 DOOR MISSING. REPLACED EMERGENCY PATH LIGHT MARKER COVER.SDR SWAA2017040612973Lens · brokenOVERWING EXIT SIGN PLASTIC LENS BROKEN. SECURED LENS IAW MM.SDR 29GA2017040600001Power Supply · inoperativeEMERGENCY LIGHT ABOVE MAIN CABIN DOOR DOES NOT ILLUMINATE. R & R THE POWER SUPPLY 21LN IAW AMM 33-50-10. EMERGENCY LIGHTS OPS CHECKED NORMAL IAW AMM 33-50-00.SDR SWAA2017040512948Sign · looseRIGHT OVERWING EXIT SIGN LOOSE. SECURED THE SIGN IAW SIP.SDR MASA2017040512720Light · inoperativeROW 5 EMERGENCY CEILING LIGHT INOPERATIVE.SDR MASA2017040512719Light · inoperativeRIGHT EXTERIOR OVERWING MID EMERGENCY LIGHT INOPERATIVE.SDR HNAA2017040500111Light · inoperativeEMERGENCY LIGHTS AFT LEFT EGRESS AND BOTH RT EGRESS INOPERATIVE.SDR HNAA2017040500110Sign · inoperativeCABIN BOTH MID EMERGENCY EXITS LT AND RT HAS INOPERATIVE SIGNS.SDR SWAA2017050213503Sign · brokenAFT GALLEY AREA LAVATORY B WALL EXIT SIGN BROKEN. R & R THE SIGN IAW AMM.SDR HALA2017040500148Cover · unsecureDOOR 3R EXIT SIGN COVER FELL OFF. REPLACED DOOR 3R EXIT SIGN COVER.SDR SWAA2017041013047Lens · discoloredRIGHT EMERGENCY EXIT HATCH LIGHT LENS COVER DISCOLORED. R & R THE LENS IAW AMM.SDR AALA201704069013Pin · missingEMERGENCY EXIT SIGN CROSSBAR PIN MISSING. ACCOMPLISHED AARD 33-51-01-1.SIGN WORKS AND FUNCTIONS NORMAL. INSTALLED ROLL PIN ON EMERGENCY EXIT SIGN CROSSBAR AT 3L, OPS CK GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170405011Lens · crackedL2 EMERGENCY EXIT LIGHT BASE IS CRACKED LENS FAILS TO SECURE. REPLACED L2 DOOR EMERGENCY EXIT LIGHT ASSEMBLY IAW AMM 33-51-02, OPS CHECK GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170405002Battery · no testON SERVICE CHECK, CIDS TEST FAILED FIN 15WL POWER SUPPLY UNIT. REPLACED THE BATTERY IAW SRM 33-58-00. ACCOMPLISEHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017040602821Battery Pack · inoperativeDURING SERVICE CHECK FOUND EMERGENCY LIGHTS INOPERATIVE AT ROWS 30-37 A & B. R & R THE BATTERY PACK 7236.SDR DALA2017040602820Lamp · inoperativeMULTIPLE EMERGENCY LIGHT LAMPS ARE INOPERATIVE AND MISSING COVERS. REPLACED THE LAMPS AND INSTALLED COVERS.SDR SWAA2017040713021Lens · damagedLEFT OVERWING EMERGENCY LIGHT LENS DISCOLORED. R & R THE LENS IAW AMM.SDR SWAA2017040713020Lens · damagedRIGHT OVERWING EMERGENCY LIGHT LENS DISCOLORED. R & R THE LENS IAW AMM.SDR SWAA2017040713004Cover · wrong partR1 DOOR EXIT SIGN LIGHT COVER MISSING RED ARROW. R & R THE COVER IAW MM.SDR SWAA2017040713003Cover · wrong partL1 DOOR EXIT SIGN LIGHT COVER MISSING RED ARROW. R & R THE COVER IAW MM.SDR AALA201704059006Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT RIGHT SIDE AFT OF TRAILING EDGE FLAP IS INOPERATIVE. SECURED LIGHT ASSEMBLY IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR SWAA2017040612994Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01672. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2017040612992Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01670. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2017040612991Light · inoperativeLT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR DALA2017040502795Light · inoperativeINTERMITTENT SLIDE LIGHTS DOOR 1L & 2L. RELAMPED AND CLEANED 1L AND 2L SLIDE LIGHT ASSY.SDR DALA2017040502788Charger · inoperativeSEAT 21 THRU 31 EMERGENCY ESCAPE PATH LIGHT INOP. REPLACED BATTERY CHARGER AND BATTERY AT STA 1400.SDR AALA201704059023Lens · missingL4 DOOR EMERGENCY LIGHT MISSING THE LENS. INSTALLED THE LENS.SDR AALA201704059022Lens · missingEMERGENCY LIGHT LENS MISSING AT THE L1 DOOR. REPLACED THE LENS.
Back to JASC 3350