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 SWAA2017052213866Sign · mismarkedR1 DOOR EXIT SIGN MISSING RED ARROW. R & R SIGN IAW AMM.SDR SWAA2017052213865Sign · mismarkedL1 DOOR EXIT SIGN MISSING RED ARROW. R & R SIGN ASSEMBLY IAW AMM.SDR SWAA2017052213854Cover · detachedR1 DOOR EMERGENCY EXIT SIGN LENS COVER FELL OFF. R & R THE COVER IAW MM.SDR SWAA2017052213852Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017052213851Light · inoperativeRIGHT FORWARD EMERGENCY LIGHT STRIP INOPERATIVE BETWEEN BS 335 TO 345. R & R THE LIGHT STRIP IAW AMM.SDR SWAA2017052213848Guard · brokenEMERGENCY LIGHT SWITCH GUARD ARM BROKEN. R & R THE SWITCH GUARD IAW SIP.SDR DALA2017051804064Bracket · brokenEMERGENCY LIGHT BROKEN OFF SEAT 16D, REPAIRED THE BRACKET.SDR AALA201705199026Light · damagedEMERGENCY EXIT LIGHT ASSY AT THE AFT SERVICE DOOR DAMAGED. MAINTENANCE REPLACED THE EXIT LIGHT ASSY IAW AMM 25-63-00, GOOD FOR SERVICE.SDR AALA201705189023Lens · missingEMERGENCY EXIT LIGHT LENS MISSING AT SEAT 10G. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-05-960-802. OPS CHECKED GOOD.SDR AALA201705189021Sign · missingRT AFT GALLEY EMERGENCY EXIT SIGN COVER MISSING. REMOVED AND REPLACED EMERGENCY LIGHTS EXIT SIGN ASSEMBLY IAW MM 33-51-01-960-802. OPS CHECKED GOOD.SDR AALA201705189020Power Supply · no testEMERGENCY POWER SUPPLY AT THE L4 DOOR, M33407. REMOVED FROM ACFT. REPLACED THE EMERGENCY POWER SUPPLY IAW AMM 33-51-06, OPS CHECKED OK.SDR AALA20170518004Light · damagedEMERGENCY LIGHT AT FWD GALLEY LEFT SIDE ISLE LOWER CLOSET FWD FLOOR MARKER LIGHT ASSY DAMAGED. REPLACED THE EMERGENCY FLOOR SPOT LIGHT ASSY AT FWD GALLEY LEFT SIDE FWD FLOOR FWD. IAW AMM 33-50-00, OPS CHECKS NORMAL.SDR REXA2017051700608Lamp · inoperativeEXTERIOR EMERGENCY LIGHT 5 INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-21.SDR DALA2017051804020Battery · dischargedCABIN ROWS 11-15 CEILING EMER LIGHTS INOP. REMOVED & REPLACED BALLAST BATTERIES. OPS CHECK GOOD.SDR ASAA2017051720801Lens · missingEXIT COVER AT 17F IS MISSING. GROUNDED - YES. INSTALLED SERVICEABLE EXIT COVER.SDR ASAA2017051720799Lens · brokenTRIM AT EXIT TO L1 BROKEN. GROUNDED - YES. FOUND TO BE EMERGENCY LIGHT LENS. REMOVED AND INSTALLED NEW LENS. OK FOR SERVICE.SDR AALA201705189007Lens · missingEMERGENCY LIGHT LENS MISSING AT THE R4 DOOR. REPLACED THE LENS.SDR AALA201705189006Lens · missingFLIGHT ATTENDANT REPORTED EMERGENCY LIGHT LENS AT THE R1 DOOR AREA IS MISSING. REPLACED THE LENS .SDR AALA201705189005Lens · missingR1 DOOR FLOOR LEVEL EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS ASSY.SDR SWAA2017051813835Lens · unsecureCENTER AISLE EXIT SIGN LENS COVER FELL OFF. REINSTALLED COVER PER SIP.SDR SWAA2017051813827Sign · looseL2 DOOR EXIT SIGN LOOSE. SECURED SIGN PER SIP.SDR DALA2017051803979Charger · inoperativeEMERGENCY EXIT SIGNS AT THE AFT OVER WING EXITS INOPERATIVE. REPLACED BATTERY CHARGER PB5-230. CHECKS GOOD REF AMM 33-51.SDR DALA2017051803978Power Supply · inoperativeON SERVICE CHECK FOUND FORWARD CABIN CEILING EMERGENCY LIGHTS INOPERATIVE. REPLACED POWER SUPPLY B5-227 AND BATTERY PACK REF AMM 33-51. OPERATIONAL CHECK IS GOOD.SDR IPXA2017051717235Lens · unsecureEXIT SIGN ABOVE L1 DOOR WILL NOT STAY SECURED. REPLACED THE COVER IAW 33-27-01-05, ITEM 130.SDR MASA2017051712308Battery Pack · inoperativeSEVERAL EMERGENCY FLOOD LIGHTS INOPERATIVE. REPLACED THE NR 2 BATTERY PACK.SDR DALA2017051703970Battery Pack · inoperativeUPPER DECK EMERGENCY EXIT DOORS EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK M312 IAW AMM 33-51-04.SDR YENA201705170371Battery · failedEMERGENCY LIGHT FAILED TO TEST. R & R THE BATTERY AT FIN 10WL IAW 33-51-38. OPS CHECKED GOOD.SDR 2DYA20170605001Lamp · burned outMULTIPLE EMERGENCY LIGHTS INOPERATIVE. REPLACED THE LAMP.SDR AALA201705229004Lens · brokenEMERGENCY EXIT LIGHT FORWARD OF LAVATORY 4F-CR, HAS A BROKEN LENS. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW ESO 21273. OPS CHECKED GOOD IAW AMM 33-51-05-201.SDR SWAA2017052213853Lamp · dimR2 DOOR EMERGENCY EXIT SIGN VERY DIM. REPLACED THE LAMPS IAW AMM.SDR A6WA201745019Inverter · inoperativeEMERGENCY FLOOR LIGHTING ROW 9 AND AFT NOT ILLUMINATING. R&R NR 4 EMERGENCY LIGHT INVERTER IAW AMM 33-51. OPS CHECK GOOD AT THIS TIME.SDR AALA201705189011Light · inoperativeSEAT 5J MOUNTED EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-10. OPERATIONAL CHECKED GOOD.SDR AALA20170517010Power Supply · inoperativeFIRST CLASS EMERGENCY LIGHT TEST FAIL. REMOVED AND REPLACED EMERGENCY LIGHTS POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR AALA201705179021Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN OVER R2 DOOR HAS A DETACHED LENS COVER. RESECURED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA201705179019Light · not seatedAIRCRAFT WAS NOT GROUNDED. R1 DOOR EMERGENCY EVACUATION SLIDE LIGHT IS INOPERATIVE. RESEATED LIGHT IN SOCKET. OPERATIONAL CHECK GOOD.SDR HALA2017051700173Light · unknown26B PATH LIGHT STRIP BROKEN. INSTALLED MISSING STRIP AT 26B.SDR AALA20170516009Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY BROKEN PATH LIGHTING LENS COVER AT LAVATORY D. REPLACED LIGHT ASSEMBLY PER AMM 33-51-18. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170516008Sign · brokenAIRCRAFT WAS NOT GROUNDED. BROKEN LOWER FASTENER ON EMERGENCY EXIT SIGN AT R4 DOOR. REPLACED EXIT MARKER EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR 7C7A2017051600327Battery Pack · dischargedRT FRONT EMERGENCY DOOR SIGN LIGHT VERY DIM. R&R EMERGENCY LIGHT BATTERY PACK AT 3351PS2 IAW AMM 33-52-00. OPS CHECKED GOOD. OK FOR CONTINUED SERVICE.SDR QXEA2017051700362Light · inoperativeBOTH EGRESS LIGHTS IN THE RIGHT SIDE, ONE AT EMERGENCY EXIT AND ONE AT AFT SERVICE DOOR ARE INOP. RELAMPED THE FORWARD LIGHT IAW AMM 33-51-11-00-801/400-801, AND THE AFT LIGHT REFLECTOR REPLACED. OPERATIONAL CHECKS GOOD.SDR AALA201705179003Light · damagedAIRCRAFT WAS NOT GROUNDED. DAMAGED EMERGENCY PATH LIGHTING LENS COVER AT LAVATORY L. REPLACED LIGHT ASSEMBLY PER AMM 33-51-18.SDR ASAA2017051620790Lens · brokenFLOOR LIGHT BY L1 DOOR BROKEN. ACFT GROUNDED. REMOVED AND REPLACED THE LIGHT COVER.SDR UIEA2017030200257Battery Pack · no testL3 DOOR EMERGENCY LIGHT FAILED A 15 MINUTE TEST. REPLACED THE BATTERY PACK AND PERFORMED A POWER SUPPLY TEST IAW AMM 33-51-04, NO DEFECTS NOTED.SDR UIEA2017030200258Battery Pack · no testR1 DOOR EMERGENCY LIGHT FAILED A 15 MINUTE TEST. REPLACED THE BATTERY PACK AND PERFORMED A POWER SUPPLY TEST IAW AMM 33-51-04, NO DEFECT NOTED.SDR UIEA2017030200259Battery Pack · no testEMERGENCY EXIT SIGN AFT OF R3 DOOR FAILED A 15 MINUTE TEST. REPLACED THE BATTERY PACK AND PERFORMED A POWER SUPPLY TEST IAW AMM 31-51-04. NO DEFECTS NOTED.SDR UIEA2017042600654Battery Pack · inoperativeL1 DOOR AREA EMERGENCY LIGHTS INOPERATIVE. REPLACED THE POWER SUPPLY BATTERY AND PERFORMED POWER SUPPLY TEST IAW AMM 33-51-04 ITEM E AND NO DEFECT NOTED.SDR IPXA2017051717205Power Supply · inoperativeEMERGENCY LIGHT BATTERY 1 LOW. REMOVED AND REPLACED THE BATTERY POWER SUPPLY IAW AMM 33-51-01-400-802. OPS CHECKED GOOD IAW 33-51-10-01, ITEM 8.SDR AALA201705179013Light · looseEMERGENCY LIGHT AT 4C LOOSE, SECURED THE LIGHT, OK FOR SERVICE . .SDR AALA201705179012Lens · missingEMERGENCY LIGHT LENS MISSING ABOVE L2 DOOR. REPLACED THE LENS.SDR AALA20170516001Battery Pack · no testEMERGENCY LIGHTS AT SEATS 20D AND 26D THROUGH 36D ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK AND CONTROL MODULE AT M10801 IAW AMM 33-51-11. OPS CHECKED GOOD.
Back to JASC 3350