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 SWAA2018090424808Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2018090424748Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2018090424715Battery Pack · dischargedEMERGENCY LIGHTS BATTERY PACK INOP AT M1674. R&R BATTERY PACK IAW AMM.SDR SWAA2018090424714Battery Pack · dischargedEMERGENCY LIGHTS BATTERY PACK INOP AT M1673. R&R BATTERY PACK IAW AMM.SDR SWAA2018090424713Battery Pack · dischargedEMERGENCY LIGHTS BATTERY PACK INOP AT M1672. R&R BATTERY PACK IAW AMM.SDR SWAA2018090424710Battery Pack · dischargedEMERGENCY LIGHTS BATTERY PACK INOP AT M1675. R&R BATTERY PACK IAW AMM.SDR DALA2018083005391Sign · missingEXIT SIGN MISSING ONE SIDE MID-PLANE. FOUND & RE-SECURED FWD FACING EMERGENCY EXIT SIGN AS REQUIRED.SDR AALA201808319031Battery Pack · no testLEFT OVERWING EXIT LIGHTS AND RIGHT OVERWING EXIT LIGHTS AT BASE OF ROW 14, REMAINED ON IN THE AUTO POSITION. MAINTENANCE REPLACED EMERGENCY LIGHT BATTERY PACK IAW AMM 33-51-06 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SIMA2018083029002Lamp · inoperativeEMERGENCY LIGHT OUT AFT CABIN 2ND LIGHT FROM END OF AFT CABIN-C/A-DEFERRED EMERGENCY LIGHT IAW MEL 33-34. REMOVED AND REPLACED CEILING EMERGENCY-FLOOD-LIGHT LAMP IAW CRJ-700 AMM 33-51-09 OPS CHECK GOOD MEL ITEM RESTOREDSDR AALA201808319010Lamp · inoperativeL4 DOOR EXTERIOR EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-06. OPS OK.SDR AALA201808319007Lens · missingROW 1L EMERGENCY LIGHT MISSING THE WHITE LENS. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-19. OPS NORMAL.SDR AALA201808319006Lens · missingROW 8R EMERGENCY LIGHT MISSING THE RED LENS. REPLACED THE LIGHT AMM 33-51-18. OPS NORMAL.SDR QXEA2018083000317Light · looseEMERGENCY LIGHTING STRIP @ ROW 1 COMING LOOSE FROM FLOOR. REMOVED FROM SERVICE. RESECURED EMERGENCY LIGHTING STRIP NEXT TO SEAT 1B. NO FURTHER DEFECTS. RETURNED TO SERVICE.SDR AALA201808309040Cover · detachedEMERGENCY LIGHT COVER FELL OFF AT FOWARD FLIGHT ATTENDANT JUMPSEAT. MAINTENANCE REPLACED THE LIGHT COVER AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR SIMA2018083029001Light · inoperativeMAIN CABIN DOOR EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED MAIN CABIN DOOR EXTERNAL EMERGENCY LIGHT COVER IAW EMB 140 AMM 25-23-04. LIGHT OPERATIONAL CHECK GOOD.SDR AALA201808309013Light · burned outL3 DOOR LIGHT WAS OUT. REPLACED THE EMERGENCY LIGHT. OPS CHECKED OK IAW AMM 33-51-04.SDR AALA201808309010Cover · detachedL1 DOOR EMERGENCY EXIT LIGHT COVER CAME OFF, WON'T ATTACH. REINSTALLED L1 DOOR EMERGENCY LIGHT COVER IAW AMM 33-51-00, OK FOR SERVICE.SDR AALA201808309009Lens · brokenSEAT 22C EMERGENCY LIGHT LENS WAS BROKEN. REPLACED THE LIGHT IAW AMM 33-51-11. OPS CHECKED GOOD.SDR AALA201808309008Lens · missingROW 11R EMERGENCY EXIT LIGHT LENS WAS MISSING. INSTALLED THE LENS. OK FOR SERVICE.SDR DALA2018083005360Lens · missingEMERGENCY LIGHT LENS WAS MISSING ALONG THE R1 AND GALLEY. INSTALLED THE LENS.SDR SWAA2018083024701Battery · dischargedLT OVERWING EMERGENCY EXIT LIGHTS INOP. R&R BATTERY PER AMM.SDR SWAA2018083024696Battery · dischargedLT OVERWING EXTERNAL EMERGENCY EXIT LIGHTS INOP. R&R BATTERY PER AMM.SDR SWAA2018083024693Lens · missingL1 DOOR EMERGENCY EXIT LOWER LIGHT LENS COVER MISSING DIRECTIONAL ARROW. R&R COVER PER AMM.SDR SWAA2018083024692Cover · missingR1 DOOR EMERGENCY EXIT LOWER LIGHT LENS COVER MISSING DIRECTIONAL ARROW. R&R COVER PER AMM.SDR SWAA2018083024691Battery Pack · dischargedINTERIOR EMERGENCY EXIT ABOVE R1 DOOR INOP. R&R BATTERY PACK PER MM.SDR SWAA2018083024690Battery Pack · dischargedEMERGENCY EXIT LIGHT ABOVE FLIGHT DECK DOOR INOP. R&R BATTERY PACK PER MM.SDR SWAA2018083024689Battery Pack · dischargedFORWARD ENTRY EXTERIOR EMERGENCY LIGHT INOP. R&R BATTERY PACK PER MM.SDR SWAA2018083024688Battery Pack · dischargedLT EMERGENCY EXIT AISLE LIGHT INOP AT SEAT ROW 1. R&R BATTERY PACK PER MM.SDR SWAA2018083024687Battery Pack · dischargedLT EMERGENCY EXIT AISLE LIGHT INOP AT ROW 4. R&R BATTERY PACK PER MM.SDR SWAA2018083024686Battery Pack · dischargedINTERIOR EMERGENCY EXIT LIGHT BETWEEN L1 DOOR AND FLIGHT ATTENDANT SEAT INOP. R&R BATTERY PACK PER MM.SDR DALA2018083005359Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHT WAS OUT ROWS 1 - 4 & 16 - 20. REPLACED BATTERY PACKS B5-100 AND B5-102 IAW AMM 44-53. OPS CHECKED GOOD. AC OK FOR SERVICE.SDR MASA201808303534Light · inoperativeROW 18 OVERHEAD EMER FLOODLIGHT INOPERATIVE.SDR DALA2018082905352Lens · missingR2 & L2 DOOR EXIT LIGHT LENSES WERE MISSING. REPLACED THE LENSES IAW AMM 33-50.SDR MASA2018082913533Light · inoperativeCEILING OVERHEAD EMERGENCY FLOOD LIGHT AT ROW 19 WAS INOPERATIVE.SDR AALA2018090609003Battery Pack · inoperativeR4 DOOR EMERGENCY LIGHT NOT WORKING. REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD, OK FOR SERVICE.SDR AALA201808309031Lens · missingEMERGENCY LIGHT AT SEAT 9D WAS MISSING A LENS. MAINTENANCE REPLACED THE LIGHT IAW AMM 33-50-00, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018083109018Light · inoperativeOVERWING EXIT LIGHT ROW 14DEF WAS INOPERATIVE. REPLACED THE LIGHT ASSY IAW AMM 33-21-00.SDR AALA2018083109037Sign · detachedEMERGENCY EXIT SIGN, SEAT 14F, BETWEEN EMERGENCY EXIT FOR 3EF DETACHED. MAINTENANCE REPLACED THE SIGN IAW AMM 33-51-01, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018083109022Battery Pack · dischargedDURING OPERATIONAL CHECK OF THE EMERGENCY LIGHTS, FOUND THE BATTERY PACKS TO BE DISCHARGE. MAINTENANCE CHARGED BATTERY PACKS AND REPLACED LIGHT AT ROW 14ABC AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201808319005Battery Pack · dischargedLEFT CEILING EMERGENCY LIGHT AT ROW 25 WAS INOPERATIVE. THE AIRCRAFT WAS GROUNDED. REPLACED THE BATTERY PACK B5-106 IAW MM 33-53-00. OPS CHECKED OK.SDR AALA201808319004Battery Pack · dischargedLEFT CEILING EMERGENCY LIGHT AT ROW 27 WAS INOPERATIVE. THE AIRCRAFT WAS GROUNDED. REPLACED THE BATTERY PACK B5-106 IAW AMM 33-53-00. OPS CHECKED OK.SDR AALA201808319003Battery Pack · dischargedLEFT CEILING EMERGENCY LIGHT AT ROW 23 WAS INOPERATIVE. THE AIRCRAFT WAS GROUNDED. REPLACED THE BATTERY PACK B5-106 IAW MM 33-53-00. OPS CHECKED OK.SDR AALA201808319002Power Supply · inoperativeEMERGENCY LIGHTS ROWS 13, 14, AND 15 WERE INOPERATIVE. REPLACED THE POWER SUPPLY 12WL IAW AMM 33-51-38. OPS CHECKED OK.SDR CALA2018083101867Power Supply · inoperativeREF LOGPAGE 7693165, FOUND ZONE 3 LT & RT PAX SEAT EMERGENCY LT NOT ILLUMINATE. C/OUT T/SHOOTING REF WDM 33-51-58 FOUND EMER LT PWR SUPPLY (M334 01) FAULTY. RELAY R3 EMER LT PWR SUPPLY (M33401) CHARGER AND BAT T.THEN EMER LT TESTED SATIS. REF AMM 33-51-06.SDR CALA2018083101862Power Supply · inoperativeREF LOGPAGE 7693184, FOUND R2 DR FWD & AFT EXIT IDENTIFY SIGN, UPPER EXIT SIGN NOT ILLUMINATED. T/SHOOTING FOUND EMER PWR SUPPLY CHARGER (M33097) FAULTY. REPLACED R2 DR EMER PWR SUPPLY CHARGER (M33097) THEN EMER LT TESTED R2 DR EXIT SIGN OK REF AMM 33-51-06.SDR AALA2018083109017Cover · missingAFT EMERGENCY LIGHT EXIT COVERS MISSING. REPLACED THE COVER IAW AMM 35-51-10.SDR AALA201808309021Battery Pack · no testPERFORMED CIDS1 EPSU SYSTEM TEST IAW A PS CHECK BATTERY 15WL FAILED. REPLACED 15WL EMERGENCY BATTERY IAW AMM 33-51-38.SDR AALA2018083099025Lens · missingSEAT 4E FORWARD EMERGENCY LIGHT LENS WAS MISSING. REPLACED THE LENS IAW MM 33-53-00. OPS CHECKED OK.SDR AALA2018083099023Light · crackedLENS ON THE EMERGENCY EXIT LIGHT LOCATED IN ISLE OF FIRST CLASS GALLEY FLOOR AREA WAS CRACKED. REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-51-14.SDR AALA2018083099022Light · damagedEMERGENCY EXIT LIGHT ON FORWARD ASILE WALL RIGHT SIDE DAMAGED. REPLACED BASE ON EMERGENCY EXIT LIGHT IAW MM 33-51-01.
Back to JASC 3350