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 REXA2017072400805Light · inoperativeF/A REPORTED EMERGENCY LIGHT NOT CHARGING. REMOVED AND REPLACED THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR MASA2017072412489Light · intermittentEVERY OTHER OVHD EMER LIGHT INOP. RESET SYSTEM, OPS NORMAL.SDR MASA2017072412488Switch · inoperativeALL EMERGENCY LIGHTS INOP. REPLACED FWD FA EMER LIGHT SWITCH.SDR CALA2017072402369Lens · looseEMERGENCY LIGHT LENS DETACHED AT THE L1 DOOR. PROPERLY INSTALLED EMERGENCY LIGHT LENS IAW AMM 33-51-14. NO FURTHER DEFECT NOTED.SDR CALA2017072402368Cover · missingL2 DOOR LIGHT MISSING THE WHITE PLASTIC COVER. REPLACED THE EXIT SIGN IAW AMM 33-51-01. OK FOR SERVICE.SDR CALA2017072402362Lens · missingROW 2 EMERGENCY LIGHT LENS IS MISSING. INSTALLED ROW 2 EMERGENCY PROXIMITY LIGHT LENS IAW IFM 25-27-42.SDR CALA2017072402357Lens · looseEMERGENCY LIGHT COVER IN AFT GALLEY MISSING. SECURED LENS.SDR CALA2017072402356Switch · malfunctionedEMERGENCY LIGHTS AT BOTTOM OF SEATS FROM ROW 48 AFT STAY ON. RESET EMERGENCY LIGHTS SWITCH AT DOOR 4 RT.SDR CALA2017072402367Lens · missingEMERGENCY LIGHT COVER MISSING AT THE R2 DOOR. REPLACED LENSSDR CALA2017072402366Lens · missingRED EMERGENCY LIGHT LENS AT SEAT 20C MISSING. REPLACED THE LIGHT ASSY IAW 33-51-11.SDR CALA2017072402363Sign · looseCEILING EMERGENCY EXIT SIGN IS LOOSE.SDR CALA2017072402351Light · missingSEAT ROW 31 ABC EMERGENCY LIGHT ASSY MISSING. INSTALLED EMERGENCY LIGHT ASSY AT ROW 31. OPERATION IS NORMAL.SDR SWAA2017080115316Battery · dischargedL2 OVERHEAD DOOR EMERGENCY EXIT SIGN INOP. R&R BATTERY PER AMM.SDR SWAA2017080115315Light · inoperativeR2 DOOR EMERGENCY EXIT LIGHT INOP. R&R LIGHT ASSEMBLY PER MM.SDR SWAA2017072615282Cover · looseR2 DOOR EMERGENCY EXIT LIGHT COVER LOOSE. / R&R LIGHT PER AMM.SDR AALA201707269050Lens · brokenSEAT EXIT LIGHT COVER BROKEN AT ROW 3 LEFT. REPLACED SEAT LIGHT IAW 33-51-19. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707269029Lens · missingFLOOR LEVEL EMERGENCY LIGHT LENS MISSING AT THE R4 DOOR. MAINTENANCE REPLACED THE LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707269027Lens · missingEMERGENCY LIGHT LENS MISSING AT ROW 8 LEFT. REPLACED EMERGENCY LIGHT ASSEMBLEY IAW AMM 33-51-18. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707269026Cover · missingEXIT LIGHT COVER MISSING AT 10 LEFT. REPLACED EXIT LIGHT COVER IAW AMM 33-51-19. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707269025Light · damagedSEAT MOUNTED EMERGENCY LIGHT DAMAGED AT SEAT ROW 14 LEFT. REPLACED THE EMERGENCY LIGHT IAW CMM 25-22-50. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707269024Cover · brokenSEAT EXIT LIGHT COVER BROKEN AT 16 LEFT. REPLACED THE LIGHT IAW 33-51-19. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707269008Lens · detachedL2 DOOR EMERGENCY LIGHT LENS FELL OFF THE PACK. REPLACED THE LENS. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707269007Lens · missingEXIT LIGHT LENS BY THE R2 DOOR MISSING. MAINTENANCE REPLACED LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170725004Battery Pack · dischargedEMER EXIT LIGHTS AT 5EF, 7DEF, AND 9ABC INOPERATIVE. REMOVED & REPLACED THE EMERGENCY LIGHT ASSYS. REMOVED AND REPLACED THE BATTERY PACKS. PERFORMED AN OPS CHECK OF THE SYSTEM, CHECKED GOOD IAW MM 33-51-00. THE AIRCRAFT WAS GROUNDED.SDR UIEA2017072401285Lamp · inoperativeL4 CABIN ENTRY EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-51-06.SDR AALA201707259018Battery Pack · dischargedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS ON END OF SEATS INOP FROM ROW 3 TO ROW 19. REPLACED BATTERY PACK, CHECKS NORMAL PER AMM 33-50-00. (SEE ALSO SDR AALA201707249056)SDR AALA201707259005Light · inoperativeTHE AIRCRAFT WAS GROUNDED. EMERGENCY LIGHTS ON BULL NOSE BAG BINS INOP AT SEATS 5EF, 7DEF, AND 9ABC. R&R POWER SUPPLY ASSY AT M1674 (NO HELP). R&R LIGHT ASSYS AT 5EF, 7DEF, & 9AB. PERFORMED OPS CK EMER LIGHT SYS IAW MM 33-51-03, OPS NML. AC OK FOR CONT SVSDR AALA201707249056Power Supply · inoperativeTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS ON END OF SEATS INOP FROM ROW 3 TO ROW 19. REPLACED POWER SUPPLY, CHECKS NORMAL PER AMM 33-50-00. (SEE ALSO SDR AALA201707259018)SDR AALA201707249054Light · abnormalTHE AIRCRAFT WAS NOT GROUNDED. AFT ENTRY DOOR EXIT LIGHT IS MISSING. REPLACED AFT ENTRY DOOR EXIT LIGHT IAW AMM 33-51-00, OPS CHECKS NORMAL, OK FOR SERVICE.SDR AALA201707249053Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. AFT EXIT SIGN COVER MISSING. REMOVED AND REPLACED R2 LIGHT ASSY EXIT IDENTIFIER PER AMM 33-51-00. TEST OK.SDR SWAA2017072515271Lens · brokenRT FORWARD GALLEY EXIT SIGN LENS COVER BROKEN. R&R LENS PER AMM.SDR SWAA2017072515265Light · unsecureR1 DOOR LOWER EXIT SIGN LIGHT ASSEMBLY FELL OFF. R&R LIGHT ASSEMBLY IAW AMM.SDR DALA2017072405676Battery Pack · dischargedEMERGENCY LIGHT AT SEATS 41 TO 45 INOP. REPLACED BATTERY PACK AND CHARGER IAW AMM 33-51 OPS CHECK GOOD.SDR SWAA2017072515246Battery Pack · inoperativeRIGHT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017072515244Sign · missingRIGHT OVERWING EMERGENCY EXIT LIGHT SIGN MISSING. R & R SIGN IAW AMM.SDR HNAA2017072500248Control Box · inoperativeEMERGENCY LIGHTS ILLUMINATE WHILE IN ARMED POSITION. R & R THE EMERGENCY LIGHT CONTROL BOX, OPS CHECKED GOOD, OK FOR SERVICESDR MASA2017072312487Battery Pack · dischargedROW 13 EMERGENCY EXIT SIGNS INOP. REPLACED BATT PACK 4.SDR MASA2017072312486Light · inoperativeROW 17 EMERG CEILING LIGHT INOP. RELAMPED.SDR MASA2017072312485Light · inoperativeROW 11 CEILING EMERG FLOOD LIGHT INOP. PLACED ON MEL.SDR MASA2017072312483Battery · dischargedCABIN EMERGENCY LIGHTS INOPERATIVE. CHARGED BATTERIES.SDR AALA201707269001Cover · brokenAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EXIT LIGHT COVER AT 11 LEFT, BROKEN. REPLACED SEAT MOUNTED EXIT LIGHT AT 11L PER AMM 33-51-19.SDR AALA201707249051Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. DOOR EMERGENCY EXIT SIGN COVER IS MISSING. THE SIGN COVER WAS PLACED ON NEF. REMOVED AND REPLACED EMERGENCY EXIT SIGN AT THE L4 DOOR PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201707249040Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT AT SEAT 33B HAS A MISSING LENS COVER. REPLACED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR SWAA2017072515255Sign · unsecureRT OVERWING EXIT SIGN LIGHT ASSEMBLY FELL OFF. R&R LIGHT ASSEMBLY PER AMM.SDR DALA2017072305685Lens · missingEMER EXIT LIGHT COVER MISSING ROW 22 EXIT SIGN. REPLACED OVERHEAD SIGN COVER LENS AS REQUIRED, OK FOR SVC.SDR FDEA201707222018Battery Pack · inoperativeDURING SERVICE CHECK, FOUND THE L1 DOOR SLIDE LIGHT AND FLIGHT COMPARTMENT EMERGENCY LIGHT INOPERATIVE DURING TEST. REMOVED AND REPLACED THE BATTERY PACK AT M730 IAW AMM 33-51-07-2. EMERGENCY LIGHTS NOW OPS CHECK GOOD.SDR DALA2017072305671Sign · detachedMID CENTER EXIT SIGN. BACKSIDE COVER HAS FALLEN OFF. INSTALLED THE COVER.SDR A6WA201745125Light · inoperativeFLOOR EMERGENCY LIGHTS AFT OF ROW 8 WILL NOT ILLUMINATE. R & R THE EMERGENCY LIGHT IAW AMM 16-371A. OPS CHECKED GOOD.SDR AALA20170722003Battery · dischargedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS ON WITH POWER TO PLANE OFF. REMOVED AND REPLACED EMERGENCY LIGHT B AT PACK FOR COCKPIT AND F/C. EMERGENCY LIGHTS TEST NORMAL IAW AMM 33-53-00.SDR SWAA2017072415176Slide · out of positionR2 DOOR SLIDE OUT OF POSITION. POSITIONED THE SLIDE IAW MT.
Back to JASC 3350