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 29GA2017092000001Power Supply · failedFLIGHT 0073, CABIN EMERGENCY LIGHT STAY ON HALF OF THE CABIN WITH EMERGENCY LIGHT SWITCH OFF POSITION. R&R EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-50-10-04-1, OPS CHECK GOOD IAW AMM 33-50-00.SDR MASA2017091912645Light · inoperativeROW 21 CEILING EMERGENCY FLOOD LIGHT INOP. PLACED ON MEL.SDR MASA2017091912642Battery Pack · inoperativeROW 18 RT LOWER EMERGENCY EXIT SIGN INOPERATIVE. REPLACED THE BATTERY PACK.SDR MASA2017091912641Battery Pack · inoperativeAFT CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE BATTERY PACK.SDR MASA2017091912640Battery Pack · inoperativeROW 22 CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20170919014Charger · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY ESCAPE PATH LIGHTS IN THE MID CABIN ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY (AALA20170919013) AND CHARGER ASSEMBLY. OPERATIONAL CHECK GOOD.SDR AALA20170919013Battery · dischargedAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY ESCAPE PATH LIGHTS IN THE MID CABIN ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY AND CHARGER ASSEMBLY (AALA20170919014). OPERATIONAL CHECK GOOD.SDR AALA201709209030Light · brokenAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT SIGN IN THE RIGHT AFT GALLEY AT L1191 HAS A BROKEN BASE PLATE. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201709209025Lens · missingEMERGENCY EXIT CEILING LIGHT BY SEAT 26DE HAS A MISSING LENS. INSTALLED THE LENS IAW AMM 33-51-03. OPS CHECKED GOOD.SDR AALA201709209023Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE RIGHT OVERWING EXIT BY ROW 15 HAS A MISSING LENS COVER. INSTALLED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201709199014Lens · damagedAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT FLOOR PROXIMITY LIGHT AT GALLEY 3 LEFT SIDEWALL HAS A DAMAGED LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY. OPERATIONAL CHECK GOOD.SDR AALA20170918003Plate · brokenAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT SIGN IN THE LEFT AFT GALLEY AT L1190 HAS A BROKEN BASE PLATE. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2017092116503Lens · damagedR1 DOOR LOWER EMERGENCY EXIT LIGHT LENS DAMAGED. R&R LENS PER SIP.SDR SWAA2017092116496Lens · unsecureL1 DOOR EMERGENCY EXIT SIGN LENS FELL OFF. SECURED LENS PER SIP.SDR SCNA20170918194Battery Pack · dischargedFWD RT EMERGENCY LIGHT BATTERY PACK DEAD. REMOVED & RESTORED RT FWD EMERGENCY LIGHT POWER SUPPLY AND BATTERY PACK. OPS CHECK GOOD.SDR HNAA2017092000321Light · inoperativeLEFT SIDE EMERGENCY EXIT DOOR UPPER LIGHT NOT ILLUMINATING. R&R EMERGENCY LIGHT AT LT EXIT DOOR IAW AMM TASK 33 50-14-000/400-801-A. P/N OFF 7444-9.SDR HNAA2017092000320Inverter · inoperativeROW 3B EMERGENCY EXIT LIGHT NOT ILLUMINATING. R&R EMERGENCY LIGHT DC/AC INVERTER IAW AMM TASK 33-50-11-000/400-801-A. P/N OFF INVERTER 7824-1SDR R61A201709180715Battery · dischargedEMERGENCY LIGHT IN CEILING OVER ROW 13 DOES NOT COME ON. R&R EMERGENCY LIGHT POWER SUPPLY/EMERGENCY BATTERY NR 4 IAW AMM 33-50-01. OPS CHECK GOOD.SDR SWAA2017092016492Battery Pack · dischargedEMERGENCY LIGHTS BATTERY PACK M1670 INOP. R&R BATTERY PACK IAW MM.SDR SWAA2017092016481Battery Pack · dischargedL2 EMERGENCY EXIT LIGHT INOP AT LOCATION M1673. R&R BATTERY PACK PER AMM.SDR SWAA2017092016480Light · disconnectedL2 DOOR EMERGENCY EVAC SLIDE LIGHT ON FUSELAGE INOP. RECONNECTED LIGHT ASSEMBLY IAW AMM.SDR SWAA2017092016470Light · inoperativeL2 DOOR EXTERIOR SLIDE LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017092016464Sign · looseRT FORWARD OVERWING EXIT SIGN LOOSE. R&R SIGN PER AMM.SDR ASAA2017091821971Sign · brokenEMERGENCY EXIT SIGN AT THE R2 DOOR IS BROKEN. ACFT GROUNDED. REMOVED, REPLACED, AND TESTED THE SIGN ASSEMBLY IAW AMM 33-51-01-960-802. OPS NORMAL.SDR JJBA20170919027Battery Pack · inoperativeLOWER EMERGENCY EXIT AT ROWS 2CD, 18AB, AND 18CD WILL NOT ILLUMINATE. R & R THE BATTERY PACK, OPS CHECKED GOOD IAW AMM 33-51-00, NO DEFECTS NOTED.SDR F3LA2017091900225Power Supply · no testFORWARD POWER SUPPLY FAILED TO TEST AT 10WL. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-38, PB401. OPS CHECKED GOOD.SDR SIMA20170918002Bulb · inoperativeDURING A PS-1 INSPECTION, FOUND THE RT AFT EMERGENCY LIGHT ON FUSELAGE INOPERATIVE. R & R THE BULB IAW AMM 33-51-15. OPS CHECKED GOOD. NO FURTHER DEFECTS NOTED.SDR DALA2017091806960Lens · detachedEMERGENCY EXIT SIGN IS MISSING THE LENS. FOUND EXIT SIGN LENS, INSPECTED THE LENS, NO DAMAGE NOTED AND INSTALLED.SDR CALA2017091803251Power Supply · no testEMERGENCY LIGHT TEST FAILED, FWD LT, DURING 2 SVC. REPLACED THE EPSU IAW MM 33-51-38, OPS CHECKED NORMAL.SDR CALA2017091803249Cover · missingEMERGENCY LIGHT COVER MISSING AT ROW 20DEF. INSTALLED THE EMERGENCY LIGHT COVER/ OPS CHECKED OKSDR CALA2017091803248Power Supply · failedAFT, LEFT CABIN EMERGENCY LIGHT EPSU FAILED. REPLACED THE EPSU IAW 33-51-38SDR CALA2017091803246Lamp · inoperativeTHE LEFT OVERWING EXTERIOR EMERGENCY LIGHT FOUND INOPERATIVE. REPLACED THE LAMPS AND CLEANED CONTACTS, OPS CHECKED GOOD IAW AMM 33-51-06-962-054-001.SDR CALA2017091803245Lamp · inoperativeEXTERIOR EMERGENCY LIGHTS AT THE L2 AND R2 DOORS INOPERATIVE REPLACED THE LAMPS, CLEANED CONTACTS AND SECURED LAMPS. OPS CHECKED GOOD IAW AMM 33-51-06-962-001-001.SDR CALA2017091803244Cover · missingEMERGENCY LIGHT COVER MISSNG IN FIRST CLASS ABOVE FLOOR, LEFT SIDE. REPLACED THE COVER.SDR CALA2017091803243Battery Pack · inoperativeLAST FIVE ROWS OF EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACK AND CHARGER M1673. OPS CHECKED GOOD.SDR CALA2017091803242Battery Pack · inoperativeEMERGENCY EXIT LIGHT AT THE LT WING EMERGENCY EXIT FORWARD AND AFT DOOR AND ROW 20 & 21 ABC DO NOT COME ON. R & R THE BATTERY PACK AT M1694, OPS TESTED GOOD IAW AMM 33-51-06- 960-805.SDR CALA2017091803240Lens · looseEMERGENCY EXIT LIGHT COVER WILL NOT STAY ON. SECURED THE EMERG LIGHT LENS.SDR CALA2017091803239Lamp · inoperativeEMERGENCY EXIT LIGHTS INOPERATIVE AT BOTH LEFT OVERWING EXIT ROWS AND AFT RIGHT EXIT ROW. REPLACED THE BULBS IAW AMM 33-51-01-960-802. OPS TESTED IAW 33-51-00-710-801. CHECKED GOOD.SDR CALA2017091803238Battery Pack · no testEMERGENCY LIGHTS AND SIGNS DID NOT STAY ON FOR MINIMUM OF 15 MINUTES AT LOCATIONS M1670, M1694, AND M1695. R & R THE BATTERY PACKS IAW MM 33-51-06. OPS CHECKED NORMAL.SDR CALA2017091803235Lamp · inoperativeEMERGENCY LIGHT ON THE LT WING AFT OF WING WILL NOT ILLUMINATE WHEN EMERGENCY LIGHT SWITCH IS TURNED ON. REPLACED THE LAMPS IAW AMM 33-51-04-960-801.SDR CALA2017091803232Power Supply · inoperativeEMERGENCY LIGHTS AT SEAT 3 AND 4 FOUND TO BE INOPERATIVE. REPLACED THE POWER SUPPLY M731 AND BATTERY PACK. LIGHTS CHECKED GOOD.SDR CALA2017091803230Battery · no testRIGHT UPPER DECK DOOR INNER EMERGENCY LIGHTS WILL NOT ILLUMINATE DURING EMERGENCY EXIT LIGHT TEST. REPLACED THE BATTERY IAW 33-51-04-902. SYS CHECKED GOOD.SDR CALA2017091803236Lamp · inoperativeEXTERIOR EMERGENCY LIGHT INOPERATIVE BETWEEN LT ESCAPE HATCHES. REPLACED THE LAMP. OPS CK GOOD.SDR CALA2017091803233Light · looseR1 DOOR SLIDE LIGHT INTERMITTENTLY BLINKING IN FLIGHT. SECURED THE LIGHT ASSY .SDR CALA2017091803231Lamp · inoperativeR4 DOOR SLIDE LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-51-04.SDR CALA2017091803223Light · damagedEMERGENCY LIGHTS DAMAGED 25D EMERGENCY EXIT LIGHT BULBS MISSING 6 SEATS. REMOVED AND REPLACED DAMAGED FLOOR PROXIMITY LIGHT AT SEAT REMOVED AND REPLACED NEW LIGHT ASSY @ ROW 25D,25F,32F,36F. ALL OPS CKD NORMAL.OK TO CONTINUE.REF TO AMM 33-51-06.SDR CALA2017091803219Power Supply · inoperativeEPSU 13WL INOPERATIVE. REMOVED AND REPLACED THE EPSU IAW 33-51-38-000-001-A, AND 33-51-38-400-001-A. OPS CHECKED GOOD IAW AMM 33-51-38-400-001-A STEP 4.D.SDR CALA2017091803226Control Unit · faultyEMERGENCY LIGHT INPOERATIVE AT SEAT 16D. REPLACED THE CONTROL UNIT+, SYSTEM OPS CHECKED NORMAL.SDR MASA2017091812638Light · inoperativeROW 11 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2017091812637Battery Pack · dischargedROW 12 AND 13 FLOOR LEVEL EXIT SIGNS INOPERATIVE. CHARGED BATTERIES
Back to JASC 3350