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 RAIA202001210001Bulb · inoperativeRH AFT WING/FUSELAGE FAIRING EXTERNAL FLOOD LIGHT (#6) IS INOP----- R&R FLOOD LIGHT BULB OPS CHECK GOODSDR DALA2020012170454Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS: 2L. REINSTALLED EXIT LENS AT 2L NEW LENS WAS INSTALLED.SDR SWAA2020012040638Battery Pack · dischargedRT EMERGENCY AISLE LIGHT INOP AT ROW 6. R&R BATTERY PACK PER AMM.SDR SWAA2020012040637Battery Pack · dischargedRT OVERWING EMERGENCY GROUND LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2020012040618Battery Pack · dischargedLT EMERGENCY LIGHT INOP BETWEEN ROW 12 TO ROW 17. R&R BATTERY PACK PER AMM.SDR SWAA2020012040603Fuse · inoperativeRT OVERWING EXTERIOR EMERGENCY ESCAPE LIGHT INOP. R&R POWER SUPPLY FUSE PER AMM.SDR SWAA2020012040602Battery Pack · dischargedFORWARD COVER CEILING EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2020012040601Battery Pack · dischargedLT OVERWING EMERGENCY GROUND LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2020012040600Light · inoperativeFORWARD SERVICE ENTRANCE EMERGENCY SLIDE LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2020012040542Sign · detachedOVERWING EXIT SIGN DETACHED, WAS HANGING BY WIRES. SECURED SIGN PER MM.SDR SWAA2020012040544Cover · defectiveCENTER AISLE EMERGENCY EXIT SIGN INOP. INSTALLED LENS COVER PER SIP.SDR SIMA2020012017009Bulb · inoperativeRH OVERWING EMERGENCY LIGHT IS INOP-C/A-REMOVED AND REPLACED RH AFT OVERWING EMERGENCY LIGHT BULB IAW EMB 140 AMM 33-50-07.OPS CHECK GOOD.SDR CALA2020011900193Lens · missingSEAT 15ABC EMER. PATHWAY EXIT LIGHT LENS MISSING. REPLACED LIGHT ASSY REF AMM 33-51-11-960-802 OPS CHECKED OK. ACP IDT INSP OF REPLACING EPL AT SEAT 15ABC REF GMM 09-10-05 AND AMM 33-51-11. OPS CHK GOOD.SDR CALA2020011900190Light · inoperativeSEAT 8 ABC EMERGENCY LIGHT INOP SUPPORT TASK.SDR SIMA202001197005Lamp · inoperativeLH SIDE CENTER FAIRING EMERGENCY LIGHT INOP-C/A-RAR LH SIDE CENTER FAIRING EMERGENCY LIGHT LAMP IAW EMB 145 AMM 33-50-10 OPS CHECK GOOD.NO FURTHER DEFECT DETECTEDSDR DALA2020011700349Battery Pack · inoperative(DURING SVC, FOUND OVERHEAD CABIN EMERGENCY LIGHTS FROM ROW 16-25 INOP. R/R BATTERIES AT BATTERY PACKS B5-102 & B5-104 PER MD88 AMM 35- 53. OPS CKS GOOD. (LP6466970)SDR JJBA20200117004Charger · inoperativeBOTH OVER WING EMERGENCY LIGHTS INOPERATIVE. R&R #4 EMERGENCY LIGHT BATTERY. OPS CHECK FAILED. R&R BATTERY CHARGER ASSEMBLY. OPS CHECK SAT. ORIGINAL BATTERY STILL INSTALLED.SDR YENA2020012216027Battery Pack · no testFLT 514, CIDS ONE EPSU BITE TEST FAILS 12WL ESPU BAT FAILURE. R & R EPSU 12WL BATTERY IAW AMM 33-51-38. EPSU BITE TEST CHECKS OK IAW AMM 33-51-00-710-001-A.SDR YENA2020012260026Deu · failedFLT 514, ALL AFT GALLEY EMERGENCY SIGNS & LIGHTS FAILED TO ILLUMINATE ON POWER FAILURE. R & R DEU B IAW 23-73-47. EMERGENCY LIGHTS IN AFT GALLEY OPS CHECKED GOODSDR ASAA2020012161923Battery Pack · dischargedEMERGENCY EXIT LIGHTS INOP ON RIGHT SIDE OF AIRCRAFT FROM AFT OVERWING EXIT BACK. EMERGENCY EXIT LIGHTS ARE INTERMITTENT ON LEFT SIDE OF AIRCRAFT. GROUNDED - YES. FOUND 6 EACH OF R/H AFT EMERGENCY EXIT AISLE LIGHTS, R2 OVERHEAD DOOR EMERGENCY EXIT LIGHT, EXTERSDR SWAA2020012040545Sign · detachedCENTER AISLE "EXIT" SIGN DETACHED. SECURED SIGN PER AMM.SDR SWAA2020012040535Light · inoperativeRT OVERWING EMERGENCY MID SIDEWALL EMERGENCY LIGHT BULBS INOP. RELAMPED SIGN PER MM.SDR ASAA2020011731879Light · inoperativeLEFT AFT ENTRY DOOR SLIDE EMERGENCY LIGHT IS INOP. GROUNDED - YES. RELAMPED EMERGENCY LIGHT PER AMM 33-51-04-960-801 / OPS CK GOOD.SDR DALA2020011700378Light · inoperativeDURING SERVICE CHECK FOUND RT FWD OVERWING EMERGENCY EXIT DOOR PULL HANDLE LIGHTS INOP, RELAMPED RT FWD OVERWING EMERGENCY EXIT DOOR PULL HANDLE LIGHTS.SDR DALA2020011700374Battery · dischargedTHE AFT EMERGENCY EXIT SIGN, CAPTAINS SIDE, IS INOPERATIVE. MAINTENANCE FOUND THAT ALL OF THE ASSOCIATED LIGHTS WITH EMERGENCY POWER SUPPLY B5-260 WERE FLASHING IN THE ARMED POSITION. THE BATTERY AND BATTERY POWER SUPPLY WERE REPLACED PER AMM 33-51-03. ALL OPESDR DALA2020011700373Battery · dischargedTHE EXTERNAL OVERWING EMERGENCY LIGHTS FAILED TO ILLUMINATE. MAINTENANCE REPLACED THE BATTERY AND POWER SUPPLY PER AMM 33-51. OPERATIONAL CHECK WAS GOOD.SDR AALA202001179003Light · brokenAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT AT ROW 6 ABC WAS BROKEN. MAINTENANCE REPLACED SEAT 6 ABC EMERGENCY LIGHT PER AMM 33-17-00.SDR R61A2020011760032Light · detachedPHOTOLUMINESCENT FLOOR STRIP BY SEAT 1C HAS DETACHED. RESECURED PHOTOLUMINESCENT FLOOR STRIP AS NEEDED.SDR R61A2020011760031Light · damagedPHOTOLUMINESCENT STRIP NEAR GALLEY WARDROBE FADED. R&R PHOTOLUMINESCENT STRIP AT WARDROBE IAW 33-50-21.SDR REXA2020011760047Light · inoperativeUPON INSPECTION FOUND RH OVERWING EXTERIOR EMERGENCY LIGHT 6 BELOW AND BETWEEN THE PASSENGER WINDOWS AT FS416.50R INOP
RELAMPED RH OVER WING EXTERIOR EMERGENCY LIGHT 6 IAW AMM 33-51-21, OPERATIONAL TEST GOOD, NO DEFECTS NOTED AT THIS TIME. P/N 1317SDR JJBA202001176003Charger · shortedBOTH LH AND RH OVER WING EMERGENCY LIGHTS INOPERATIVE. R&R RH OVER WING EMERGENCY LIGHT ASSEMBLY DUE TO SHORTED ASSEMBLY. R&R #4 EMERGENCY BATTERY AND CRADLE. OPS CHECK FAILED. R&R #4 EMERGENCY LIGHT BATTERY. OPS CHECK SAT.SDR MASA2020011600027Battery · dischargedEMERGENCY LIGHTS INOP. CHARGED EMERGENCY LIGHT BATTERIES.SDR MASA2020011600025Light · inoperativeROW 15 EMER CEILING LIGHT INOP. PLACED ON MEL.SDR SWAA2020011640492Light · inoperativeRT EMERGENCY LIGHT INOP AT ROW 25. R&R LIGHT IAW AMM.SDR SWAA2020012040636Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT M1673. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2020012040635Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT M1672. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2020012040634Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT M1674. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2020012040633Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT M1669. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2020012040599Light · crackedFORWARD LAV EMERGENCY EXIT LIGHT CRACKED. R&R LIGHT IAW AMM.SDR SWAA2020012040527Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT M1670. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2020012040522Lens · missingCEILING MID CABIN EXIT SIGN FORWARD LENS MISSING. INSTALLED LENS PER AMM.SDR DALA2020011700367Battery Pack · dischargedINSEAT EMERGENCY LIGHTS FROM SEAT 31-41 ARE INOPERATIVE. REPLACED BATTERY PACK AND CHARGER AT SEAT 39F. SYSTEM OPERATION IS NORMAL.SDR DALA2020011700363Cover · looseEMERGENCY EXIT SIGN COVER LOOSE / LOCATIONS:604 / INTERIOR. CORRECTIVE ACTION: RESECURED COVER.SDR VNAA2020011651101Relay · inoperativeEMERGENCY LIGHTS ON STATUS MSG AND ILLUMINATION OF EMERGENCY LIGHTS INTERMITTENT THROUGHOUT THE FLIGHT. REMOVED AND REPLACED K135 RELAY IAW CRJ 700 AMM. OPS CHECK GOOD.SDR SWAA2020011640514Light · inoperativeLT OVERWING EMERGENCY LIGHT EXTERIOR INOP. RELAMPED LIGHT PER AMM.SDR SWAA2020011640513Plate · missingOVERWING CENTER CABIN EXIT SIGN MISSING ONE FACE PLATE. R&R FACE PLATE PER MM.SDR SWAA2020011640516Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673 IN CABIN. R&R BATTERY PACK PER AMM.SDR SWAA2020011640505Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670 IN CABIN. R&R BATTERY PACK PER AMM.SDR SWAA2020011640504Battery · failedEMERGENCY LIGHT BATTERY FORWARD OF RT WING EXIT DOOR FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR MASA2020011500022Light · inoperativeRT FWD/AFT & LT FWD EMR EXT LIGHTS INOP 1 EA.
Back to JASC 3350