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 SWAA2016101008567Lens · missingFORWARD LOWERED CEILING HORSESHOE PANEL CENTER EMERGENCY LIGHT LENS MISSING. INSTALLED THE LENS IAW AMM.SDR QXEA2016100600644Lamp · inoperativeEMERGENCY LIGHTING SWITCH NORMAL POSITION LIGHT INOPERATIVE. REPLACED THE LAMP. CHECKED GOOD. RETURNED TO SERVICE.SDR AALA201610049006Cover · missingEXIT SIGN COVER MISSING AFT EXIT AT R2 DOOR. INSTALLED NEW EXIT COVER AT R2 DOOR.SDR AALA201610049004Lens · missingOVERWING EXIT LIGHT LENS COVER MISSING ON LEFT SIDE OF AIRCRAFT. INSTALLED EXIT LIGHT LENS COVER IAW CMM 25-40-07.SDR AALA201610049003Cover · detachedEXIT COVER SIGN CAME OFF AT 3L. REPLACED EXIT LIGHT COVER PER AMM 33-51-16SDR AALA201610049002Power Supply · inoperativeEMERCENCY EXIT LIGHT AT 45WL AND 33WL INOPERATIVE. REPLACED EMERGENCY POWER SUPPLY UNIT 13WL IAW AMM 33-51-38.SDR AALA201610049001Cover · brokenEXIT SIGN DOOR 1R COVER BROKEN. REPLACE EXIT SIGN COVER. AIRCRAFT NOT GROUNDED.SDR SWAA2016100508456Sign · detachedAFT ENTRY EXIT SIGN COVER DETACHED. R & R THE SIGN ASSEMBLY IAW MM.SDR SWAA2016100508454Lens · brokenR2 DOOR EXIT LIGHT LENS TRIM BROKEN. R & R THE LENS IAW AMM.SDR AALA201610049007Connector · disconnectedEMERGENCY LIGHT AT SEAT 1A INOPERATIVE. REPLACED LIGHT ASSEMBLY AND CONNECTED THE CONNECTOR AT BULKHEAD. A SATISFACTORY OPERATIONAL CEHCK WAS ACCOMPLISHED.SDR IPXA2016100308916Lamp · inoperativeRT EMERGENCY LIGHT ABOVE COURIER SEAT OUT. REPLACED THE LAMP, OPS CHECKED GOOD IAW AMM 33-50-00.SDR MASA2016100312436Light · inoperativeEMERGENCY EXIT CELING LIGHT AT ROW 4 INOPERATIVE.SDR MASA2016100312434Sign · inoperativeAFT CEILING EMERGENCY EXIT LIGHT INOPERATIVE. OP CHECKED NORMALSDR HNAA2016100300305Battery · inoperativeFORWARD EMERGENCY EXIT LIGHT, CEILING LIGHT AND CENTER CABIN EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY BASE.OPS CHECKED GOOD.SDR HNAA2016100300304Light · inoperativeFIRST EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR HNAA2016100300303Bulb · inoperativeEXIT LIGHT IS DIM AT ROW 11AC..... REMOVED AND REPLACED BULB. OPS CHECKED GOOD.SDR CALA2016100300718Light · inoperativeEMERG LTS UNARMED LIGHT NOT ILLUMINATING LEFT BRIGHT BULB. DIM BULB WORKS. REPLACED LIGHT OPS CHECK NORMAL.SDR A6WA201644394Light · inoperativeEMERG FLOOR TRACK LIGHTS INOP ROW 2-8.SDR DALA2016100307105Charger · inoperativeINSEAT EMERGENCY EXIT LIGHTING AT ROWS 41 - 45 INOPERATIVE. REPLACED THE CHARGER. OPS CHECKED GOOD.SDR AALA201610039013Light · brokenSEAT MOUNTED EMERGENCY LIGHT AT SEAT ROW 21 LEFT BROKEN OFF. REPLACED EMERGENCY LIGHT ASSEMBLY AT SEAT ROW 21ABC AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201610039010Power Supply · failedWHILE ACCOMPLISHING EMERGENCY LIGHT TEST, LEFT OVERWING LIGHT FAILED. REPLACED LEFT OVERWING EMERGENCY POWER SUPPLY IAW AMM 33-51-38-0401.SDR AALA201610039009Lens · looseEMERGENCY LIGHT AT BOTTOM OF VALET CLOSET LOOSE. ATTACHED EMERGENCY LIGHT AND ACCOMPLISHED SATIFACTORY OPERATIIONAL CHECK. AIRCRAFT WAS GROUNDED.SDR U2RA201610020001Battery Pack · dischargedUPPER DECK, AISLE, STAIRWAY, AND COCKPIT EMERGENCY LIGHTS DO NOT OPERATE DURING TEST. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-04. OPS TEST SATISFACTORY.SDR DALA2016100307050Fuse · failedDURING INSPECTION, FOUND NUMEROUS EMERGENCY LIGHTS INOPERATIVE IN THE AFT CABIN. MAINTENANCE FOUND THREE FUSES IN THE POWER SUPPLY M1672 BLOWN. REPLACED THE FUSES. CHECKED GOOD.SDR ASAA2016100218189Lens · wrong partEMERGENCY LIGHT AREA LIGHT ON AFT WINDSCREEN ADJACENT TO LAVATORY D HAS WRONG LENS INSTALLED. GROUNDED - YES. INSTALLED LENS WAS MPN 207377-1007 (EXIT NOMENCLATURE, NO ARROWS). PER B737-900 WDM 33-51-22-6 AND IPC 33-26-03-55A THE CORRECT LENS FOR THE LAV D ARESDR N6WA2016100202Light · missingEMERGENCY LIGHT MISSING AT ROW 7 LEFT SIDE AND ROW 9 RIGHT SIDE.SDR N6WA2016100201Light · missingEMERGENCY LIGHT MISSING IN GALLEY.SDR UIEA2016100300794Bulb · inoperativeEXT EMERGENCY GROUND FLOOD LIGHT INOPERATIVE AFT OF RT WING. REPLACED THE BULB & OPS CHECKED GOOD IAW AMM 33-51-16.SDR SWAA2016100308402Light · inoperativeEMERGENCY LIGHT INOPERATIVE BETWEEN ROWS 1 TO 2. CLEANED STRIP PER AMM.SDR AALA20161003002Power Supply · inoperativeEMERGENCY EXIT SIGN AT L3 DOOR IS INOPERATAIVE. REMOVED ANAD REPLACED EMERGENCY LIGHT POWER SUPPLY M33405 IAW AMM 33-51-06. SYSTEM TESTS GOOD.SDR MASA2016100212432Light · inoperativeCEILING EMER LIGHTS INOP AT ROW 1 & 3. PLACED ON MEL.SDR SWAA2016102609098Light · inoperativeLT WING OVERWING EXIT EMERGENCY LIGHT INOP. R&R LIGHT PER AMM.SDR AALA201610029011Power Supply · inoperativeLAST ROW LEFT HAND SEAT EMERGENCY LIGHT INOPERABLE AFTER RE-INSTALL. REPLACED EMERGENCY POWER SUPPLY UNIT AT 13WL PER A321 AMM 33-51-38.SDR AALA201610029008Sign · detachedEMERGENCY EXIT SIGN FELL OFF AT 3L DOOR. INSTALLED EMERGENCY EXIT SIGN AT THE 3L DOOR.SDR SCNA20161001231Light · inoperativeAFT EMERGENCY LIGHT IN HORSESHOE PANEL INOPERATIVE. REMOVED AND REPLACED AFT AISLE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR AALA20161003012Lens · missingSEAT 39G CEILING EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS IAW AMM 33-51-03.SDR DALA2016100307028Charger · inoperativeEMERGENCY LIGHT INOPERATIVE AT 26F. T/S FOUND BATT. CHARGER TO BE THE PROBLEM. R&R CHARGER LOCATED JUST AFT OF LIGHT. OPS CHECKS NORMAL. (8721674)SDR REXA2016100101838Light · inoperativeAFT CEILING EMERGENCY FLOODLIGHT INOP. REPLACED AFT CEILING EMERGENCY FLOODLIGHT LAMP P/N 1317 PER AMM 33-51-16, OPS CHECK GOOD PER AMM 33-51-00.SDR SWAA2016100308415Fuse · inoperativeAFT EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE FUSE IAW AMM.SDR SWAA2016100308412Battery Pack · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2016100308411Light · inoperativeL/H EMERGENCY EXIT LIGHT INOPERATIVE. REPAIRED LIGHT IAW AMM.SDR SWAA2016100308401Lens · missingLEFT EMERGENCY EXIT LIGHT LENS MISSING AT ROW 8. INSTALLED LENS IAW MM.SDR SWAA2016100308370Sign · brokenL1 DOOR EMERGENCY EXIT LIGHT SIGN ASSEMBLY BROKEN. R&R SIGN ASSEMBLY PER AMM.SDR SWAA2016100308355Battery Pack · dischargedLT AFT ENTRY DOOR CEILING EMERGENCY LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2016100308337Sign · looseMID CABIN CEILING EMERGENCY EXIT SIGN LOOSE. R&R LIGHT ASSEMBLY PER MM.SDR DALA2016100307009Fuse · blownAFT SECTION EMERG LIGHTS INOP. REPLACED FUSE IN BATTERY PACK. OPS CK GOOD. REF WDM 33-51.SDR ASAA2016100118159Lens · detachedEXIT SIGN COVER FELL OFF R2 DOOR BY TRASH CAN. GROUNDED - YES. INSTALLED EXIT SIGN COVER AT R2 DOOR AFT AREA BY TRASH CAN REF B737-900 MM 20-50-11.SDR AALA20161003009Lens · looseR4 DOOR SLIDE LIGHT LENS IS NOT SECURE. RESECURED LENS IAW AMM 33-51-04.SDR AALA20161003008Lens · looseR3 DOOR SLIDE LIGHT LENS IS NOT SECURE. RESECURED LENS IAW AMM 33-51-04.SDR AALA20161003007Lens · looseR2 DOOR SLIDE LIGHT LENS IS NOT SECURE. RESECURED LENS IAW AMM 33-51-04.
Back to JASC 3350