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 YENA201903230150Power Unit · failedFLT 1736, MSP-BOS. BOTH AFT EMERGENCY LIGHT POWER UNIT FAILED FUNCTIONAL TEST; R & R BOTH AFT EMERGENCY LIGHT POWER UNITS REF AMM CH 33-50-01. OPS CHECK OK.SDR YENA201903230149Power Unit · failedFLT 1736, MSP-BOS. BOTH AFT EMERGENCY LIGHT POWER UNIT FAILED FUNCTIONAL TEST; R & R BOTH AFT EMERGENCY LIGHT POWER UNITS REF AMM CH 33-50-01. OPS CHECK OK.SDR DALA2019032501937Lens · missingSHIP 5815 LENS MISSING AT DOOR 3LOCATION. EXIT SIGN MOUNTED ON CEILING. CORRECTIVE ACTION: REATTACHED EXIT SIGN CHECK NORMAL. (0998630)SDR DALA2019032501932Light · missingSHIP 5655 SEAT 22 MISSING EMERGENCY LIGHT. CORRECTIVE ACTION: REPLACED EMERGENCY LIGHT & HOUSING ASSY. (5250869)SDR IPXA2019032540482Light · inoperativeINSPECTION TYPE:N/A CREW ENTRY DOOR EMERGENCY EXIT SIGN BOTTOM LIGHT BULB INOP. RELAMPED CREW ENTRY DOOR EMER EXIT SIGN IAW A300-MM 33-51-13 O/C GOOD.SDR AALA201903264001Power Supply · failedCIDS DISPLAYED AN EPSU FAILED 13WL, AFT LEFT. DURING A SYSTEM FUNCTIONAL CHECK. REMOVED AND REPLACED THE ESPU IAW AMM 33-51-38. OPS CHECKED GOOD.SDR ASAA2019032328745Sign · inoperativeEMERGENCY EXIT SIGN AFT OF L2 DOOR WILL NOT ILLUMINATE. GROUNDED - YES. REMOVED & REPLACED EMERGENCY EXIT SIGN ASSY REF AMM 33-51-01-960-802. OPS CK GOOD PER THE SAME.SDR SWAA2019032531027Light · inoperativeLT AFT DOOR EXIT SIGN BULB BURNED OUT. R&R BULB IAW AMM.SDR SWAA2019032531026Light · inoperativeRT WING EMERGENCY EXIT DOOR LIGHT BULBS BURNED OUT AND ASSEMBLY CRACKED. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2019032531025Light · inoperativeL1 DOOR EXIT SIGN BULBS BURNED OUT. R&R BULBS PER AMM.SDR SWAA2019032531020Light · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER SIP.SDR SWAA2019032531014Light · inoperativeLT EMERGENCY AISLE LIGHT INOP AT SEAT 9. RELAMPED LIGHT IAW AMM.SDR SWAA2019032530965Strap · brokenONE EMERGENCY FLASH LIGHT STRAP BROKEN. R&R STRAP IAW SIP.SDR DALA2019032301881Light · inoperativeEMERGENCY LIGHTS AT 14D & 36D INOP. RELAMPED BOTH LIGHTS OPS CKS PER AMM 33-50. (LP3412955)SDR SWAA2019050232140Fuse · blownNR 4 RT STOW BIN EMERGENCY LIGHT INOP. R&R M1669 POWER SUPPLY FUSE IAW AMM.SDR DALA2019032201935Sign · inoperativeSHIP 5803 EMERGENCY EXIT SIGNS INOPERATIVE / LOCATIONS: 37. CORRECTIVE ACTION: RE ATTACHED EXIT SIGN AT 37. (0996290)SDR SIMA20190322005Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP. C/A-RAR EXTERNA EMERGENCY LIGHT LAMP IAW AMM 33-50-10-000-801-A AND 33-50-10-400-801-A OPS CHECK GOOD.SDR AALA201903259010Power Supply · no testEMERGENCY LIGHT POWER SUPPLY FAILED TO TEST IAW A PS CHECK. MAINTENANCE REPLACED THE POWER SUPPLY IAW AMM 33-51-38, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR CALA2019032500461Battery · dischargedDATA TRANSFER REF NON-ROUTINE NR :V905483 - SPEC NR B777-33-3-7019 OPERATION CHECK FOUND L3 DOOR AREA EMERGENCY LIGHT PARTIAL INOP. THE L3 DM33400 BATTERY WAS REPLACED AND CARRY OUT TEST FOUND ''NORMAL'' REF AMM 33-51-06-960-802 REV85 PN ON AD-D717-01-100 SN OSDR SWAA2019032531019Battery Pack · failedBATTERY PACK AT POSITION M1673 FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2019032531001Lens · missingR1 DOOR EMERGENCY EXIT LOWER LIGHT LENS MISSING DIRECTIONAL ARROW. R&R SIGN PER SIP.SDR SWAA2019032530971Lens · looseEMERGENCY LIGHT LENS LOOSE AT AFT OVERWING EXIT. REINSTALLED LENS IAW AMM.SDR SWAA2019032530966Lens · missingLT EMERGENCY EXIT DOOR EXIT LIGHT LENS MISSING. R&R LENS PER MM.SDR SWAA2019032530946Cover · unsecureCENTER AISLE OVERHEAD OVERWING EXIT SIGN COVERS FELL OFF. INSTALLED SIGN COVERS IAW MM.SDR MASA2019032211772Light · inoperativeSVC DR LWR AFT EMER LT 3 BULBS INOP. RELAMPED.SDR MASA2019032211771Light · inoperativePAX DOOR EMER SIGN LIGHTS INOP. RELAMPED.SDR UIEA2019032203604Battery Pack · dischargedTROUBLESHOOT EMERGENCY LIGHTS. (<P>REMOVED AND INSTALLED NEW EMERGENCY LIGHT BATTERY PACK #3 IAW AMM 33-51-07-022-001 AND 33-51-07-422-012. OPERATIONAL TEST OF THE NEW EMERGENCY LIGHT BATTERY PACK CHECKS GOOD IAW AMM 33-51-07-712-009. </P>)SDR UIEA2019032203605Battery Pack · dischargedTROUBLESHOOT EMERGENCY LIGHTS. (<P>REMOVED AND INSTALLED NEW EMERGENCY LIGHT BATTERY PACK #6 IAW AMM 33-51-07-022-001 AND 33-51-07-422-012. OPERATIONAL TEST OF THE NEW EMERGENCY LIGHT BATTERY PACK CHECKS GOOD IAW AMM 33-51-07-712-009. </P>)SDR UIEA2019032203606Battery Pack · dischargedTROUBLESHOOT EMERGENCY LIGHTS. (<P>REMOVED AND INSTALLED NEW EMERGENCY LIGHT BATTERY PACK #10 IAW AMM 33-51-07-022-001 AND 33-51-07-422-012. OPERATIONAL TEST OF THE NEW EMERGENCY LIGHT BATTERY PACK CHECKS GOOD IAW AMM 33-51-07-712-009. </P>)SDR UIEA2019032203607Battery Pack · dischargedTROUBLESHOOT EMERGENCY LIGHTS. (<P>REMOVED AND INSTALLED NEW EMERGENCY LIGHT BATTERY PACK #11 IAW AMM 33-51-07-022-001 AND 33-51-07-422-012. OPERATIONAL TEST OF THE NEW EMERGENCY LIGHT BATTERY PACK CHECKS GOOD IAW AMM 33-51-07-712-009. </P>)SDR UIEA2019032203608Battery Pack · dischargedTROUBLESHOOT EMERGENCY LIGHTS. (<P>REMOVED AND INSTALLED NEW EMERGENCY LIGHT BATTERY PACK #12 IAW AMM 33-51-07-022-001 AND 33-51-07-422-012. OPERATIONAL TEST OF THE NEW EMERGENCY LIGHT BATTERY PACK CHECKS GOOD IAW AMM 33-51-07-712-009. </P>)SDR VNAA2019032111102Battery Pack · dischargedEMERGENCY LIGHTED SIGN AT FLIGHT ATT SEAT WILL NOT ILLUMINATE. REMOVED AND REPLACED BATTERY PACK. OPS CHECK GOOD. IAW CRJ 700 AMM 33-51-17-000-802/400-802SDR DALA2019040702286Cover · missingL1 DOOR LOWER EXIT SIGN COVER MISSING, REPLACED L1 DOOR EXIT SIGN COVERSDR DALA2019040202098Lens · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / INTERIOR. INSTALLED LENS OK FOR SVC.SDR DALA2019040202097Lens · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / INTERIOR. INSTALLED LENS. OK FOR SVC.SDR AALA201903259009Battery Pack · no testEMERGENCY LIGHT ON THE COCKPIT OVERHEAD PANEL, DID NOT ILLUMINATE. MAINTENANCE REPLACED THE BATTERY PACK AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-50-00.SDR SWAA2019032531054Fuse · blownR1 DOOR EMERGENCY LOWER LIGHT INOP. R&R POWER SUPPLY FUSE IAW AMM.SDR SWAA2019032531053Fuse · blownL1 DOOR EMERGENCY LOWER LIGHT INOP. R&R POWER SUPPLY FUSE IAW AMM.SDR SWAA2019032531052Battery Pack · dischargedRT EXTERNAL EMERGENCY LIGHTS AFT OF FLAPS INOP AT M1670. INSTALLED BATTERY PACK IAW AMM.SDR SWAA2019032531051Light · inoperativeL1 DOOR EMERGENCY EXIT SLIDE LIGHT INOP. R&R LAMP PER AMM.SDR SWAA2019032531024Light · inoperativeOVERWING EMERGENCY EXIT LIGHT INOP. R&R LAMP PER AMM.SDR SWAA2019032531013Fuse · blownR1 DOOR EMERGENCY LIGHT ABOVE DOOR INOP. R&R POWER SUPPLY FUSE IAW AMM.SDR SWAA2019032531012Fuse · blownL1 DOOR EMERGENCY LIGHT ABOVE DOOR INOP. R&R POWER SUPPLY FUSE IAW AMM.SDR SWAA2019032531011Battery Pack · dischargedLT EXTERNAL EMERGENCY LIGHTS AFT OF FLAPS INOP AT M1670. INSTALLED BATTERY PACK IAW AMM.SDR DALA2019032201898Lens · damaged(AIRCRAFT 7107, L/P 0995030) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. INSTALLED LENS OK FOR SVC.SDR CALA2019032200451Battery Pack · dischargedDATA TRANSFER REF NON-ROUTINE 9475248, SPEC NO.B777-33-3-7019 - EMERGENCY LIGHT BATT PACK CAPACITY CHK FND DR2 RT BATT PACK DM33098 OUT OF LIMIT P/N:ADD717-01-100. PERFORMED EMERGENCY LT BATTERY PACK REPLACED AND EMERGENCY LT TEST CARRIED OUT THE RESULT FND "SSDR CALA2019032200450Battery Pack · dischargedDATA TRANSFER REF NON-ROUTINE 9475250, SPEC NO.B777-33-3-7019 - EMERGENCY LIGHT BATT PACK CAPACITY CHK FND DR4 RT BATT PACK DM33409 BATT PACK OUT OF LIMIT P/N:ADD717-01-1 00. PERFORMED EMERGENCY LT BATTERY PACK REPLACED AND EMERGENCY LT TEST CARRIED OUT THE RESDR CALA2019032200449Battery Pack · dischargedDATA TRANSFER REF NON-ROUTINE 9475246, SPEC NO:B777-33-3-7019 - EMERGENCY LT BATTERY PACK CAPACITY CHK FND DR2 LIGHT BATT PACK (DM33096) OUT OF LIMIT P/N:ADD717-01-100. PERFORMED EMERGENCY LT BATTERY PACK REPLACED AND EMERGENCY LIGHT TEST CARRIED OUT THE RESULSDR SIMA20190321004Light · inoperativeMAIN DOOR EMERGENCY LIGHT INOP. C/A-RAR MAIN DOOR EMERGENCY LIGHT LAMP IAW AMM 33-50-06-000-801-A AND 33-50-06-400-801-A OPC GOOD AT THIS TIME.END.SDR SIMA20190321002Light · inoperativeEXT OVER WING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED NR 4 BATTERY CHARGER ASSEMBLY. OPS CHECK FAILED. DEFERRED AFT EXTERNAL EMERGENCY LIGHTS AS PER MEL 33-29 AUTH# 030740D-C. REMOVED AND REPLACED BATTERY CHARGER NR 4 DID NOT FIX. REMOVED AND REPLACED R
Back to JASC 3350