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 SWAA2018071123431Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY TEST AT M01675. R&R BATTERY PACK PER AMM.SDR SWAA2018071123383Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY TEST AT M01672. R&R BATTERY PACK PER AMM.SDR SWAA2018071023342Cover · unsecureEMERGENCY EXIT SIGN COVER FELL OFF. SECURED COVER IAW AMM.SDR SWAA2018071023340Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER DWG AND AMM.SDR AALA201807059025Light · damagedTHE AIRCRAFT WAS GROUNDED. OPERATIONS REPORTED FLOOR PROXIMITY EMERGENCY LIGHT AT SEAT ROW 17ACB IS DAMAGED. REPLACED EMERGENCY LIGHT HOUSING AT SEAT 17. LIGHT OPERATIONS NORMAL PER AMM 33-51-00.SDR SIMA20180704003Light · inoperativeCEILING EMERGENCY LT AT ROW 17 INOP. R&R AISLE EMERGENCY LIGHT LAMP AT ROW 17 IAW AMM TASK 33-50-08-000-801-A AND 33-50-08-400-801-A, OPS CHECK GOOD AT THIS TIME.SDR DALA2018070504365Power Supply · inoperativeAFT OVERWING EMERGENCY EXIT LIGHTS INOP. R & R POWER SUPPLY EMERGENCY EXIT OVERWING PER WDM 33-51-12. OPS CK GOOD.SDR DALA2018070504364Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACKS B5-104 ANDB5-105 BAD. R&R BATTERY PACKS B5-104 AND B5-105 PER WD 33-51-12. CKS NORMAL.SDR U2RA201807040002Battery Pack · dischargedEMERGENCY EXIT LIGHTS DOOR 2 LEFT AND 2 RIGHT, LOWER EXIT LIGHTS AT EACH DOOR INOPERATIVE. CHARGED EMERGENCY EXIT LIGHT BATTERY PACKS PER AMM 33-51-07 AND 24-22-00, OPERATIONAL CHECK FOUND SATISFACTORY.SDR U2RA201807040001Battery Pack · dischargedFLOOR LEVEL ESCAPE PATH LIGHTING AT SEAT ROWS 8 THROUGH 15 INOPERATIVE. CHARGED BATTERY PACKS PER AMM33-51-07 AND 24-22-00, OPERATIONAL CHECK FOUND SATISFACTORY.SDR SWAA2018081324193Lens · crackedGALLEY NR 1 EXIT LIGHT LENS CRACKED TOP AND BOTTOM. R&R LIGHT ASSEMBLY IAW AMM.SDR REXA2018070300603Light · inoperativeEXIT SIGN BULBS BURNED OUT. R&R BULBS FOR EXIT SIGN AS REQUIRED.SDR REXA2018070300602Light · missingFLOOR PROX LIGHT IN FRONT OF THE SEAT 13C IS MISSING. REPLACED FLOOR PROX LIGHT IAW AMM 33-51-01.SDR AALA2018070659035Lens · missingEMERGENCY LIGHT LENSES MISSING ON SEATS 10C,16C, 23C. REPLACED THE EMERGENCY LIGHTS, ROW 23C IAW MM 33-50-00. OPS CHECKED NORMAL.SDR AALA2018070659034Lens · missingEMERGENCY LIGHT LENSES MISSING ON SEATS 10C,16C, 23C. REPLACED EMERGENCY LIGHTS ROW 16C IAW MM 33-50-00. OPS CHECKED NORMAL.SDR AALA2018070659033Cover · missingEMERGENCY LIGHT COVERS AT SEATS 1C, 3C WERE MISSING. REPLACED EMERGENCY LIGHTS AT ROW 3.SDR AALA2018070659013Lens · missingEMERGENCY LIGHT LENS MISSING ON SEATS 10C,16C, 23C. REPLACED EMERGENCY LIGHTS ROW 10C IAW MM 33-50-00. OPS CHECKED NORMAL.SDR AALA2018070659011Cover · missingEMERGENCY LIGHT COVERS AT SEATS 1C, 3C, MISSING. REPLACED EMERGENCY LIGHTS.SDR IPXA2018070331355Light · inoperativeEMERGENCY LIGHT BULB AT ENTRY WAY INOP. RELAMPED EMERGENCY LIGHT BULB ENTRY WAY PER AMM 33-15-11.SDR SWAA2018070423317Battery Pack · dischargedLT EMERGENCY LIGHTS INOP AT ROW 6. R&R BATTERY PACK PER AMM.SDR SWAA2018070423315Light · dimLT EMERGENCY EXIT LIGHT DIM. R&R LIGHT PER AMM.SDR SWAA2018070423314Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PACK PER MM.SDR SWAA2018070423313Battery Pack · failedRT AFT EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2018070423312Light · inoperativeLT EMERGENCY LIGHT INOP AT ROW 14. RELAMPED LIGHT PER AMM.SDR SWAA2018070423311Light · inoperativeRT AFT WING SLIDE EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018070423308Battery Pack · dischargedRT EMERGENCY LIGHTS INOP AT ROW 8. R&R BATTERY PACK PER AMM.SDR DALA2018070404359Light · brokenFOUND EMERGENCY LIGHT L2-938 BROKEN AFT COMPARTMENT. REPLACED TERMINALS NEEDS LIGHT ASSY MOUNTED. MOUNTED LIGHT ASSY CKS GOOD.SDR DALA2018071804541Lens · damagedTHE EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. MAINTENANCE REPLACED THE EMERGENCY EXIT COVER DIFFUSER LENS. OPERATIONAL CHECK IS NORMAL AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR 29GA2018070300001Light · inoperativeFLT 0051 FLL/TPA. ONE SEGMENT OF EMERGENCY LIGHT SYSTEM IS OUT. R&R RT EMERGENCY LIGHT STRIP IAW AMM 33-50-20-04, OPS CHECK GOOD.SDR SWAA2018071123325Light · brokenG1 GALLEY EXIT LIGHT ASSEMBLY BROKEN. R&R LIGHT ASSEMBLY IAW AMM.SDR YENA201807060274Battery · failedFT 706, FLL-EWR. DURING EMERGENCY TEST ON PTP, EPSU BATTERY EMER RT FAILED. R&R BATTERY AT 12WL IRW AMM 33-51-38. OPS CHECK SAT.SDR AALA201807039013Lens · damagedAIRCRAFT WAS NOT GROUNDED. R1 DOOR EMERGENCY EXIT LENS COVER DAMAGED. INSTALLED NEW EMERGENCY LENS ON R1 DOOR.SDR SWAA2018070423303Sign · missingR2 DOOR EXIT SIGN MISSING. R&R SIGN ASSEMBLY PER MM.SDR SWAA2018070323291Battery Pack · dischargedL1 DOOR OF FIRST TWO CABIN EMERGENCY LIGHTS INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2018070223258Cover · brokenMID CABIN CEILING EMERGENCY EXIT SIGN COVER BROKEN. SECURED SIGN PER AMM.SDR ASAA2018070225257Battery Pack · dischargedMAIN CABIN EMERGENCY LIGHTS INOP (4EA) FWD ENTRY, CENTER AISLE IN O/H CEILING, O/H L1 DOOR BULKHEAD ON LAV A, AND ONE OUTSIDE L1 ENTRY DOOR. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY PACK M1675 (S/N 83237) AND OPS CHECK GOOD IAW AMM 33-51-0SDR FDEA201807021620Light · inoperativeON PREFLIGHT CHECK, FOUND EMEGENCY LIGHT DOES NOT ILLUMINATE DURING EMERGENCY LIGHT TEST AND ALSO WHEN S/W SELECTED ON. A/C RELEASED PER MEL.SDR SIMA20180703004Light · inoperativeLT OVERWING LATERAL PANEL EMERGENCY LIGHT INOP. REMOVED AND REPLACED LT OVERWING LATERAL PANEL EMERGENCY LIGHT IAW AMM 33-50-10, OPC GOOD.SDR R61A201807030740Power Unit · inoperativeR1 DOOR EMERGENCY LIGHT INOP. R&R EMERGENCY LIGHT POWER UNIT ABOVE R1 DOOR IAW AMM 33-50-01.SDR AALA201807039014Light · damagedSEAT EMERGENCY LIGHT AT ROW 23L WAS FOUND DAMAGED. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-19. OPS CHECKED OK.SDR AALA201807039007Battery · dischargedFLASHLIGHT AT AFT FORWARD FACING JUMP SEAT WAS INOPERATIVE. REPLACED THE FLASHLIGHT BATTERY AND RETAINING STRAP. OK FOR SERVICE.SDR F3LA2018070300362Epsu · failedEPSU SYSTEM TEST FAILS. REMOVED AND REPLACED EPSU 10WL FORWARD REFERENCE AMM 33-51-38 PB401. OPS CHECK OK.SDR N6WA2018070301Lens · crackedLT OVERWING EMERGENCY FLOOD LIGHT LENS CRACKED. DEFERRED LENS ON OC 1895760 PER NEF 25-100-12 C/P/T 7/13/18 CAT 1.SDR DALA2018070304341Light · inoperativeEMERGENCY ESCAPE PATH LIGHT INOP AT 22CDE. R&R ASSY PER AMM 33-51, OPS NML.SDR DALA2018070204337Battery · dischargedDOOR 2 LEFT OVER HEAD LIGHTS INOP. CHANGED BATTERIES PACK TWO 'D' CELL P/N AD4002P UNIT 107 DOOR 2 LEFT EMERGENCY OVERHEAD LIGHT OPS CHECK GOOD IAW AMM 33-50.SDR MASA2018070213378Battery · discharged5 OVERHEAD EMERG FLOOD LIGHTS INOP. CHARGED BATTERIES.SDR MASA2018070213377Light · inoperativeROW 20 OVHD EMER FLOOD LIGHT INOP. RELAMPED.SDR DALA2018070204321Light · inoperativeEMERGENCY LIGHTS AT SEAT 7A, 8A, AND 10A ARE INOPERATIVE. MAINTENANCE RESEATED GROUND AT D21304. SYSTEM OPERATION IS NORMAL.SDR DALA2018070204300Relay · faultyOVERWING EMERGENCY LIGHTS WON'T EXTINGUISH AFTER SETTING EMERGENCY LIGHT SWITCH TO OFF AS REPORTED BY 2ND SHIFT (WILL ONLY SWITCH OFF ON 'ARM' POSITION). T/S PER FIM 33-51-00-802. REMOVED AND REPLACED OVERWING EMER EVAC LIGHTS BATTERY PACK RELAY R2-273 IAW ASDR SIMA20180701007Light · damagedCABIN FLOOR LT #7 EMERGENCY LIGHT STRIP DAMAGED AT FWD END. C/A-COMPLETE:INSTALLED EXISTING LIGHT STRIP IN NEW EXTRUSION IAW 33-50-12.
Back to JASC 3350