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 SCNA20180130015Battery Pack · defectiveFOUND AFT MOST EMERGENCY BATTERY PACK TO BE BAD DURING CAPACITY FUNCTIONAL CHECK. REPLACED AFT MOST EMERGENCY BATTERY PACK. ALL FUNCTIONAL/OPERATIONAL CHECKS GOOD.SDR DALA2018013000564Lens · damagedEMERGENCY LIGHT LENS DAMAGED AT SEAT 18F. INSTALLED A NEW LENS. OPS NORMAL.SDR SWAA2018013019398Housing · looseAFT OVERHEAD EMERGENCY EXIT SIGN HOUSING ASSEMBLY LOOSE. R&R SIGN ASSEMBLY IAW AMM.SDR R61A201801300093Light · inoperativeEMERGENCY LIGHT STRIP NEAR SEAT 1A HAS PLACES THAT DO NOT ILLUMINATE. R & R IAW AMM 33-50-21.SDR YENA201801300048Epsu · no testLEFT OVERWING EPSU WILL NOT TEST. R & R THE EPSU IAW AMM 33-51-38. OPS CHECKED NORMAL. ACFT OK FOR SERVICE.SDR MASA2018013012943Battery Pack · dischargedROW 3/4 AFT FACING EMERGENCY EXIT SIGN INOPERATIVE. CHARGED THE BATTERY.SDR MASA2018013012944Bulb · inoperativeROW 18A EMERGENCY LIGHT TOP BULB INOPERATIVE.SDR SWAA2018020819524Light · faultyEMERGENCY EXIT LIGHT FAULTY. R & R THE LIGHT IAW AMM.SDR SWAA2018020719473Light · inoperativeL2 DOOR EMERGENCY SLIDE LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2018020519537Strip · delaminatedRT FLOOR MOUNTED EGRESS STRIPS DELAMINATED. R&R STRIPS PER DWG.SDR SWAA2018020519536Strip · delaminatedLT FLOOR MOUNTED EGRESS STRIPS DELAMINATED. R&R STRIPS PER DWG.SDR SWAA2018020519511Strip · delaminatedFORWARD ENTRY AREA FLOOR MOUNTED EGRESS STRIPS DELAMINATED. R&R STRIPS PER DWG.SDR SWAA2018020519509Lens · missingLT EMERGENCY EXIT BULLNOSE LENS MISSING AT ROW 12. INSTALLED LENS PER SIP.SDR AALA201801309013Lens · missingSEAT 20C EMERGENCY LIGHT LENS MISSING. INSTALLED A NEW LENS IAW AMM 33-51-19.SDR AALA20180130001Light · brokenAIRCRAFT WAS NOT GROUNDED: EXIT IDENTIFIER AT 4L DOOR, LENS WAS MISSING AND BROKEN. MAINTENANCE REPLACED BROKEN 4L EXIT IDENTIFIER SIGN AS REQUIRED AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER M/M 33-51-00.SDR AALA201801319024Lens · damagedTHE AIRCRAFT WAS NOT GROUNDED. SEVERAL EMERGENCY LIGHT LENS DAMAGED. THE LENS WAS REPLACED IAW AMM 33-51-03. OK FOR SERVICE.SDR AALA201801309029Light · missingEMERGENCY LIGHT AND BATTERY POWERED EMERGENCY LIGHT MISSING IN GALLEY 5 ON LEFT SIDE LOWER WALL ACCROSS FROM CENTER LAVATORY. REPLACED LIGHT ASSEMBLY.SDR DALA2018013000581Battery Pack · dischargedAFT AIRSTAIRS EMERGENCY LIGHT INOPERATIVE. REMOVED AND INSTALLED BATTERY PACK. OPERATION CHECKS GOOD.SDR ASAA2018012923332Battery Pack · malfunctionedFIRST CLASS EMERGENCY LIGHTS RAMDOMLY FLICKER ON AND OFF IN FLIGHT. ACFT GROUNDED. REMOVED AND REPLACED THE BATTERY PACK IAW WDM 33-51-12 AND AMM 33-51-06. PERFORMED OPS TESTED. SYS CHECKED NORMAL.SDR AALA201801309015Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT 3C EMERGENCY LIGHT LENS MISSING. REPLACED EMERGENCY LIGHT ASSY PER MM 33-50-00.SDR SWAA2018013119464Light · brokenAFT OVERHEAD EMERGENCY EXIT LIGHT BROKEN. R&R LIGHT ASSEMBLY IAW AMM.SDR AALA201801309027Battery Pack · dischargedDURING PREFLIGHT, FOUND THE OVERWING EMERGENCY LIGHTS ILLUMINATED WITH EMERGENCY EXIT LIGHT SWITCH IN OFF OR ARM. REPLACED EMERGENCY LIGHT BATTERY PACK IAW AMM 33-53-00.SDR GTIA201801290237Battery Pack · inoperativeFORWARD CENTER OVERHEAD EXIT LIGHT AND L1 DOOR EXIT LIGHT AND R1 DOOR EXIT LIGHT WILL NOT TURN ON. GAINED ACCESS TO BATTERY POWER PACK AND REPLACED UNIT WITH SERVICEABLE PACK IAW 33-51-38SDR AALA201801309024Knob · damagedTHE AIRCRAFT WAS NOT GROUNDED. LIGHT LENS/COVER/BEZEL DAMAGED AND KNOB MISSING FROM CENTER CONSOLE INTEG LIGHT. REPLACED INTEG LIGHT ADJUSTMENT KNOB AS REQUIRED.SDR QXEA2018013000034Light · looseFLOOR EMERGENCY LIGHT STRIP NEXT TO MCD IS LOOSE. REMOVED FROM SERVICE. SECURED THE EMERGENCY LIGHT, NO OTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR QXEA2018013000033Light · detachedEMERGENCY LIGHT STRIP NEXT TO SEATS 16 & 17 D,E FOUND DETACHED. OUT OF SERVICE. SECURED THE LIGHT. RETURNED TO SERVICE.SDR AALA201801309014Lens · crackedEXIT SIGN LENS ON THE L4 DOOR FELL OFF AND CRACKED. REPLACED EXIT SIGN LENS IAW AMM 33-50-00.SDR 29GA2018013000001Power Supply · inoperativeFIRST THREE ROWS OF THE FLOOR EMERGENCY LIGHTS ARE OUT AND EMERGENCY LIGHTS BETWEEN ROWS 7 AND 8 ARE OUT. RESECURRED EMERGENCY LIGHT STRIP AT ROW THREE, R & R THE POWER SUPPLY IAW AMM 33-50-10-04. OPS TEST GOOD IAW AMM 33-50-00.SDR DALA2018013000500Battery Pack · defectiveSEAT MOUNTED EMERGENCY LIGHTS FROM 31 BACK INOP. SUSPECT BATTERY PACK B5-212, STA 1233, RT OVERHEAD BIN. ACCESS PANEL OPENED. T/S PER WDM 33-51-14 SHT2, FOUND FUSE OF B5-212 BLOWN. ISOLATED TAIL CONE HANDLE LT ASSY, LT OPN NML, REMOVED WIRES L982T14 AND L983E1SDR CALA2018012900394Light · brokenEMERGENCY PATH LIGHT ROW 11 A-C IS BROKEN. REPLACED LIGHT ASSEMBLY. OPS CHECK GOOD.SDR CALA2018012900393Lens · brokenSEAT AISLE EEL LIGHT BROKEN. INSTALLED NEW LENS. OPS NORMAL. REF AMM 33-51-11.SDR CALA2018012900395Lens · looseEMERGENCY EXIT LIGHT COVER NEAR FLOOR AT DOOR 1L CAME OFF. SECURED EMERGENCY EXIT LIGHT COVER NEAR FLOOR AT L1 DOOR. OK TO CONTINUE.SDR AALA201801299007Lens · detachedFLIGHT ATTENDANCE FOUND THE EXIT LIGHT LENS ON THE FLOOR NEAR THE L4 DOOR. THE LENS WAS SECURED.SDR REXA2018012800121Lens · crackedMAIN CABIN CENTER OVERWING EXITS AFT EMERGENCY LIGHT LENS IS CRACKED. REMOVED AND REPLACED LENS IAW AMM 33-51-07-000-802-A01, PARA 4A, STEP 3, AND 33-51-07-400-802-A01, PARA 4A, STEP 5.SDR DALA2018020600697Power Supply · inoperativeDURING CHECK, FOUND SEAT 3C CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED THE POWER SUPPLY IAW AMM 33-51-11.SDR AALA20180129008Battery Pack · inoperativeEMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AND POWER SUPPLY IAW MM 33-51-06. OPS CHECKED GOOD.SDR HNAA2018020100022Switch · failedTHE EMERGENCY LIGHTS WILL NOT TURN OFF WHEN USING THE FA SWITCH. R & R THE EMERGENCY LIGHT SWITCH AT THE FLIGHT ATTENDENTS PANEL IAW WD 33-51-01. OPS CHECKED GOOD.SDR DALA2018013000577Lens · unknownEMERGENCY EXIT COVER DIFFUSER LENS MISSING/DAMAGED. REPLACED LIGHT LENS COVER. OPERATION CHECKS GOOD.SDR SWAA2018013119463Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK M1674 INOP. R&R BATTERY PACK PER AMM.SDR PNSA2018012801Power Supply · failedPOWER SUPPLY 15LN FAILED 6 MONTH FUNCTIONAL TEST.SDR DALA2018012800547Light · inoperativeEMERGENCY SEAT MOUNTED LIGHT AT SEAT 27D LOOSE. SECURED LOOSE EMERGENCY LIGHT ASSEMBLY.SDR SWAA2018013019437Light · inoperativeRT EMERGENCY LIGHT INOP AT ROW 11. RELAMPED LIGHT IAW AMM.SDR SWAA2018013019436Light · inoperativeR2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2018013019434Lamp · inoperativeLEFT EXTERNAL EMERGENCY LIGHT AFT OF NR 1 ENGINE INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWAA2018012919369Cover · unsecureOVERWING EMERGENCY EXIT LIGHT LENS COVER FELL OFF. SECURED COVER IAW FIM.SDR SWAA2018012919344Light · disconnectedCEILING EMERGENCY LIGHT INOP AT SEAT ROW 21. CONNECTED LIGHT IAW AMM.SDR AALA201801299029Bulb · burned outL1 DOOR EMERGENCY EXIT SIGN HAD TWO BULBS BURNED OUT. REPLACED THE BULBS IAW AMM 33-50-00. OPS CHECKED GOOD.SDR AALA201801299028Bulb · burned outEMERGENCY EXIT SIGN IN THE FORWARD CABIN, AFT FACING FOUR BULBS BURNED OUT. REPLACED THE LAMPS IAW AMM 33-51-16. OPS CHECKED GOOD.SDR YENA201801280045Light · inoperativeR2 DOOR TOP EMERGENCY LIGHT INOPERATIVE. R & R THE LIGHT ASSY OPS CHECKED GOOD IAW AMM 33-51-13.SDR REXA2018012800052Lamp · inoperativeEMERGENCY LIGHTS SWITCH LIGHT, BULBS INOPERATIVE. REPLACED THE LAMPS IAW ESPM 20-24-00.
Back to JASC 3350