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 SWAA2016110109223Cover · detachedL1 DOOR EMERGENCY EXIT LIGHT COVER DETACHED. REPAIRED COVER PER SIP.SDR SWAA2016110109222Lens · looseR1 DOOR EMERGENCY EXIT LIGHT LENS LOOSE. R&R LIGHT ASSEMBLY PER SIP.SDR ASAA2016103118531Lens · missingL2 EXIT LIGHT COVER MISSING LOWER LIGHT COVER MISSING. ACFT GROUNDED. INSTALLED NEW LENS IAW AMM 33-51-01.SDR ASAA2016103118530Lens · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN ON NR 1 GALLEY ADJACENT TO R1 DOOR HAS BROKEN LENS. ACFT GROUNDED. REMOVED AND REPLACED LENS AND TESTED LIGHT ASSY IAW MM 33-51-01-960-801. OPS NORMAL.SDR REXA2016103102097Light · inoperativeFIRST EMERGENCY OVERHEAD LIGHT IN CABIN INOPERATIVE. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-16. LIGHT CHECKED GOOD. ACFT OK FOR SERVICE.SDR DALA2016110208142Battery · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY EXIT SIGN FOR THE AFT OVERWING HATCHES WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERIES IN THE POWER SUPPLY AND THE LIGHTS RETURNED TO AN OPERATIONAL CONDITION.SDR AALA20161101010Indicator · brokenAIRCRAFT WAS IN BASE MAINTENANCE. L2 DOOR FORWARD EXIT INDICATOR BASE IS BROKEN. REMOVED AND REPLACED EXIT INDICATOR ASSEMBLY AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-01.SDR AALA20161101009Indicator · brokenAIRCRAFT WAS IN BASE MAINTENANCE. L2 DOOR AFT EXIT INDICATOR BASE IS BROKEN. REMOVED AND REPLACED EXIT INDICATOR ASSEMBLY AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-01.SDR AALA20161031019Indicator · brokenAIRCRAFT WAS IN BASE MAINTENANCE. L3 DOOR FORWARD EXIT INDICATOR BASE IS BROKEN. REMOVED AND REPLACED EXIT INDICATOR ASSEMBLY AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-01.SDR AALA20161031018Indicator · crackedAIRCRAFT WAS IN BASE MAINTENANCE. R3 DOOR EXIT INDICATOR BASE IS CRACKED. REMOVED AND REPLACED INDICATOR ASSEMBLY AND ACCOMPLISHED SATISFACTORY OPERATIONAL TEST IAW AMM 33-51-01.SDR SWAA2016110109185Bulb · inoperativeRIGHT EMERGENCY LIGHT INOPERATIVE AT ROW 3. RELAMPED THE BULB IAW MM.SDR SWAA2016110109161Battery Pack · dischargedRT WING EMERGENCY EXIT LIGHT FAULTY. R&R BATTERY PACK IAW AMM.SDR JJBA20161031003Switch · dirtyEMERGENCY LIGHTS WILL NOT EXTINGUISH BY FA PANEL WHEN ARMED. CLEANED EMERGENCY LIGHT SWITCH. OPS CHECK SAT. NO DEFECTS NOTED.SDR DALA2016103108076Light · inoperativeESCAPE PATH LIGHTS INOP AT ROWS 28, 29, AND 34. REPLACE LIGHT ASSEMBLIES PER AMM 33-53. OPS CHECK GOOD.SDR CALA2016103100844Battery Pack · dischargedEMERGENCY EXIT SEAT TRACK LIGHTS INOP AT ROWS 8 THROUGH 14 AND 22 THROUGH 34 REPLACED EMER PWR BATTERY PACKS AT M1670,M2503 & M2626,REF AMM 33-51-06-960-805. OPS CK NORMAL.SDR CALA2016103100843Bulb · inoperativeRED EMERGENCY EXIT SEAT TRACK LIGHT MISSING AT 15C. REPLACED RED LENS AND BULBS AT 15C. OPS CHECKED NORMAL.SDR CALA2016103100842Bulb · inoperativeEMERGENCY LIGHT AT LOWER RIGHT OF FWD CLOSET DOOR IS BROKEN. R & R LOWER RIGHT EMERGENCY LIGHT BULB,OPS NORMAL.SDR CALA2016103100841Socket · corrodedR4 DOOR EMERGENCY SLIDE LIGHT INOPERATIVE. CLEANED CORROSION FROM LIGHT SOCKET. PERFORMED OPS TEST IAW AMM 3 3-51-00-715-003. OPS CHECKED GOOD.SDR CALA2016103100840Socket · corrodedL4 DOOR EMERGENCY SLIDE LIGHT INOPERATIVE. CLEANED CORROSION FROM LIGHT SOCKET. TESTED IAW AMM 33-51-00-715 -003. OP CHECKED GOOD.SDR CALA2016103100839Battery Pack · inoperativeEMERGENCY LIGHT AT LEFT SEATS 31 THRU 40 NOT OPERATING. REPLACED THE BATTERY PACK.SDR CALA2016103100838Lamp · inoperativeBULLNOSE EMERGENCY LIGHTS AT SEATS 32D AND 2E NOT OPERATING. REPLACED THE LAMP AND OPS CHECKED GOOD. REPLACED THE LAMP AT SEAT 2 OPS CHECKED GOOD. REPLACED THE LAMP AT SEAT 32 OPS CHECKED GOOD.SDR CALA2016103100837Bulb · inoperativeL2 EMERGENCY EXIT LIGHT IS INOPERATIVE. REMOVED AND REPLACED EMERGENCY EXIT SLIDE LIGHT BULB IAW AMM33-51-04. OPS CHECKED OK.SDR KCSA201610311092Light · inoperativeTHREE EMERGENCY LIGHTS IN UPPER DECK CEILING INOPERATIVE.SDR KCSA201610311091Light · inoperativeEMERGENCY LIGHT IN STAIRWAY GOING FROM MAIN DECK TO UPPER DECK INOPERATIVE.SDR HALA2016103100163Light · illuminatedR3 DOOR EXIT LIGHT ILLUMINATED IN FLIGHT. RESET EXIT LIGHT, OPERATIONAL CHECK OK. LP 8097266SDR HALA2016103100162Sign · illuminatedR3 DOOR EXIT LIGHT ILLUMINATED IN FLIGHT. RESET SEAT BELT ON SIGN, OPERATIONAL CHECK OK.SDR HNAA2016103100344Bulb · inoperativeSECOND FROM FRONT, FLOOR EMERGENCY EXIT LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BULB. REINSTALLED PROTECTIVE COVER. OPS CHECKED GOOD.SDR DALA2016103108228Battery · dischargedEMER LIGHT INOP L-1 OUTER. M731 BATTERY REPLACED ON NR-8. OPS CHECK GOOD OF EMERGENCY EXIT LIGHTS IAW AMM 33-51.SDR DALA2016103108227Battery · dischargedEMER LIGHT INOP R-1 LOWER. REMOVED AND REPLACED M731 POWER PACK/BATTERY IAW AMM 33-51-07. OPS CHECK GOOD OF EMERGENCY EXIT LIGHTS IAW AMM 33-51.SDR DALA2016103108226Battery · dischargedEMER LIGHT INOP L-1 UPPER. M731 BATTERY REPLACED ON NR-8. OPS CHECK GOOD OF EMERGENCY EXIT SIGNS IAW AMM 33-51.SDR SIMA20161030003Battery Pack · inoperativeEMERGENCY LIGHT NOT WORKING. R & R THE BATTERY PACK AND POWER SUPPLY IAW WC 33-700-19. OPS CHECKED GOOD IAW WC 33-700-17.SDR DALA2016110108194Lens · damagedR1 EXTERIOR EMERGENCY LIGHT LENS DAMAGED. REPLACED LENS. SYSTEM OPERATION IS NORMAL.SDR RAIA201610300002Power Supply · inoperativeSERVICE DOOR EMERGENCY EXIT SIGN IS INOPERATIVE. R & R THE EMERGENCY BATTERY POWER SUPPLY AND OPS CHECKED GOOD.SDR RAIA201610300001Power Supply · inoperativeEMERGENCY EXIT SIGN AT GALLEY WALL IS INOPERATIVE. R & R THE BATTERY POWER SUPPLY AND OPS CHECKED GOOD.SDR AALA20161102013Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT LENS OVER COCKPIT DOOR DETACHED. SECURED LENS IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161102011Light · brokenAIRCRAFT NOT GROUNDED. L2 DOOR EMERGENCY ESCAPE PATH LIGHTING EXIT MARKER BROKEN OFF AT TOP. REMOVED AND REPLACED MARKER LIGHT ASSEMBLY IAW AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA20161102003Lens · detachedAIRCRAFT NOT GROUNDED. BOTH OVERWING EMERGENCY EXIT SIGN LENS COVERS FELL OFF ON LANDING. REATTACHED BOTH EXIT SIGNS IAW AMM 25-64-00. OPERATIONAL CHECK GOOD. REF AALA20161102002.SDR AALA20161102002Lens · detachedAIRCRAFT NOT GROUNDED. BOTH OVERWING EMERGENCY EXIT SIGN LENS COVERS FELL OFF ON LANDING. REATTACHED BOTH EXIT SIGNS IAW AMM 25-64-00. OPERATIONAL CHECK GOOD. REF AALA20161102003.SDR AALA201610319027Lens · missingAIRCRAFT WAS NOT GROUNDED. MISSING RED LENS ON EMERGENCY LIGHT AT EXIT ROW 8 SEAT D. REPLACED LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161101022Lens · detachedAIRCRAFT NOT GROUNDED. L1 DOOR EMERGENCY EXIT SIGN LENS COVER DETACHED. INSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20161101012Lens · missingAIRCRAFT NOT GROUNDED. L2 DOOR EMERGENCY EXIT SIGN LENS COVER MISSING. REPLACED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161030001Battery · dischargedAIRCRAFT WAS IN BASE MAINTENANCE. CEILING MOUNTED EMERGENCY LIGHTS BETWEEN ROWS 7 AND 9 ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY ASSEMBLY AT STATION 500 AN ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-53-00.SDR DALA2016110108095Battery Pack · inoperativeCABIN EMERGENCY ROW EXIT LIGHTS AND EMERGENCY ISLE LIGHTS ILLUMINATED W/EMER EXIT LIGHT SWITCH IN AUTO. ONLY SOME LIGHTS ILLUMINATED MIDDLE OVERHEAD EXIT SIGN AND EXIT SIGNS AT 1., 1R, 2L/2R ILOLUMINTED. SOME PATHWAY LIGHTS ALSO, REPLACED EPSU 12WL W/O BATTERYSDR DALA2016110108094Battery Pack · faultedEPSU BATTERY FOR EMERGENCY LIGHT FAULTED. R & R THE LT ESPU BATTERY (11WL)SDR ASAA2016103018520Trim Panel · unsecureFA REPORTS EXIT SIGN AT MID-CABIN HAS TRIM FALLING LOOSE EXPOSING WIRING. GROUNDED, YES. SECURED MID-CABIN EXIT SIGN TRIM. A/C OK FOR CONTINUED SERVICE.SDR JJBA20161030002Light · inoperativeMAIN CABIN DOOR AND RT EMERGENCY EXIT LIGHT INOPERATIVE. OPS CHECKED GOOD.SDR DALA2016103108077Light · inoperativeEXTERIOR EMERGENCY ILLUMINATION SYSTEM. RIGHT EXTERIOR EMERGENCY LIGHT INOP. RELAMPED EXT EMERGENCY LIGHT AND ASSOCIATED HARDWARE PER AMM 33-50. OPS NORMAL, OK FOR SVC.SDR QXEA2010103100687Lamp · inoperativeTOP PORTION OF FORWARD FA EMERGENCY LIGHT SWITCH NOT ILLUMINATED. REPLACED THE LAMP IN THE SWITCH. CHECKED GOOD. RETURNED TO SERVICE.SDR DALA2016103108005Lens · missingDURING INSPECTION FOUND EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. MAINTENANCE SECURED COVER.SDR AALA201610319026Lens · brokenR4 DOOR EXIT LIGHT COVER OFF. REPLACED THE BROKEN LIGHT LENS AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.
Back to JASC 3350