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 AALA202108162880Lens · detachedAIRCRAFT WAS NOT GROUNDED: LENS FELL OFF OF EXIT IDENTIFIER AT GALLEY COMPARTMENT 571. REPLACED LIGHT PER AMM 33-51-01.SDR AALA202108165931Housing · looseAIRCRAFT WAS GROUNDED: ON PREFLIGHT, FLIGHT ATTENDANT FOUND FLOOR LIGHT AT 16C HANGING LOOSE. REPLACED HOUSING PER CMM 25-23-67.SDR AALA202108165562Light · detachedAIRCRAFT WAS NOT GROUNDED: ROW 33ABC EXIT ROW EMERGENCY LIGHT IS DETACHED. SECURED LIGHT PER AMM 33-31-11.SDR REXA2021081600633Lamp · inoperativeFOUND AFT RH EMERGENCY LIGHT INOP. R/R AFT RH EMERGENCY LIGHT IAW AMM 33-51-15. OPS CHECKS GOOD. P/N OFF/ON: 8GH002473-08SDR IPXA2021081472733Lamp · inoperativeINSPECTION TYPE:N/AEMERGENCY LIGHT FWD OF EMERGENCY ESCAP DESCENT DEVICES INOPRELAMPED LIGHT IAW AMM 33 51 11 002 001 OP CHECK GOODSDR IPXA2021081472728Battery · inoperativeINSPECTION TYPE:N/A"LEVEL 1 EMER LT BAT 1 LO" LEVEL 1 ALERT WHEN EMER LT TEST PERFORMED. INTERMITTENTLY.R/R EMERGENCY LIGHTING BATTERY POWER SUPPLY IAW AMM 33-51-01-400-802/000-802. NO HELP. R/R MSC IAW AMM 31-42-01-000-802/400-802. OPS TEST OF MSC TEST OK IAWSDR SIMA202108154001Lamp · inoperativeGALLEY EMERGENCY LIGHT INOP. R & R GALLEY EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-09-000-801-A AND 33-50-09-400-801-A. OPC GOOD. END.SDR SWAA2021081907429Battery Pack · inoperativeALL EMERGENCY LIGHTS POWERED BY EMERGENCY BATTERY PACK M1673 ARE INOP ; / [01] C/W IAW AMM 33-51-06-960-805 TEST GOOD<BR>ATAG BF3688; [02] VERIFIED ITEM 1<BR>FINAL AUDIT C/WSDR SWAA2021081807061Bulb · burned outFWD SERVICE DOOR EMERGENCY EXIT SIGN L1186 HAS BURNT OUT BULBS ; / [01] RELAMPED FWD SERVICE DOOR EMERGENCY EXIT SIGN L1186 AND PERFORMED A GOOD FUNCTIONAL TEST PER AMM 33-51-01-960-801; [02] VERIFIED CORRECTIVE ACTION 1 PER AMM 33-51-01-960-801SDR SWAA2021081807062Bulb · burned outL/H OVERWING EMERGENCY EXIT SIGN L1365 HAS BURNT OUT BULBS ; / [01] RELAMPED L/H OVERWING EMERGENCY EXIT SIGN L1365 AND PERFORMED A GOOD FUNCTIONAL TEST PER AMM 33-51-01-960-801; [02] VERIFIED CORRECTIVE ACTION 1 PER AMM 33-51-01-960-801SDR SWAA2021081807063Bulb · burned outR/H OVERWING EMERGENCY EXIT SIGN L751 HAS BURNT OUT BULBS. RELAMPED R/H OVERWING EMERGENCY EXIT SIGN L751 AND PERFORMED A GOOD FUNCTIONAL TEST PER AMM 33-51-01-960-801; [02] VERIFIED CORRECTIVE ACTION 1 PER AMM 33-51-01-960-801SDR AALA202108174207Switch · inoperativeAIRCRAFT WAS GROUNDED: CABIN EMERGENCY LIGHTS REMAIN ILLUMINATED WHEN EMERGENCY EXIT LIGHT SWITCH IS IN THE ARM POSITION. REMOVED AND REPLACED EMERGENCY LIGHT SWITCH (4WL) PER ESPM 20-45-21.SDR AALA202108174770Light · misinstalledAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY LIGHTS AT SEAT 17ABC MISCONFIGURED. CORRECTED MISCONFIGURATION AT 17ABC SEAT EMERGENCY LIGHTS PER AMM 33-51-00.SDR AALA202108176047Light · brokenAIRCRAFT WAS NOT GROUNDED: 26C EMERGENCY SEAT LIGHT BROKEN. REMOVED AND REPLACED 26C EMERGENCY SEAT LIGHT PER AMM 33-51-11-960-802.SDR AALA202108178816Light · faultedAIRCRAFT WAS NOT GROUNDED: ROW 12 RIGHT OVERHEAD EMERGENCY LIGHT IS INOPERATIVE. ACCOMPLISHED OPERATIONS TEST OF THE EMERGENCY LIGHT ABOVE SEAT 12H PER AMM 33-51-03. LIGHT CHECKS NORMAL.SDR AALA202108170730Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT RIGHT HAND SERVICE DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELAMPED AFT RIGHT HAND DOOR EMERGENCY LIGHT PER AMM 33-51-04.SDR AALA202108171100Lens · missingAIRCRAFT WAS NOT GROUNDED: LEFT AFT OVERWING EMERGENCY LIGHT LENS COVER MISSING. INSTALLED EMERGENCY LIGHT LENS COVER ON LEFT AFT OVERWING EMERGENCY LIGHT PER AMM 33-51-01.SDR AALA202108177425Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT EXTERNAL FUSELAGE AFT EMERGENCY LIGHT INOPERATIVE. RE-LAMPED LEFT EXTERNAL FUSELAGE AFT EMERGENCY LIGHT PER AMM 33-51-04.SDR AALA202108177027Light · inoperativeAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT ASSEMBLY AT ROW 16C NEEDS TO BE REATTATCHED TO SEAT FRAME. RE-ATTACHED EMERGENCY EXIT LIGHT TO SEAT 16C BY RE-SECURING THE SCREWS.SDR DALA2021081704750Sign · unsecureSHIP 662 EMERGENCY EXIT SIGN OVER 2L DOOR IS LOOSE. CORRECTIVE ACTION: SECURED EMERGENCY LIGHT LENS AS REQ REF B 757 AMM 33-51. CKS GOOD. (7755938)SDR DALA2021081704749Power Supply · inoperativeSHIP 6820 ROW 22-26 EMERGENCY PATHWAY LIGHTS WILL NOT GO OUT. CORRECTIVE ACTION: REMOVED AND REPLACED EMERGENCY POWER SUPPLY. PER B757 AMM 33-51. OPS NORMAL. (7628716)SDR SWAA2021081707181Fuse · inoperativeAFT ENTRY ESCAPE SLIDE EMERGENCY LIGHT INOP ; / [01] R+R AFT ENTRY LEFT ESCAPE SLIDE EMERGENCY LIGHT FUSE AT POWER SUPPLY OPS OKAY PER AMM 33-51-06SDR ASAA2021081335714Battery Pack · inoperativeA/C LEFT, LAST TWO EMERGENCY EXIT AISLE LIGHT INOP. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK (M1898) REF B737-900 AMM 33-51-06-960-806. 4 C/B'S OPENED, TAGGED, AND RESET. ALL EMERGENCY LIGHTS OPS TEST PASS.SDR AALA202108163864Lens · brokenAIRCRAFT WAS GROUNDED: 18C ESCAPE PATH LENS COVER BROKEN. REMOVED AND REPLACED ESCAPE PATH LENS COVER IN SEAT 18C PER AMM 33-20-00.SDR AALA202108167507Light · unsecureAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT ROW 22 LAYING ON FLOOR. RESECURED ESCAPE PATH LIGHT ROW 22 PER AMM 33-50-00.SDR DALA2021081604692Light · damagedSHIP 3276 EMERGENCY FLOOR LIGHTING DAMAGED AT SEAT 28D. CORRECTIVE ACTION: REMOVED AND REPLACED EMERGANCY LIGHT SHROUD AT 28D PER B/E AEROSPACE CMM 25-23-51. OPS CHECK GOOD. (1910358)SDR DXTA2021081646890Battery · defectiveCABIN EMERG LIGHT: IN FLIGHT EMER LT NOT ARM YELLOW CAS MESSAGE CAME ON INTERMITTANTLY. EMERGENCY LIGHTING CAME AND STAYED ON WITH THE SWITCH IN ARM. // SIGNOFF // CW FIM (4885) » 33 LIGHTS» FIM-4885 - 33-50-00-810-801-A. EMERGENCY LIGHTS INADVERTENTLY OPERATSDR DALA2021081604687Power Supply · inoperativeTHE L&R AFT OVERWING EXIT UPPER LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY B5-230 AND BATTERY PER B717 AMM 33-51. TESTS GOOD. (LP #7807523)SDR MASA2021081300189Light · missingFORWARD EMERGENCY PATH LIGHT STRIP MISSING.SDR DALA2021081304665Power Supply · inoperativeROW 19CDE LOWER EMERGENCY SIGN IS INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT BATTERY POWER SUPPLY PER B717 AMM 33-51. OPERATIONAL CHECK WAS GOOD, OK FOR SERVICE. (LP #8004127)SDR ASAA2021081235704Lens · detachedFA REPORTS L1 DOOR EMERGENCY LIGHT COVER DISENGAGED. GROUNDED - YES. INSTALLED AND SECURED L1 DOOR THRESHOLD LIGHT COVER IAW B737-800 AMM 33-29-00.SDR DALA2021081604732Power Supply · inoperativeSHIP 193 EXTERIOR EMERGENCY LIGHTING SYSTEM IS INOPERATIVE. CORRECTIVE ACTION: REPLACED POWER SUPPLY AND BATTERY PACK. SYSTEM OPERATION IS NORMAL. (LP 6383207)SDR DALA2021081604723Battery Pack · not reportedSHIP 6822 EMERGENCY LIGHTS INOP ROW 32 TO 35. CORRECTIVE ACTION: REPLACED BATTERY M11081 PER B757 AMM 33-51-07. CHKS OK.SDR SWAA2021081606231Sign · out of positionEXIT SIGN ON LOWER LEFT SIDE OF THE FWD SVC DOOR DEEPS FALLING OFF ; / [01] INSTALLED NEW EMER. EXIT SIGN ASSY. PER AMM 33-51-01 OPS CKS GOODSDR SWAA2021081606561Sign · brokenEXIT SIGN IN MIDDLE OF CABIN BROKEN. / FOUND SIGN NOT BROKEN JUST FELL OFF REINSTALLED PER SIPSDR DALA2021081404683Battery Pack · inoperative(LOG 7461874) DURING INSPECTION FOUND EMERGENCY LIGHTS @ L2 DOOR WILL NOT ILLUMINATE. REPLACED BATTERY PACK PER. B737 AMM 33-51. OPS CHECK GOOD.SDR YENA2021081300511Battery · faultedFLT 1134, SJU-MCO. FWD EMERGENCY LT BATTERY FAULTING. R & R THE FWD EMERGENCY LT BATTERY PER AMM 33-51-38, OPS CHK GOOD.SDR AALA202108139273Power Supply · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT FAILED TEST. REPLACED POWER SUPPLY PER AMM 33-51-38.SDR SIMA202108132001Bulb · inoperativeRH OVERWING EMERGENCY LIGHT INOP.-C/A-RAR RH OVERWING EMERGENCY LIGHT BULB IAW AMM 33-50-10. OPC GOOD.SDR MASA2021081200187Bulb · inoperativeEMERGENCY CEILING LIGHT ROW 20 INOP. REPLACED BULB.SDR MASA2021081200186Bulb · inoperativeFLOOR LEVEL EXIT SIGN AT 14D/F LIGHT INOP. REPLACED BULB.SDR SWAA2021082005907Lamp · inoperativeLH EXTERIOR FUSELAGE OVER WING EMERGENCY LIGHT INOP. / [01] RELAMPED LH SLIDE OVER WING EMERGENCY LIGHT PER ACMM 33-51-04-960-801 UP TO STEP 2.F.(1).(C).2). PENDING LENS INSTALLATION/TEST.; [02] VERIFIED STEP 1; [03] INSTALLED LENS WITH NEW SCREWS AND TESTED LSDR DALA2021081604726Lens · looseSHIP 5803 EMERGENCY EXIT SIGN COVER LOOSE. CORRECTIVE ACTION: SECURED LOC 605 EMERGENCY EXIT SIGN COVER. (1907537)SDR SWAA2021081606230Sign · missingEXIT SIGN ON LOWER LEFT SIDE OF FWD SERVICE DOOR FELL OFF ; / [01] RESECURED EMERGENGY EXIT SIGN N LOWER RIGHT SIDE (LEFT SIDE OF FWD SERVICE DOOR) OPS CHECKS GOOD PER AMM 33-51-00SDR JJBA202108131030Light · missingEMERGENCY FLOOR STRIP AT 1A MISSING. INSTALLED EMERGENCY FLOOR STRIP.SDR JJBA20210811029Battery Pack · inoperativeFOUND EMERGENCY LIGHTS AT EMERGENCY EXIT ROWS INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERY #3. OPS CHECK SAT. NO FURTHER DEFECTS NOTED.SDR AALA202108131098Cover · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT DETACHED AT SEAT 10C. REINSTALLED LIGHT COVER PER AMM 33-51-11.SDR AALA202108122638Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: CENTER AISLE FORWARD CEILING EXIT LIGHT NUMEROUS BULBS INOPERATIVE. REPLACED BULBS PER AMM 33-51-00.SDR AALA202108129882Bulb · burned outAIRCRAFT WAS NOT GROUNDED: 2R DOOR EXIT LIGHT NUMEROUS BULBS BURNED OUT. REPLACED BULBS PER AMM 33-51-00.SDR AALA202108123011Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT OVER WING EMERGENCY EXIT LIGHT, BULBS INOPERATIVE. REPLACED BULBS PER AMMM 33-51-00.
Back to JASC 3350