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 IPXA2020062406875Lens · missingEMERGENCY EXIT LIGHT LENS MISSINGREPLACED THE MISSING EXIT LIGHT LENS...SDR I5EA2020062418003Light · inoperativeEMERGENCY LIGHT INOP R/H FWD CABIN.SDR I5EA2020062418002Light · inoperativeEMERGENCY LIGHT INOP FWD EMERGENCY EXIT R/HSDR I5EA2020062370003Light · inoperativeEMERGENCY LIGHT INOP R/H FWD CABIN.SDR I5EA2020061700002Light · inoperativeEMERGENCY LIGHT INOP FWD EMERGENCY EXIT R/HSDR SWAA2020062293399Lens · detachedEMERG EXIT LIGHT COVER, LENS WEAR FUEL SERVICE DOOR IS DETACHED. (CAME OFF). REMOVED & REPLACED EMERGENCY SIGN & LIGHTS AS PER AMM 33-51-01 OPS CKS GOOD.SDR IPXA2020062256757Lens · missingINSPECTION TYPE:N/A EMERGENCY EXIT LIGHT ABOVE ELT STORAGE COMPARTMENT MISSING LENS. REPLACED EMERGENCY EXIT LIGHT FLOOR MARKING LENS IN REF TO AMM 33-51-17. OPS CHECK NORMAL.SDR QXEA2020061900188Battery · inoperativeEMERGENCY LIGHTS AT THE AFT RH SERVICE DOOR ARE INOPERATIVE. REPLACED BATTERY.SDR SIMA202006198001Lamp · inoperativeMAIN DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MAIN DOOR EXTERNAL EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-06-000-801-A AND 33-50-06-400-801-A. OPS CHECK GOOD.SDR DALA2020061902486Lens · detachedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING SEAT 35D. REINSTALLED EXIT SIGN LIGHT COVER AT DOOR 3 AREA CHECK GOOD.SDR IPXA2020061956742Lens · missingINSPECTION TYPE:N/ALAV CABINET LIGHT LENS MISSING.REMOVED & REPLACED LAVATORY AUXILIARY/MIRROR LIGHT IAW 33-51-21-0401/OPS TEST GOOD.SDR AALA202006199002Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT BATTERY PACK AT SEAT ROWS 16-21 FAILED CAPACITY TEST. REPLACED BATTERY PACK AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA202006199001Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT BATTERY PACK AT SEAT ROW 8DEF FAILED CAPACITY TEST. REPLACED BATTERY PACK AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR MASA2020061810106Battery · dischargedFWD CABIN EXIT SIGN INOP. CHARGED BATTERY PACKS.SDR SWAA2020061892968Battery Pack · faultyEMERGENCY EXIT LIGHTS OUT IN UVHD BIN BULLNOSE ROW 9 ABC AND ROW 12 ABC / R&R'D M1670 BATTERY PACK POWER SUPPLY PER AMM 33-51-06. OPS CHECK GOODSDR SWAA2020061893026Light · inoperativeSUPPLEMENTAL INFORMATION: L2 EXTERIOR DOOR; R2 INTERIOR UPPER DOOR; LEFT AFT OVERHEAD BIN EMERGENCY LIGHTS INOP. / REMOVED DEAD BATTERY FROM AFT LH EMERGENCY LIGHT RACK AND INSTALLED NEW BATTERY IAW AMM 33-51-06-960-805; OPS CHECK GOOD.SDR ASAA2020062232824Battery · failedLEFT OVERWING EMERGENCY EXIT LIGHTS FAIL BATTERY TEST. GROUNDED - YES. EMERGENCY BATTERIES REMOVED/REPLACED AND TESTED (M2335 & M1670) S/N 82039 IAW AMM 33-51-06.SDR YENA2020062200374Sign · inoperativeFLT 1505, EWR-FLL. EMERGENCY EXIT SIGN INOP AT L2 DOOR (45WL). REPLACED EXIT SIGN PER AMM 33-51-16, OPS CKS GOOD.SDR SWAA2020062293138Light · damagedWHILE WORKING THE G-1 GALLEY REPLACEMENT FOUND THE FWD SERVICE DOOR EXIT LIGHT DAMAGED. REPLACED FWD SERVICE DOOR EXIT LIGHT PER AMM 33-51-01-960-802 LEAD 18 6/17/20 STEP 3;D;(5); AND (6) LIGHT REQUIES OPS CHECK LEAD. OPS CHECKED THE FWD SERVICE DOOR EXIT LISDR SWAA2020062293463Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01669. R&R EMERGENCY LIGHT BATTERY PACK PER AMM 33-51-06.SDR ASAA2020061972811Battery Pack · no testRIGHT OVERWING EMERGENCY EXIT LIGHTS FAIL BATTERY TEST. GROUNDED - YES. REMOVED & REPLACED EMERGENCY LIGHT BATTERIES M1671 & M1676. OPS CHECK GOOD.B737-800 AMM 33-51-06.SDR ASAA2020061972810Battery Pack · no testR2 DOOR INTERIOR AND EXTERIOR EMERGENCY EXIT LIGHTS FAILS BATTERY TEST. GROUNDED - YES. EMERGENCY BATTERIES REMOVED/REPLACED AND TESTED (M1672) IAW B737 AMM 33-51-06.SDR DALA2020061982490Lens · detachedEXIT SIGN ON CEILING AFT OF L2 DOOR, FOUND THE LENS DETACHED. INSTALLED THE LENS.SDR DALA2020061982484Battery Pack · dischargedR1 & R2 DOOR EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED DEAD BATTERY PACKS FOR R1, R2 RIGHT OVERWING EXITS IAW AMM 33-51. OPS CHECKED GOOD.SDR WX0A2020061973515Battery Pack · no testEPSU BATTERY FIN# 10WL FAILED EPSU BAT CAP TEST. REPLACED EPSU BATTERY.SDR DALA2020061972482Battery Pack · no testFOUND EMERGENCY LIGHTS ROW 5D-9D INOPERATIVE DURING SERVICE CHECK. REPLACED BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR DALA2020061972481Battery Pack · inoperativeFOUND EMERGENCY LIGHTS ROW 41GF-49GF INOPERATIVE DURING SERVICE CHECK. REPLACED BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR SIMA202006187003Lamp · inoperativeMAIN DOOR EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED MAIN DOOR EXTERNAL EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-06-000-801-A AND 33-50-06-400-801-A. OPS CHECK GOOD.SDR SIMA202006187004Lamp · inoperativeCOCKPIT EMERGENCY LIGHT INOP. REMOVED AND REPLACED COCKPIT CEILING EMERGENCY LAMP IAW AMM TASK 33-50-05-000-801-A AND 33-50-05-400-801-A. OPC GOOD.SDR SWAA2020061792825Battery Pack · inoperativeGROUND ILLUMINATION LIGHTS ON LEFT AND RIGHT SIDES INOP. / REMOVE/REPLACE EMERGENCY LIGHT BATTERY PACK AT BODY STA 727C +13 WL 212 LBL 68 PER AMM 33-51-06. REMOVE/ RELAMP RH GROUND ILLUMINATION EMERGENCY LIGHT PER AMM 33-51-05 OPS CHECK GOOD.SDR SWAA2020061892838Lamp · inoperativeEMERGENCY LIGHT AT L2 DOOR INOP / REMOVED AND REPLACED LAMP @ L2 DOOR IAW AMM 33-51-01-960-801 OPS CK GOODSDR UIEA2020061871304Battery · inoperativeR1 DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE R1 DOOR EMERGENCY POWER BATTERY PACK IAW AMM 33-51-07. FOUND WIRES CHAFING IN HARNESS LOCATED IN CEILING, REPAIRED IAW SWPM. OPERATIONAL CHECKED NORMAL.SDR AALA202006189001Charger · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT ROW 21ABC EMERGENCY LIGHT BATTERY CHARGER NOT CHARGING. REPLACED EMERGENCY LIGHT BATTERY CHARGER AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR SIMA20200617001Light · inoperativeRT AFT OVERWING EMERGENCY LIGHT INOP. RELAMPED RH AFT OVERWING EMERGENCY LIGHT IAW AMM 33-50-07, OPS CHK GOOD.SDR SWAA2020061792616Lamp · inoperativeFOUND AFT CARGO EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-04SDR HNAA2020061700170Inverter · inoperativeFOUND DURING GOOD NIGHT CHECK LT EMERGENCY DOOR UPPER EMERGENCY LIGHT INOPERATIVE. R & R THE INVERTER IAW AMM 33-50-11-000/400-801-A. OPS TESTED GOOD.SDR SWAA2020061892781Light · inoperativeSUPPLEMENTAL INFORMATION: R1 EXTERIOR EMERGENCY EGRESS LIGHT INOP / REPLACED R1 EXTERIOR EMERGENCY EGRASS LAMP OPS CHECK GOOD I/A/W AMM 33-51-04-960-801 ATAG D25575SDR REXA2020070600584Battery Pack · dischargedFWD MOST EXTERIOR EMERGENCY LIGHTS INOP. REMOVED AND INSTALLED THE EPSU BATTERY PACK PS1LF IAW JOB CARD 33-900-701. PERFORMED OPS CHECK. OPS CHECK GOOD. PN OFF: 2013-1A SN OFF: 103895 PN ON: 2013-1ASMI SN ON: 8724.SDR REXA2020070600583Light · inoperativeEMERGENCY LIGHT JUST AFT OG RT WING REQUIRES RE-LAMP. RE-LAMPED LIGHT JUST AFT OF RT WING IAW AMM 33-51-15. R/N OFF/ON:8GH002473-08.SDR J7SA2020070600201Battery · defectiveDURING ROUTINE MAINTENANCE, DISCOVERED EMERGENCY LIGHTS FLASHING WITH SWITCH IN ARM AND OFF POSITION. TROUBLESHOT SYSTEM. REMOVED AND REPLACED THE NR 1 EMERGENCY LIGHTS BATTERY IAW MM 33-52-01. OPS CHECK GOOD. P/N 6450LS-00 S/N 001788.SDR R61A2020061900533Battery Pack · inoperativeMIDDLE ZONE EMERGENCY LIGHTS INOP AND AFT ZONE EMERGENCY LIGHTS INOP. R&R FWD LH BATTERY EMERGENCY AND AFT LH BATTERY EMERGENCY IAW AMM 33-50-01.SDR DALA2020061982485Battery Pack · inoperativeFIRST FOUR EMERGENCY AISLE LIGHTS AFT OF THE L2 DOOR WERE INOPERATIVE. REPLACED THE BATTERY PACK M11486, TESTED GOOD IAW AMM 33-51.SDR IPXA2020061976683Control Panel · inoperativeEMERGENCY EXIT LIGHT SWITCH WILL NOT STAY IN ARMED POSITION WITH SWITCH GUARD DOWN .R&R EMRGENCY LIGHTS CONTROL PANEL IAW AMM 33-51-08-004-002 AND AMM 33-51-08-404-010.SDR DALA2020061872477Battery Pack · inoperativeDURING INSPECTION, FOUND AFT LT OVERWING AFT EXIT LIGHT WILL NOT ILLUMINATE. RPLD M1670 BATTERY PACK AND CHARGER PER B737 AMM 33-51.SDR SWAA2020061892732Light · inoperativeR-2 DOOR EXTERNAL EMERGENCY LIGHT INOP / PERFORMED OPERATIONAL TEST TO R-2 DOOR EXTERNAL EMERGENCY LIGHT REF B737 AMM 31-51-06-960-806 OP TEST FOUND NORMAL. AFTER CHARGING THE BATTERY PACKSDR SWAA2020061792547Cover · looseMID CABIN EXIT SIGN COVERS FELL OFF. REINSTALLED EXIT SIGN COVER IAW SIPSDR R61A2020061600528Power Supply · inoperativeEMERGENCY LIGHT BATTERY FAULT EICAS MESSAGE. R&R AFT INBOARD EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01.SDR AALA202006169007Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE -EMERGENCY LIGHTS AT PASSENGER SEAT ROWS 3, 4, 9, 14, 15, 18 & 19 ARE INOP. REMOVED AND REPLACED EPSU 15WL PER AMM 33-51-38, OPERATIONAL CHECK GOOD PER AMM 33-51-00. ALL SEAT EMERGENCY LIGHTS WORK.SDR J7SA2020070600200Battery · defectiveDURING ROUTINE MAINTENANCE, DISCOVERED EMERGENCY LIGHTS FLICKERING. TROUBLESHOT SYSTEM. REMOVED AND REPLACED THE NR 1 AND NR 2 EMERGENCY LIGHT BATTERY. COMPLIED WITH OPERATIONAL TEST IAW AMM 33-52-01. NO DEFECTS NOTED. NR 1 P/N 6450LS-00 S/N 002189 NR 2 PSDR AALA2020061769001Lamp · inoperativeAIRCRAFT WAS GROUNDED: RIGHT WING OVER WING EMERGENCY EXIT LITE INOPERATIVE. REPLACED FOUR LAMPS IAW AMM 33-51-01 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.
Back to JASC 3350