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 QXEA2018112600431Lamp · inoperativeFOWARD F.A. EMERGENCY LIGHT BUTTON LIGHT BULB INOP. REMOVED FROM SERVICE. RELAMPED - OPS CHECK GOOD. RETURNED TO SERVICE.SDR IPXA2018112626216Battery Pack · inoperativeEMERGENCY LIGHT BATTERY 1 LOW FOUND DURING A PREFLIGHT. THE BATTERY PACK WAS R & R IAW AMM 33-51-01 PB 401, AMM REV 91.02.SDR IPXA2018112626220Bulb · inoperativeEMERGENCY LIGHT HAD THREE INOPERATIVE BULBS. REPLACED THE BULBS IN THE EMERGENCY LIGHT IAW AMM 33-51-01-2.SDR DALA2018112406748Socket · damagedDURING INSPECTION FOUND EMERGENCY LIGHT AT BIN 15 D, E, F INOPERATIVE. MAINTENANCE FOUND LIGHT SOCKET DAMAGED. R&R SOCKET PER AMM 33-51. OPS CHECKS GOOD.SDR YENA2018112320784Battery Pack · failedFT # 225, JFK-TPA. EPSU 13WL BATTERY FAILS EMERGENCY LIGHT SYSTEM TEST; R & R BATTERY IAW AMM 33-51-38, SYSTEM OPS CHECKS GOOD.SDR YENA2018112320783Light · detachedFT # 2254, PBI-JFK. EMERGENCY FLOOR LIGHT ON SEAT 13C IS HANGING FREE FROM BRACKET; REINSERTED LIGHT ASSY INTO BRACKET AS REQ.SDR SWAA2018112727157Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATIONS M01675. R&R BATTERY PER MM.SDR SWAA2018112727156Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATIONS M01674. R&R BATTERY PER MM.SDR SWAA2018112727155Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATIONS M01670. R&R BATTERY PER MM.SDR SWAA2018112727154Charger · inoperativeLT EMERGENCY AISLE LIGHTS INOP BETWEEN ROW 1 TO ROW 4. R&R BATTERY CHARGER PER MM.SDR SWAA2018112727148Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATIONS M01673. R&R BATTERY PER MM.SDR SWAA2018112727116Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. R&R LAMP IAW AMM.SDR ASAA2018112127088Light · inoperativeOUTSIDE R2 EMERGENCY LIGHT INOP. GROUNDED - YES. RELAMPED OUTSIDE R2 EMERGENCY LIGHT REF AMM 33-51-04-960-801.SDR DALA20181126816Lens · looseSHIP 5640 EMERGENCY EXIT SIGN COVER LOOSE / LOCATIONS:602. EMERGENCY EXIT SIGN BROKEN 1R. CORRECTIVE ACTION: SECURED EXIT SIGN. (083526)SDR SIMA201811261003Light · inoperativeFOUND EMERGENCY FLOOR PROXIMITY STRIP AT 14A INOP-C/A-RAR FLOOR PROIMITY STRIP LIGHT AT 14A IAW EMB 140 AMM 33-50-12. OPC GOOD.SDR AALA201811261002Power Supply · inoperativeTHE EMERGENCY LIGHTS INOPERATIVE IN THE COACH CLASS, LEFT OVERHEAD ROW AND THE L5 DOOR. REPLACED THE POWER SUPPLY IAW AMM 24-31-51. OPS CHECKED OK. OK FOR SERVICE.SDR DALA2018112646778Lens · missingEMERGENCY PATH LENS AT SEAT 45A MISSING AND REPLACED.SDR AALA201811239020Battery · faultedTHE AIRCRAFT WAS NOT GROUNDED. PERFORMED EPSU SYSTEM TEST PER SIC PS FOUND BATTERY/EPSU FORWARD LEFT CLASS 1 FAULT. REPLACED EPSU BATTERY PER 33-51-38. OPERATIONS CHECK NORMAL.SDR FDEA201811213348Power Supply · inoperativeTEST FAILS ON SUPRNMRY LIGHT TEST FOUR LIGHTS INOP. REMOVED AND REPLACED R1 OVRHD EMER LIGHTS POWER SUPPLY, REF AMM 33-51-06-2. EMER LIGHTS TEST SATIS, ITEM OK FOR SVC.SDR FDEA201811223343Light · inoperativeCOCKPIT CEILING EMERGENCY LIGHT WILL NOT TEST. RELAMPED AND OPS CHECK NORMAL REF MM 33-51-09-3. A/C OK FOR SERVICE.SDR AALA20181123001Power Supply · no testCIDS TEST FAILED ON EPSU 11WL. REPLACED BATTERY ON EPSU IAW AMM 25-23-41.SDR DALA2018112106743Battery Pack · inoperativeTHE L1-DOOR EXIT SIGN ABOVE FLIGHT ATTENDENT SEAT IS INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK B5-235 PER B717 AMM 33-53. OPERATIONAL CHECK WAS GOOD. (LP #4592427)SDR JJBA2018113020019Light · damagedPOLY CORBONITE ON 10EA EMERGENCY LIGHT STRIPS CRACKED/DAMAGED. REMOVED AND REPLACED COVERS AND CLEANED STRIPS 10EA POLY CORBONITE EMERGENCY LIGHT STRIP.SDR DALA2018112966885Power Supply · inoperative(AIRCRAFT 7104, L/P 5212794) ON SVC CK FOUND 1ST CLASS EMERG EXIT AISLE LIGHTS INOP. T/S PER B777 WDM FOUND CONTINUITY FROM PIN 14 ON CONNECTOR M33094 TO PIN 33 ON CONNECTOR D3111P.(442268) REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK POWER SUPPLY M33094 SDR DALA2018112966879Power Supply · inoperative(AIRCRAFT 7104, L/P 5212796) FIRST CLASS RT AISLE OVHD EMERGENCY LIGHTS INOP. REPLACED EMERGENCY LIGHTS POWER PACK M33093 PER B777 AMM 33-51. OPS CK NORMAL.SDR SWAA2018112827192Light · brokenGALLEY 1 EMERGENCY EXIT LIGHT WIRE BROKEN AT BS 293, RBL 51. R&R LIGHT PER AMM.SDR SWAA2018112727066Battery · dischargedEMERGENCY LIGHT ON CEILING PANEL BETWEEN FORWARD LAV AND G1 INOP. R&R BATTERY IAW AMM.SDR SWAA2018112727011Lens · missingR2 DOOR WHITE "EXIT SALIDA" SIGN COVER MISSING. INSTALLED LENS PER AMM.SDR DALA2018112756797Light · detached(LP# 3837194) EMERGENCY TRACK FLOOR LIGHT DANGLING. LIGHT AT 14D PLACED ON MEL. 25NOV, REMOVED AND REPLACED TRACK LIGHT. OPERATIONS CHECK OKAY. MEL CLEARED.SDR SIMA2018112600003Light · wornFWD PHOTOLUMINESCENT STRIP WORN-C/A-REMOVED AND REPLACED FWD PHOTOLUMINESCENT STRIP IAW AMM 33-50-21. OPC GOODSDR AALA201811219013Sign · missingFLIGHT ATTENDANT ADVISED EXIT SIGN MISSING ON ROW 15 ABC. CHANGED L1189 LEFT HAND AFT EMERGENCY LIGHT EXIT ASSEMBLY IAW AMM 33-51-00. OPS CHECKED GOOD.SDR AALA201811219012Light · wornMAIN CABIN RT EMERGENCY LIGHT STRIP WAS IN POOR CONDITION. REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-21.SDR AALA201811219011Light · wornMAIN CABIN LT EMERGENCY LIGHT STRIP WAS IN POOR CONDITION. REPLACED THE EMERGENCY LIGHT STRIP IAW AMM 33-50-21.SDR CALA2018112102407Light · damaged20ABC EXIT ROW LIGHT PUSHED IN AND DOES NOT ILLUMINATE. REMOVED AND REPLACED SEAT MOUNTED EMERGENCY EXIT LIGHT AT 20 ABC.SDR SWAA2018112127008Lens · missingL1 DOOR LOWER EMERGENCY EXIT LIGHT LENS MISSING DIRECTIONAL ARROW. R&R LENS PER AMM.SDR SWAA2018112127007Cover · unsecureREAR GALLEY EMERGENCY EXIT LIGHT COVER FELL OFF. R&R LIGHT ASSEMBLY PER MMM.SDR SWAA2018112126998Lens · missingR1 DOOR LOWER EMERGENCY EXIT LIGHT LENS MISSING DIRECTIONAL ARROW. R&R LENS PER AMM.SDR SWAA2018112126970Sign · inoperativeRT LOWER FORWARD EMERGENCY OVERWING DOOR SIGN INOP. RELAMPED SIGN PER AMM.SDR DALA2018112006698Battery · inoperativeEMERGENCY LIGHT NOT COMING ON IN THE COCKPIT. REMOVED AND REPLACED BATTERY FOR THE FORWARD CEILING PANEL AND THE COCKPIT CEILING EMERGENCY LIGHT REF MD88 AMM 33-55. OPS CHECK GOOD. P/N AD-4002P. (LP5298878)SDR IPXA2018112106145Battery Pack · inoperativeEMERGENCY LIGHT BATTERY 1 LOW. R & R EMERGENCY POWER SUPPLY BATTERY IAW AMM 33-51-01-401.SDR SWAA2018112727114Battery Pack · dischargedEMERGENCY LIGHTS POWERED BY EMERGENCY BATTERY PACK M2335 INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2018112727113Fuse · blownR2 DOOR EMERGENCY SLIDE LIGHT INOP. R&R BATTERY FUSE IAW AMM.SDR DALA20181126820Lens · missingSHIP 666 EXIT LITE ASSY ABOVE R2 DOOR MISSING CLEAR PLASTIC LENS. CORRECTIVE ACTION: REPLACED LENS ASSY OPS NRML PER B757 AMM 33-51. (5117210)SDR AALA201811210004Power Supply · inoperativeCEILING EMERGENCY LIGHTS FROM SEATS 7A TO 13A WERE INOPERATIVE. REPLACED THE POWER SUPPLY. OPS CHECKED GOOD IAW MM 33-51-06.SDR DALA201811216742Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED, SECURED LIGHT COVER 1RSDR ASAA2018112197026Lens · detachedOVERHEAD EXIT SIGN FELL DOWN AT ROW 17. GROUNDED - YES. REINSTALLED SIGN, OK FOR SERVICE.SDR ASAA2018112197021Battery Pack · dischargedEMERGENCY LIGHT ON HEADER PANEL ABOVE L1 & R1 DOORS IS INOP. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES S/N 82021 & 80248 ON HEADER PANEL ABOVE L1 & R1 DOORS. OPS CHK GOOD IAW B737-800 AMM 33-55-06.SDR AALA2018112109018Light · malfunctionedDURING TAXI OUT, EMERGENCY EXIT LIGHTS CAME ON AND WOULD NOT RESET. AIRCRAFT WAS NOT GROUNDED. MAINTENANCE PERFORMED POWER DOWN RESET IAW TSM 24-00-00 AND EMERGENCY LIGHTS MANUAL OPERATION IAW AMM 33-51-00-710-004A. MAINTENANCE ALSO PERFORMED SATISFACTORY SDR SWAA2018112127001Light · inoperativeL2 DOOR EMERGENCY SLIDE LIGHT INOP. R&R LAMP IAW AMM.SDR SWAA2018112126993Lens · looseRT LOWER EMERGENCY EXIT SIDEWALL LIGHT LENS LOOSE AT ROW 12. SECURED COVER IAW MM.
Back to JASC 3350