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 DALA2017081106226Lens · missingEMERGENCY EXIT COVER DIFFUSER LENS MISSING. REMOVED EXIT SIGN, RE-INSTALLED RIGHT SIDE UP OK FOR SERVICE.SDR DALA2017081106225Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED. REMOVED EXIT SIGN, INSTALLED RIGHT SIDE UP. OK FOR SERVICE.SDR N6WA2017081001Bulb · inoperativeEXIT ROW BY C & D HAS TWO BULBS OUT IN EMERGENCY LIGHT. R & R THE BULBS, OPS CHECKED GOOD IAW AMM 33-51-09.SDR SIMA20170810001Light · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-50-10. OPS CHECKED GOOD.SDR IPXA2017081020341Battery Pack · dischargedFOUND LEFT EMERGENCY POWER SYSTEM BATTERY PACK LOW, TEST FAILED. R & R THE BATTERY PACK IAW AMM 52-23-14. OPS CHECKED GOOD.SDR AALA201708119015Lens · missingLENS COVER SEAT 1C (EMERGENCY LIGHT) MISSING. REPLACED LIGHT LENS COVER ON SEAT 1C.SDR AALA201708119013Lens · missingROW 18 EMERGENCY SEAT LIGHT LENS MISSING. REPLACED ROW 18 EMERGENCY SEAT LIGHT LENS.SDR AALA201708119012Light · inoperativeROW 27 EMERGENCY SEAT LIGHT HAS LIGHT OUT. INSTALLED NEW BULB ROW 27 EMERGENCY SEAT LIGHT.SDR AALA201708119011Lens · missingR4 DOOR EMERGENCY LIGHT LENS MISSING. REPLACED EMERGENCY LIGHT LENS COVER, LIGHT OPS NORM.SDR AALA201708119010Lens · crackedCRACK DOOR FRAME PASSENGER CREW DOOR EMERGENCY EXIT LIGHT LENS (4EA) IN PASSENGER CABIN. EMERGENCY EXIT LIGHT LENS REPLACED.SDR DALA2017081006130Battery · dischargedAFT OVERWING EXIT LIGHTS INOP. R&R BATTERIES IN B-5105. OPS CK SAT AMM 33-53.SDR SWAA2017081615741Battery · failedCENTER RT EMERGENCY BATTERY FAILED TIME TEST. R&R BATTERY PER AMM.SDR SWAA2017081615740Battery · failedAFT RT EMERGENCY BATTERY FAILED TIME TEST. R&R BATTERY PER AMM.SDR SWAA2017081615733Battery · failedFORWARD LT EMERGENCY BATTERY FAILED TIME TEST. R&R BATTERY PER AMM.SDR SWAA2017081515671Battery Pack · dischargedL2 DOOR EMERGENCY LIGHT INOP. R&R BATTERY PACK PER MM.SDR SWAA2017081415643Lens · missingR2 DOOR LOWER EMERGENCY EXIT LIGHT COVER MISSING. R&R LENS IAW AMM.SDR SWAA2017081515589Charger · inoperativeL2 DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE HOUSING BATTERY CHARGER IAW MM.SDR SWAA2017081515586Lens · brokenLEFT EMERGENCY LIGHT LENS BROKEN BETWEEN ROWS 23 & 24. R & R THE LENS IAW AMM.SDR AALA201708119027Latch · unsecureEMERGENCY LIGHT SWITCH WILL NOT STAY IN ARMED POSITION WITH COVER DOWN. MAINTENANCE SECURED THE SPRING LATCH IAW AMM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708119025Light · brokenEMERGENCY EXIT LIGHT FIXTURE BROKEN AT THE R1 DOOR. REPLACED THE LIGHT FIXTURE IAW AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708119024Light · unsecureL2 DOOR EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. SECURED THE LIGHT IAW SRM 33-51-00 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708119023Connector · disconnectedFIRST CLASS SEAT 2E BOTH EMERGENCY LIGHTS ARE INOPERATIVE. FOUND CONNECTOR AT 2E WALL DISCONNECTED. CONNECTED IAW AMM 33-51-11.SDR SWAA2017081415637Power Supply · inoperativeAFT LEFT CABIN EMERGENCY LIGHT INOPERATIVE. R & R POWER SUPPLY IAW AMM.SDR 7C7A2017080900334Control Box · inoperativeEMERGENCY LIGHTS CONTROL BOX INOPERATIVE. REMOVED AND REPLACE THE EMERGENCY LIGHT CONTROL BOX IAW 33-51-00.SDR DALA2017081006168Lens · detachedEMERGENCY LIGHT LENS AT THE L1 DOOR HAS FALLEN DOWN. SNAPPED THE LENS INTO THE LIGHT ASSEMBLY.SDR AALA201708109033Cover · detachedTHE AIRCRAFT WAS NOT GROUNDED. FORWARD RIGHT GALLEY DOOR EXIT SIGN COVER, LEFT OF DOOR, CAME OFF. REPLACED EMERGENCY LIGHT EXIT SIGN AT FWD RIGHT GALLEY DOOR PER MM 33-51-01, CKS GOOD.SDR AALA201708109032Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. FORWARD GALLEY, ISLE EXIT LIGHT MISSING. REMOVED AND REPLACED FWD GALLEY ISLE EXIT LIGHT LENS IAW AMM 33-50-00 OPS CHECK NORMAL.SDR AALA201708109031Light · defectiveTHE AIRCRAFT WAS NOT GROUNDED. LENS ON EMERGENCY EXIT LIGHT BY RIGHT AFT CABIN DOOR WILL NOT STAY ON. REMOVED & REPLACED EMERGENCY LIGHT ASSY AT AFT CABIN SERVICE DOOR IAW MM 33-51-14 OPS CK OK. EMERGENCY LIGHT CHECK OK.SDR ASOA201708112003Charger · inoperativeWHILE PERFORMING AN OPERATIONAL TEST OF THE EMERGENCY LIGHTING SYSTEM, FOUND THE PAX DOOR, SERVICE DOOR AND NR 1 EMERGENCY FLOOD LIGHTS INOPERATIVE. REMOVED AND REPLACED THE NR 1 EMERGENCY BATTERY CHARGER AND POWER SUPPLY UNIT. OPS NORMAL.SDR AALA201708119002Battery · failedAIRCRAFT WAS NOT GROUNDED. MID CABIN EMERGENCY POWER SUPPLY BATTERY FAILING BITE TEST. REPLACED EMERGENCY POWER SUPPLY BATTERY PER AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR R61A201708090602Battery Pack · inoperativeAFT LT EMERGENCY LIGHT WON'T TEST. R & R THE BATTERY PACK IAW AMM 33-50-01.SDR DALA2017081006152Light · inoperativeEMERGENCY SEAT MOUNTED LIGHT DAMAGED AND INOPERATIVE. SECURED THE LIGHT ASSY. OPS CHECKED GOOD.SDR DALA2017081006143Battery Pack · inoperativeEMERGENCY LIGHTS AT SEAT 18 RIGHT ROW FROM AFT SIDE INOPERATIVE. REPLACED BATTERY OF M732 POWER SUPPLY. SYSTEM OPERATION IS NORMAL.SDR REXA2017080900867Light · inoperativeONE EXTERIOR EMERGENCY LIGHT FOUND INOPERATIVE. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-21, OPS CHECKED GOOD.SDR AALA201708109020Lens · detachedEMERGENCY EXIT LIGHT AT GAGE OF CABIN ENTRY DOOR 1L LENS DETACHED. REPLACED EMERGENCY EXIT LIGHT LENS COVER AT L1 DOOR.SDR DALA2017081000214Cover · looseEMERGENCY EXIT SIGN COVER LOOSE AND LOCATION 605. RE-INSTALLED EXIT SIGN COVER.SDR HALA2017080900219Light · inoperativeROW 16 RIGHT SIDE WALKING EMERGENCY LIGHT INOP. EMERGENCY FLOOR LIGHTING AT ROWS 39-44 AB INOP. REPAIRED FLOOR LIGHTING AT ROW 16R. GND
OPS CHK OK, AMM 33-51-00. REPAIRED FLOOR LIGHTING AT ROW 39-44 L. GND OPS CHK OK, AMM 33-51-00.SDR AALA201708109017Battery · failedAIRCRAFT WAS NOT GROUNDED. EPSU BATTERY AT DOOR 4L (17WL) FAILED TEST. REPLACED EPSU BATTERY AT 17WL.SDR AALA201708109016Battery · failedAIRCRAFT WAS NOT GROUNDED. EPSU BATTERY AT DOOR 2L (13WL) FAILED TEST. REPLACED EPSU BATTERY AT 13WL.SDR AALA201708109015Battery · failedAIRCRAFT WAS NOT GROUNDED. EPSU BATTERY AT DOOR 1L (11WL) FAILED TEST. REPLACED EPSU BATTERY AT 11WL.SDR AALA20170809001Sign · brokenAIRCRAFT WAS NOT GROUNDED. L1 DOOR LOWER EMERGENCY EXIT SIGN, BROKEN OFF LOWER FASTENER. REPLACED L1 DOOR, CABIN WALL MOUNTED EMERGENCY EXIT MARKER PER MM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR ASOA201708094047Battery Pack · dischargedTHE CREW REPORTED THAT NOT ALL EMERGENCY LIGHTS ILLUMINATE WHEN THE SYSTEM TURNS ON, WITH THE FOLLOWING BEING INOP.; REAR PART OF EXIT ROW O/HEAD SIGN, BOTH SIDEWALL EXIT SIGNS ON LEFT SIDE, ONLY WALL SIGN ON RIGHT SIDE EXIT ROW. MAINTENANCE INSPECTED THE AIRCSDR MASA2017080912523Power Supply · inoperativeLOWER LEFT ROW 13 EMERGENCY SIGN INOPERATIVE. R & R THE EMERGENCY LIGHT POWER SUPPLY.SDR MASA2017080912522Light · inoperativeUPPER RIGHT ROW 12 EMERGENCY LIGHT INOPERATIVE.SDR DALA2017081006122Power Supply · inoperativeRIGHT FWD TWO EXTERIOR EMERGENCY LIGHTS INOPERATIVE. REPLACED THE POWER SUPPLY, CHECKED OK IAW MM 33-51.SDR YENA201708090650Battery · no testEPSU 12WL FAILED TEST. R & R THE EPSU BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR YENA201708090649Battery · failedEPSU 10WL, 13WL FAILED TO TEST. R & R THE EPSU BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR YENA201708090648Battery · failedEPSU 10WL FAILED TEST; R & R THE EPSU BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR YENA201708090647Battery · failedEPSU FAILED TEST. R & R THE EPSU BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR AALA201708159006Sign · brokenDOOR EXIT SIGN BASE FOUND BROKEN AT L2 DOOR 2L AFT. REPLACED DOOR EXIT SIGN BASE PER AMM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.
Back to JASC 3350