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 AALA201710039001Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE R1 DOOR HAS A DETACHED LENS COVER. REPLACED EXIT SIGN PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR SWAA2017100316876Battery Pack · dischargedRT EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2017100316875Battery Pack · dischargedLT OVERWING EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2017100316874Light · brokenLT OVERWING EMERGENCY EXIT ASSEMBLY ACTUATOR NUTS BROKEN. R&R LIGHT HOUSING ASSEMBLY PER SRM.SDR SWAA2017100316873Sign · looseFORWARD GALLEY EXIT SIGN LOOSE. SECURED SIGN PER AMM.SDR SWAA2017100316861Light · inoperativeRT OVERWING EMERGENCY EXIT LIGHT BULB INOP. RELAMPED LIGHT PER MM.SDR SWAA2017100316841Light · inoperativeEMERGENCY LIGHT INOP AT ROW 22. R&R BULB PER AMM.SDR SWAA2017100316836Light · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR AALA201710029019Power Supply · faultyEMERGENCY POWER SUPPLY UNIT AT 14WL FAULTING. REPLACED ESPU IAW AMM.SDR AALA201710029008Bulb · burned outEMERGENCY EXIT LIGHT BULB BURNED OUT, REPLACED THE BULB IAW AMM.SDR DALA2017100207232Lamp · inoperativeRT EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-50.SDR SWAA2017100216824Sign · missingRT EMERGENCY OVERWING EXIT SIGN MISSING. INSTALLED SIGN IAW AMM.SDR SWAA2017100216822Light · looseLT OVERWING EMERGENCY EXIT LIGHT LOOSE. SECURED LIGHT PER MM.SDR SWAA2017100216771Light · inoperativeRT OVERHEAD OVERWING EMERGENCY LIGHT INOP. R&R BULB PER AMM.SDR AALA20170930004Light · damagedEMERGENCY EXIT LIGHT BY THE R4 DOOR GALLEY FRONT IS DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-02. OPS CHECKED GOOD.SDR REXA2017093001045Battery Pack · inoperativeEMERGENCY LIGHT BATTERY NOT CHARGING. REPLACED THE EMERGENCY BATTERY IAW 33-900-701 P.SDR DALA2017100207215Battery Pack · inoperativeEMERGENCY LIGHT SIGNS WILL NOT ILLUMINATE DURING TEST. R & R THE BATTERY PACK M312 IAW AMM 33-51. OP CHECKED GOOD. OK FOR SERVICE.SDR DALA2017100207214Light · missingL4 DOOR RED EMERGENCY LIGHT ASSY ON FLOOR MISSING. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51, OPS CHECKED GOOD.SDR REXA2017093001040Bulb · inoperativeEXTERIOR EMERGENCY LIGHT IS OUT ON LEFT SIDE. R & R THE BULB, OPS CHECKED GOOD IAW AMM 33-51-21.SDR SIMA20170930001Power Supply · inoperativeLEFT FWD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-50-04. OPS CHECKED GOOD.SDR IPXA2017100122173Switch · looseEMERGENCY EXIT LIGHT SWITCH LOOSE. SECURED THE LIGHT SWITCH IAW MM 20-11-00.SDR DALA2017100207210Charger · inoperativeEMERGENCY LIGHTS AFT SECTION OF ACFT INOPERATIVE. R & R THE CHARGER IAW AMM 33-51-07. OPS NORMAL.SDR REXA2017093001039Light · inoperativeFLOOR EMERGENCY LIGHTS INOPERATIVE ROW 9-12. R & R THE EMERGENCY LIGHT SECTION IAW AMM 33-51-01. OPS CHECKED GOOD. OK FOR SERVICE.SDR YENA201709300811Battery Pack · no testEMERGENCY LIGHT BATTERY 11WL FAILED TO TEST. R & R THE BATTERY IAW AMM 33-51-38. OPS CHECKED OK.SDR HNAA2017100200342Bulb · inoperative6TH AND 7TH EMERGENCY LIGHTS INOPERATIVE. R & R THE BULBS.SDR AALA201710029016Power Supply · no testEMERGENCY LIGHT FAILED AN OPS TEST. REPLACED EPSU.SDR AALA201710029012Battery · no testEMERGENCY LIGHT FAILED AN OPS TEST. FAULTED ESPU 11WL, BATTERY FAULT. REPLACED THE BATTERY.SDR CALA2017093003356Battery · failedDURING EMERGENCY LIGHT TEST, AFT AND RIGHT SIDE POWER SUPPLY UNIT BATTERIES, FOUND FAILED. REPLACED BOTH POWER SUPPLY UNIT BATTERIES PER AMM 33-51-38 , TEST GOOD.SDR CALA2017093003355Lens · missingEMERGENCY LIGHT COVER MISSING FROM FIRST CLASS CABIN CLOSET INSTALLED REPLACEMENT COVER PER AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR CALA2017093003354Charger · inoperativeDOOR 2L EMERGENCY EXIT INDICATOR LIGHT INOP. .REPLACED BATTERY CHARGER OP CHECK NORMAL REF AMM 33-51-06.SDR CALA2017093003353Switch · faultyEMERGENCY LIGHT SWITCH ON P5 PNL IN COCKPIT, LIGHT STAYS ON WHEN SWITCH IS IN THE ON POSITION. REMOVED AND REPLACED AFT F/A PANEL LIGHTING SWITCH REF WD 33-51- 11, OPS CHECK EMERGENCY LIGHTS REF AMM 33-51-00-720-801, OPS CHECK WORK LIGHT REF AMM 33-26-01-710-0SDR CALA2017093003351Light · inoperativeEMER LIGHTS UNARMED LIGHT BULB INOP RELAMPED. OPS CHECK GOOD.SDR MASA2017093012678Light · inoperativeRIGHT FWD EXTERIOR EMERGENCY LIGHT NEAR THE GALLEY DOOR FOUND INOPERATIVE.SDR MASA2017093012677Light · inoperativeLEFT FWD OVERWING EMERGENCY LIGHT INOPERATIVE.SDR MASA2017093012676Light · inoperativeRIGHT FWD OVERWING EMERGENCY LIGHT INOPERATIVE.SDR SWAA2017100516917Light · damagedG1 GALLEY EMERGENCY EXIT LIGHT DAMAGED. R&R LIGHT IAW MM.SDR DALA2017100207262Battery Pack · faultedFOUND A FAULT DURING A EMERGENCY LIGHT CHECK. EPSU BATTERY LEFT, FAULTED ON EPSU 11WL. R & R THE BATTERY PACK.SDR SWAA2017100316883Charger · inoperativeLT FUSELAGE OVERWING EMERGENCY LIGHT INOP AT LOCATION M1668. R&R BATTERY CHARGER ASSEMBLY IAW AMM.SDR SWAA2017100316859Light · inoperativeR1 DOOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SCNA20170929201Battery Pack · dischargedROW 22 DEF AND AFT EMER. LIGHTS FAILED CAPACITY FUNCTIONAL TEST. REMOVED AND REPLACED EMERGENCY BATTERY PACK.SDR SCNA20170929200Battery Pack · dischargedROW 22 ABC AND AFT EMER. LIGHTS FAILED CAPACITY FUNCTIONAL TEST. REMOVED AND REPLACED EMERGENCY BATTERY PACK.SDR SWAA2017100216801Strip · crackedFORWARD LT EGRESS LIGHT STRIP RACEWAY CRACKED. R&R STRIP IAW SIP.SDR SWAA2017100216800Lens · missingAFT CENTER AISLE EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS IAW AMM.SDR SWAA2017100216799Lens · missingAFT CEILING EMERGENCY EXIT SIGN LENS MISSING. INSTALLED LENS IAW AMM.SDR ASAA2017092922086Lens · detachedCEILING OVERHEAD EXIT LENS CAME OFF. ACFT GROUNDED. REINSTALLED OVERHEAD EXIT SIGN COVER, OPS CHECKS GOOD.SDR SIMA20170929002Lamp · inoperativeMAIN DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-06-000-801-A, AND 33-50-06-400-801-A. OPS CHECKED GOOD.SDR IPXA2017093022159Battery Pack · inoperativeUPPER DECK EMERGENCY LIGHTS L1853, L1854, AND L5735 ARE INOPERATIVE. REPLACED THE EMERGENCY LIGHT BATTERY PACK M5170 IAW AMM 33-51-04-902-001-001 REV 90.02. PERFORMED A SATISFACTORY EMERGENCY LIGHT TEST.SDR AALA20170930001Power Supply · no testEMERGENCY POWER SUPPLY UNIT TEST SHOWS 11WL FAULT. REPLACED THE POWER SUPPLY IAW AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR UIEA2017092901900Lamp · inoperativeR2 EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED GOOD IAW AMM 33-51-00.SDR DALA2017100207191Lens · missingCABIN STANDBY LIGHT AT SEAT 15 ABC MISSING THE LENS. REPLACED THE OVERHEAD EMERGENCY LIGHT ASSY IAW AMM 33-51. PERFORMED AN OPS TEST IAW AMM 33-51. OPS TESTED OK.
Back to JASC 3350