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 SWAA2019032130884Light · looseCEILING EXIT LIGHT LOOSE AT ROW 12. R&R LIGHT ASSEMBLY IAW AMM.SDR ASAA2019031928675Light · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOP. GROUNDED - YES. RELAMPED EMERGENCY LIGHT OPS CHEKED GOOD REF AMM 33-51-04.SDR SWAA2019032030853Lens · missingR1 DOOR LOWER EMERGENCY EXIT LIGHT LENS MISSING DIRECTIONAL ARROW. R&R LENS IAW AMM.SDR SWAA2019032030845Lens · unsecureRT OVERWING EMERGENCY EXIT SIGN LENS FELL OFF. R&R LENS PER SIP.SDR SWAA2019032030843Cover · unsecureEXIT SIGN OVER AISLE COVER FELL OFF. REINSTALLED SIGN COVER PER SIP.SDR DALA2019031901824Battery · dischargedTHE EMERGENCY LIGHTS AT ROWS 15-19 ARE INOPERATIVE. MAINTENANCE INSTALLED A SERVICEABLE EMERGENCY LIGHT BATTERY POWER SUPPLY AND BATTERY PER AMM 33-51-03. (LP #5291341)SDR DALA2019031901896Power Supply · inoperative(AIRCRAFT 7109, L/P 5801331) EMERGENCY LIGHTS ON SEATS 10-12 L/R INOP. CORRECTIVE ACTION: REPLACED POWER SUPPLY PER AMM 32-52 OPS CKS GOOD.SDR SWAA2019032130898Power Supply · failedLT SIDE EMERGENCY EXIT LOWER EXTERIOR ESCAPE SLIDE LIGHT FAILED TO ILLUMINATE. R&R POWER SUPPLY IAW AMM.SDR SWAA2019032130897Power Supply · failedRT SIDE EMERGENCY EXIT LOWER EXTERIOR ESCAPE SLIDE LIGHT FAILED TO ILLUMINATE. R&R POWER SUPPLY IAW AMM.SDR SWAA2019032130896Light · inoperativeLT STOWBINS EGRESS LIGHTS FAILED TO ILLUMINATE BETWEEN ROW 9 TO ROW 13. R&R LIGHT LAMP IAW AMM.SDR SWAA2019032030877Light · inoperativeL1 DOOR EGRESS LIGHT FAILED TO ILLUMINATE. R&R LAMP IAW AMM.SDR SWAA2019032030876Light · inoperativeRT SIDE OVERWING EXIT UPPER SIDEWALL PANEL EXIT LIGHT FAILED TO ILLUMINATE. R&R LIGHT IAW AMM.SDR SWAA2019032030849Sign · brokenMID CABIN OVERHEAD EXIT SIGN BRACKET BROKEN. R&R SIGN IAW MM.SDR SWAA2019032030841Cover · looseAFT ENTRY "EXIT" SIGN LOOSE. SECURED COVER PER SIP.SDR IPXA2019031940219Battery · dischargedINSPECTION TYPE:NA EMERGENCY POWER BATTERY 1 LOW MSG. R&R EMERGENCY POWER BATTERY IAW AMM 33-51-01-000-802. OPS CHK GOOD. A/C OK FOR SERVICE.SDR ASAA2019031828659Battery Pack · dischargedLT FWD OVERWING EMERGENCY EXIT LIGHT INOP. GROUNDED - YES. REMOVED AIR GRILLE AT STA 565 LBL68 IAW AMM 21-23-03-00-801, REMOVED AND REPLACED EMERGENCY EXIT LIGHT POWER SUPPLY AND BATTERY PACK M1694 AND INSTALLATION TEST GOOD IAW AMM 33-51-06-960-805 AND AMM 33SDR SWAA2019031930837Light · inoperativeEXIT ROW LIGHT ON CAPTAINS SIDE NOT ILLUMINATED. RELAMPED LIGHT PER MM.SDR DALA2019031901822Light · damagedEMERGENCY FLOOR LIGHTNING DAMAGED AT GALLEY 1A. REPLACED EMERGENCY FLIGHT LIGHT. LP 0991317SDR SWAA2019031930732Light · inoperativeRT EMERGENCY LIGHT INOP AT SEAT ROW 6. INSTALLED LIGHT PER AMM.SDR F3LA2019031900026Power Supply · faultedDISCREPENCY: REFERENCE LP1109889 ITEM 2, EMERGENCY EXIT LT MID AIRCRAFT POWER SUPPLY FAULT (11WL). CORRECTIVE ACTION: REMOVED AND REPLACED POWER SUPPLY UNIT REFERENCE AMM 33-51-38 PAGE BLOCK 401. TEST OK./END/SDR F3LA2019031900025Battery · faultedDISCREPENCY: REFERENCE LP1109889 ITEM 1, EMERGENCY EXIT RT MID AIRCRAFT POWER SUPPLY UNIT BATTERY FAULT (12WL)
CORRECTIVE ACTION: REMOVED AND REPLACED BATTERY REFERENCE AMM 33-51-38 PAGE BLOCK 401. TEST OK./END/SDR CALA2019031800432Power Supply · failedEMERGENCY LIGHT TEST FOR NR 2 SERVICE FAILS TEST WITH AFT LEFT UNIT FAULTIN. AFT CURTAIN ROD AND AFT PANEL AT DOOR 2 LT IS REMOVED FOR ACCESS REPLACED 13WL EXIT POWER UNIT...NO FAULTS...INSTALLED CURTAIN ROD ASSY AND CEILING PANEL ROTABLE PARTS CHANGE WAS INDISDR DALA2019031801766Battery Pack · dischargedAFT CAT WALK TAIL CONE EMERGENCY LIGHT INOP. REMOVED AND REPLACED AFT REAR BATTERY PACK. IAW AMM 35-33 OPS CHECK OK. PN AD4002P. (LP5765082)SDR DALA2019031801765Battery Pack · dischargedL & R AFT EMERGENCY UPPER EXIT LIGHTS INOP. REMOVED & REPLACED ASSOCIATED BATTERY PACK LTS PER AMM 33-53. OPS CHECK GOOD. (LP5516259)SDR DALA2019031801758Battery Pack · dischargedLT AND RT OVER WING THRESHOLD EMERGENCY LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHTS BATTERY PACK AT LOCATION B6-121 PER AMM 33-55. OPERATIONAL CHECK WAS GOOD. A/C OK FOR SERVICE. (LP #4992365)SDR VNAA2019100217101Sign · inoperativeRH EXTERNAL MIDDLE OVERWING EMERGENCY LIGHT INOP. PERFORMED OPS CHECK ON RH EMRGENCY EXIT LOWER SIGN. IAW CRJ200 AMM 33-51-00-710-801. OPS CHECK GOOD AT THIS TIME.SDR DALA2019040702287Light · inoperativeEMERGENCY PATH LIGHT AT SEAT 27C INOP, INSTALLED NEW FLOOR PROXIMITY ESCAPE PATH LIGHT ASSY @ SEAT 27CSDR DALA2019040702284Shroud · brokenSEAT 37C EMERGENCY LIGHT SHROUD BROKEN, REPLACED 37C EMERGENCY LIGHT SHROUDSDR DALA2019040702267Power Supply · inoperativeWHILE WORKING L1 SLIDE CHANGE WITH W/C 2561-4003LF, RECEIVED " EPSU INT LOAD FWD L" FAULT DURING OPERATIONAL CHECK OF THE ESCAPE -FACILITIES, REPLACED EPSU (10WL)SDR SWAA2019032030880Light · inoperativeRT OVERWING EMERGENCY EXIT LOCATER LIGHTS BULBS INOP. R&R BULBS PER AMM.SDR SWAA2019032030866Light · inoperativeLT OVERWING EMERGENCY EXIT LOCATER LIGHTS BULBS INOP. R&R BULBS PER AMM.SDR AALA2019031989019Light · missingMISSING EMERGENCY LIGHT LENS AT SEAT ROW 34ABC. MAINTENANCE REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-19.SDR SWAA2019031930836Circuit Breaker · trippedAFT GALLEY CEILING EXIT "EXIT SALIDA" LIGHTS INOP. RESET CIRCUIT BREAKER P18-3 IAW AMM.SDR SWAA2019031930819Circuit Breaker · trippedFORWARD GALLEY OVERWING EXIT "EXIT SALIDA" LIGHTS INOP. RESET CIRCUIT BREAKER P18-3 IAW AMM.SDR AALA201903199010Light · inoperativeMAINTENANCE FOUND THE CABIN CEILING EMERGENCY LIGHT ABOVE ROW 8 TO BE INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-11.SDR DALA2019031801817Light · inoperativeDURING SERVICE CHECK, FOUND ALL EMERGENCY LIGHTS INOP IN LOWER CREW REST. REPLACED ALL BULBS. SYSTEM OPERATION IS NORMAL.SDR DALA2019031801785Battery Pack · dischargedDURING SVC CHECK FOUND LOWER AFT BULKHEAD EMERGENCY EXIT LIGHT INOP. FOUND EMERGENCY LIGHT BATTERY DEAD. R+R BTTERY PACK PER AMM 33-51. OPS CHECK GOOD. A/C OK FOR SVC. (LP# 5606332)SDR SIMA20190317002Light · inoperativeOVERHEAD EMERGENCY LIGHT NR 3 FROM FWD IN CEILING PANEL INOP. C/A-REMOVED AND REPLACED OVERHEAD EMERGENCY LIGHT NR 3 FROM FWD BULB IAW AMM 33-50-08 OPS CHECK GOOD.SDR DALA2019031801776Power Supply · inoperativeON ARRIVAL, FOUND DISPATCH MESSAGE "CABIN EMERGENCY EXIT LIGHT". REPLACED EMERGENCY POWER SUPPLY UNIT 102WL3. LP 3391175SDR MASA2019031911762Light · inoperativeROW 13 CEILING EMER LIGHT INOP. REPLACED BULB.SDR MASA2019031711761Light · inoperativeROW 13 FLOOR LEVEL EXIT SIGN INOP. REPALCED BULB.SDR DALA2019040702277Light · broken15D EMERGENCY EXIT PATH LIGHT HOUSING BROKEN, REPLACED PATH LIGHT HOUSING ASSYSDR YENA201903160138Terminal · disconnectedFLT 27, EWR-MCO. EMERGENCY LGT INSIDE ABOVE EXIT ROW INOP; T/S EMERG EXIT SIGN LT FOUND TERMINAL NOT CONNECTED. RECONNECTED TERMINAL. OPS CHECK NORMAL. OK FOR SVC.SDR IPXA2019031840173Light · inoperativeINSPECTION TYPE:NA EMERGENCY EGRESS LIGHT INOP. RELAMPED W/REF TO 33-51-06 OPS CK GOOD.SDR MYWA2019F00162Light · inoperativeFORWARD CEILING EMERGENCY LIGHT INOP.SDR AALA2019031989017Light · not seatedL3 DOOR EXTERIOR EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE SEATED THE LIGHT AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER MM 33-512-00.SDR AALA201903198001Battery Pack · no testSEAT MOUNTED EMERGENCY LIGHTS WERE DIM DURNG A TEST. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-51-01, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201903199006Power Supply · inoperativeMAINTENANCE FOUND THE POWER SUPPLY 10WL HAD FAILED DURING A SYSTEM TEST. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-38. OPS CHECKED NORMAL.SDR AALA2019031989021Battery Pack · inoperativeMAINTENANCE FOUND THE OVERHEAD EMERGENCY LIGHTS INOPERATIVE FROM ROWS 11 TO 18. REPLACED THE BATTERY PACK ASSEMBLY B5-102 IAW AMM 33-53-00. OPS CHECKED GOOD.SDR AALA2019031989016Socket · brokenMAINTENANCE FOUND THE FLOOR EMERGENCY LIGHT AT THE FIRST CLASS GALLEY, RT SIDE, WITH THE SOCKET BROKEN. REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-00. OPS CHECKED NORMAL.
Back to JASC 3350