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 DALA2016110708424Lens · unknownEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE, LOCATION 903. INSTALLED LENS COVER CKS GOOD.SDR HALA2016110400201Light · looseEMERGENCY PATH LIGHTING COMING LOOSE AT SEATS 22AB. RE-SECURED PATH LIGHTING.SDR IXXA20161007081Battery Pack · dischargedEMERGENCY LIGHTS LEFT SIDE IN PASSENGER COMPARTMENT FAILED TO TEST FROM F/A PANEL. REMOVED AND REPLACED EMERGENCY BATTERY PACKS (M737) AND (M734) DUE TO LOW VOLTAGE READINGS IAW SUPPLEMENTAL AMM 33-51-22. OPERATIONAL CHECK SATISFACTORY. NO FURTHER DEFECTS NSDR AALA20161107026Lens · unsecureAIRCRAFT NOT GROUNDED. CEILING EMERGENCY EXIT SIGN BETWEEN 4A AND 4D HAS A LOOSE LENS COVER. SECURED LENS COVER IAW GPM. OPERATIONAL CHECK GOOD.SDR AALA20161107025Lens · unsecureAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN LENS COVER ABOVE L4 DOOR FELL OFF. SECURED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161107024Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT LENS COVER MISSING FROM L1 DOOR MID GALLEY ENTRY WALL. REPLACED LENS IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20161107021Lens · unsecureAIRCRAFT NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT LENS AT SEAT 20A FELL OFF. RE-INSTALLED LENS IAW GPM. OPERATIONAL CHECK GOOD.SDR AALA20161107019Lens · missingAIRCRAFT NOT GROUNDED. OVERHEAD BIN EMERGENCY EXIT LIGHT OVER SEAT 18A MISSING LENS. REPLACED LENS IAW AMM 33-51-03. OPERATIONAL TEST GOOD.SDR AALA20161107018Lens · missingAIRCRAFT NOT GROUNDED. RIGHT AFT DOOR MISSING EMERGENCY EXIT SIGN LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2016110409385Light · inoperativeRT WING TRAILING EDGE EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW MM.SDR SWAA2016110409384Light · inoperativeFORWARD ENTRY DOOR EXTERNAL EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2016110409378Cover · looseR1 DOOR EXIT LIGHT COVER LOOSE. SECURED COVER PER MM.SDR SWAA2016110409376Battery Pack · dischargedLT EMERGENCY EXIT AISLE LIGHT INOP BETWEEN ROW 14 TO ROW 18. R&R BATTERY PACK PER AMM.SDR SWAA2016110409375Lens · unsecureFORWARD EMERGENCY EXIT LIGHT LENS FELL OFF. SECURED LENS PER SIP.SDR SWAA2016110409369Battery Pack · failedEMERGENCY LIGHTS BATTERY PACK AT LOCATION M1672 FAILED CAPACITY CHECK. R&R BATTERY PACK PER DWG.SDR SWAA2016110409366Battery Pack · unsecureLT OVERWING INTERIOR LIGHT INOP. SECURED BATTERY PACK IAW MM.SDR DALA2016110708324Lamp · inoperativeEMERGENCY LIGHTS AT ROW 27AB ARE INOPERATIVE. MAINTENANCE REPLACED THE LAMPS. SYSTEM OPERATION IS NORMAL.SDR ASAA2016110318573Battery Pack · failedEMERGENCY EXIT LIGHTS OUT OVER R2 DOOR & SEVERAL RT AISLE LIGHTS. ACFT GROUNDED. REPLACED THE BATTERY PACK IAW AMM 33-51-51. OPS NORMAL.SDR REXA2016110302134Sign · inoperativeRT OVERWING EMERGENCY EXIT SIGN INOPERATIVE. REMOVED AND REPLACED THE SIGN IAW AMM 33-51-10.SDR CALA2016110400852Light · inoperativeR-2 DOOR EXTERIOR EMERGENCY LIGHT FAILED OPS CHECK. REMOVED AND REPLACED THE EMERGENCY EXIT SLIDE LIGHT (L733) BULB AT STATION 1000-WL242-RBL 60, IAW AMM 33-51-04 AND WDM 33-51-14. OPS CHECKED GOOD.SDR CALA2016110495971Unknown · malfunctionedEMERGENCY EXIT LIGHTS STAY ON WITH POWER OFF. RESET LIGHTS, NOW OFF.SDR QXEA2016110400703Cover · detachedFORWARD EMERGENCY EXIT LIGHT COVER FELL OFF. REATTACHED LIGHT COVER. NO DEFECTS NOTED. RETURNED TO SERVICE. NO PARTS REPLACED.SDR DALA2016110308269Power Supply · inoperativeFOUND EMERGENCY LIGHT JUST AFT OF DOOR 2L INOPERATIVE. REPLACED THE POWER SUPPLY. LIGHTS OPS CHECKED GOOD IAW AMM 33-51.SDR DALA2016110408243Lens · damagedMAINTENANCE DISCOVERED THAT THE EMERGENCY EXIT SIGN DIFFUSER COVER OVER DOOR L1 WAS DAMAGED. MAINTENANCE REPLACED THE LENS AND THE OPS CHECKED GOOD.SDR AALA20161103009Light · inoperativeCOCKPIT EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECK NORMAL.SDR AALA20161103002Power Supply · inoperativeL2 DOOR FORWARD EMERGENCY EXIT IDENTIFIER LIGHT WILL NOT ILLUMINATED. REMOVED AND REPLACED EMERGENCY POWER SUPPLY AT M33096.SDR MASA2016110312488Light · inoperativeROW 5 EMERGENCY FLOOD LIGHT INOPERATIVE.SDR ASAA2016110221274Lens · missingEMERGENCY LIGHT LENS IS MISSING OVER SEAT 17F. ACFT GROUNDED. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-03-960-805.SDR DALA2016110708351Cover · unsecureEXIT SIGN OVER L1 DOOR FELL OFF. REINSTALLED EXIT COVER.SDR DALA2016110708349Light · brokenFOUND EMERGENCY LIGHT BROKEN AT AFT TAILCONE OVERHEAD CATWALK. REMOVED AND REPLACED POWER SUPPLY AND BATTERY. OPERATION CHECKS GOOD.SDR AALA20161107017Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHTING AT SEAT 25D MISSING LENS. REPLACED LENS IAW AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA20161107013Light · inoperativeAIRCRAFT NOT GROUNDED. R2 DOOR EXTERIOR GROUND ILLUMINATION EMERGENCY SLIDE LIGHT INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-06 AND SWPM 20-30-00. OPERATIONAL CHECK GOOD.SDR SWAA2016110309347Sign · missingL1 DOOR FRAME BULKHEAD LOWER EXIT SIGN MISSING RED ARROW. R&R SIGN PER AMM.SDR DALA2016110308321Lamp · inoperativeR4 DOOR OUTSIDE EMERGENCY LIGHT OUT. REPLACED THE LAMPS. SYSTEM OPERATION IS NORMAL.SDR CALA2016110400849Battery Pack · dischargedEMERGENCY EXIT AISLE LIGHTS INOP ROWS 20 THROUGH 30. PER FIM TASK 33-51-815-802- BATTERY PACK REPLACED (POWER SUPPLY ALSO REPLACED AS PRECAUTION PER AMM 33-51-07. EMER LIGHTING OPERATIONALLY CHKD OK.SDR CALA2016110400850Power Supply · inoperativeEMERGENCY LIGHT EPSU DOOR 1L INOP. REPLACED EPSU AT DOOR 1L REF AMM33-51-38. OPS TEST OK.SDR AALA20161104024Screw · looseAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN ABOVE OVERHEAD BIN AT 24H HAS A LOOSE SCREW. SECURED EXIT SIGN. OPERATIONAL CHECK GOOD.SDR AALA201611039006Cover · missingMISSING LENS COVER ON R4 DOOR EXIT LIGHT. INSTALLED LENS COVER PER AMM 33-51-00.SDR AALA201611039004Battery · inoperativeFORWARD FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201611039003Cover · missingMISSING COVER FOR EMERGENCY EXIT BULB BELOW EXIT SIGN, RIGHT OVERWING. REPLACED EMERGENCY EXIT LIGHT COVER.SDR IPXA2016110210185Light · malfunctionedMAIN CABIN DOOR EXIT LIGHT REMAINS ILLUMINATED IN FLIGHT.EMERGENCY EXIT LIGHT SWITCH IN THE ARM POSITION AS WELL THE ON AND DISARM POSITION. COMPLIED WITH EMERGENCY LIGHT TEST IAW MM 33-51-00-0501. OK FOR SERVICESDR AALA20161103011Battery Pack · inoperativeINTERIOR EMERGENCY EXIT SIGNS AT L1 AND R1 DOOR ARE EXTREMELY DIM. REMOVED AND REPLACED EMERGENCY POWER SU.. SEE ALSO AALA20161103006.SDR AALA20161103010Battery Pack · inoperativeSEAT MOUNTED EMERGENCY LIGHTS AT SEAT 1E THROUGH SEAT 15 DEF ARE EXTREMELY DIM. REMOVED AND REPLACED EMERGENCY POWER SUPPLY AND BATTERY AT M10952 IAW AMM 33-51-07. OPERATIONAL CHECK NORMAL.SDR AALA20161103006Power Supply · inoperativeINTERIOR EMERGENCY EXIT SIGNS AT L1 AND R1 DOOR ARE EXTREMELY DIM. REMOVED AND REPLACED EMERGENCY POWER SUPPLY AND BATTERY AT M10798 IAW AMM 33-51-07. SYSTEM CHECKED NORMAL.SDR AALA20161103005Power Supply · inoperativeSEAT MOUNTED EMERGENCY LIGHTS AT SEAT 1E THROUGH SEAT 15 DEF ARE EXTREMELY DIM. REMOVED AND REPLACED EMERGENCY POWER SUPPLY AND BATTERY AT M10952 IAW AMM 33-51-07. OPS CHECKED NORMAL.SDR AALA20161103004Battery · inoperativeSEAT MOUNTED EMERGENCY LIGHTS FROM SEAT 26 DEF TO SEAT 36 DEF AND EXIT SIGNS AT L4 AND R4 DOORS ARE EXTREMELY DIM. REMOVED AND REPLACED EMERGENCY POWER SUPPLY AND BATTERY AT M10801 IAW AMM 33-51-07. SYSTEM CHECKED NORMAL.SDR AALA20161103003Power Supply · inoperativeSEAT MOUNTED EMERGENCY LIGHTS FROM SEAT 26 DEF TO SEAT 36 DEF AND EXIT SIGNS AT L4 AND R4 DOORS ARE EXTREMELY DIM. REMOVED AND REPLACED THE POWER SUPPLY AND BATTERY AT M10801 IAW AMM 33-51-07. SYSTEM CHECKED NORMAL.SDR AALA20161103001Light · inoperativeAFT EMERGENCY LIGHT AT SEAT 4H IS INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-05. OPS CHECKED NORMAL.SDR DALA2016110308222Power Supply · inoperativeAFT GALLEY F/A JUMP SEAT EMERGENCY WHITE LIGHTS INOP. REPLACED M33409 PWR SUPPLY AND RE-PIN LEFT AFT GALLEY CART LIGHT ASSY.SDR SWAA2016110309356Lens · brokenRT EMERGENCY LIGHT LENS BROKEN AT ROW 25. R&R LENS PER AMM.
Back to JASC 3350