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 YENA201712080988Battery Pack · failedFT # 640, CLE-BOS. EMERGENCY LIGHT POWER SUPPLY UNIT #1 FAILED FUNCTIONAL TEST; REPLACED EMERGENCY LIGHT POWER SUPPLY UNIT #1 IAW AMM 33-50-01. ACFT OK FOR SERVICE.SDR CALA2017120804363Light · incorrectPER FLT CREW, PLEASE CHECK EMERGENCY LIGHT CONFIGURATION ON THE FWD CLOSET. REPORT FINDINGS TO TOMC. REF CMM 25-20-23 ITEM 155,175 AND SWPM 20-90-14 REPLACE EMERGENC Y LIGHT TO CORRECT CONFIGRATION, OPS CHK OK ADD EMP:U217909SDR CALA2017120804362Lens · missingEMERGENCY EXIT LIGHT CAP MISSING IN FIRST CLASS REPLACED EMERGENCY EXIT LIGHT AT DOOR 1L CLOSET OPS CHECKED NORMAL.SDR CALA2017120804360Lens · missingFWD CLOSET EMERGENCY PATH LIGHT MISSING PLASTIC COVER REPLACED PLASTIC COVER ON FWD CLOSET EMERGENCY PATH LIGHT.SDR CALA2017120804356Light · unknownDOOR 1R SLIDE LIGHT NOT ILLUMINATED WITH DOOR ARMED UNABLE TO DUPLICATE. NORMAL CONDITION VERIFIED.SDR CALA2017120804354Light · unknownEMERGENCY LIGHTS WITH OVHD PNL SW IN ARMED POS, UNARMED LIGHT ON AND MSG DISPLAYED PERFORMED OPERATIONAL TEST PER MM33-51-00-715-044. ALL SWITCH POSITIONS CHECKED GOOD PER THE MM. OK TO CONTINUE.SDR CALA2017120804352Light · unknownFLOOR MOUNTED EMERGENCY ESCAPE LIGHTING AND 4 SMALL EXIT LIGHTS AT OVERWING EMERGENCY EXITS ARE INOP. LIGHTS OPS CHK NORMAL.SDR CALA2017120804351Sign · unknownFLIGHT DECK EXIT SIGN DOES NOT WORK WHEN OVERHEAD PANEL 5 EMERGENCY EXIT SWITCHED TO ON. REF CARD76-2333-1-6190. LIGHTS OPS CHK NORMAL.SDR CALA2017120804350Light · shortedL/H AFT EMERGENY PATH LIGHT ASSEMBLY AT SEAT 21DEF IS SHORTED. RELAMPED 21DEF EMERGENCY PATH LIGHT ASSY-OPS CKS NORMALSDR CALA2017120804347Lamp · inoperative3L MED EXTERIOR EMERGENCY LIGHT IS INOP. RELAMPED BULB OPS CHECK GOOD REF AMM 33-51-04 OPS CHECK GOODSDR CALA2017120804369Lamp · inoperative#4L MED EXTERIOR EMERGENCY LIGHT INOP RELAMPED #4L EXTERIOR EMERGENCY LIGHT. OPS CHECK GOOD.SDR CALA2017120804368Light · unknown#2R MED EXTERIOR EMERGENCY LIGHT INOP CYCLED A/C POWER. OPS CHECK GOOD.SDR CALA2017120804359Lamp · inoperativeLEFT AFT OVERWING EMERGENCY EXIT LIGHT INOP RELAMPED OPS CHECKS NORMALSDR CALA2017120804358Lens · looseEMERGENCY LIGHT LENS PLASTIC COVER ADJACENT TO EXIT 1L FELL OFF RESECURED LENS CK OKSDR CALA2017120804371Light · inoperativeDURING A CHECK, FOUND SEAT 42G & 44G EMERGENCY LIGHTS INOPERATIVE. THE EMERGENCY LIGHTS WERE REPLACED IAW AMM 33-51-00.SDR CALA2017120804370Light · malfunctionedBELOW 5000 FEET, EMERGENCY EXIT LIGHTS CAME ON BLINKING. GROUND OPS TESTED THE EMERGENCY LIGHT SYS, ALL FUNCTION NORMAL.SDR CALA2017120804367Light · missingROW 5AB AND 28C EMERG. PAST LITE MISSING INSTLD NEW EMERG. LITE ASSY''S SEATS 5AB AND 28C OPS CHKD OK ITEM CLRDSDR CALA2017120804366Unknown · unknownEMERGENCY EXIT LIGHTS ON WITH FLT DECK SWITCH IN THE ARM POSITION CYCLED POWER AND EMER. EXIT LT. SWITCH . EMER. LIGHTS FUNCTION NORMALLYSDR MASA2017120812825Light · inoperativeEMER LIGHTS INOP. STILL IN WORK.SDR DALA2017121208560Socket · damagedRIGHT AFT OVERWING EXIT HANDLE EMERGENCY LIGHT SOCKET DAMAGE, REPLACED LIGHT ASSYSDR SWAA2017121218412Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M01672. R&R BATTERY PER AMM.SDR SWAA2017121218411Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M01673. R&R BATTERY PER AMM.SDR SWAA2017121218390Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M01670. R&R BATTERY PER AMM.SDR SWAA2017121218376Battery Pack · dischargedEXTERIOR OVERWING EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2017121218375Battery Pack · dischargedLT OVERWING EMERGENCY EXIT LOWER IDENTIFIER LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SIMA20171207004Charger · inoperativeEMERGENCY FLOOR LIGHTING FROM 3A TO 6A INOP-C/A-REMOVED AND REPLACED #2 BATTERY HOLDER AND BATTERY CHARGER ASSEMBLY IAW EMB 145 AMM 33-50-04SDR ASOA201712074065Battery Pack · dischargedIAH - DURING MAINTENANCE INSPECTION EMERGENCY LIGHT STRIPS 1, 2, & 3 WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NUMBER TWO (2) EMERGENCY LIGHT BATTERY PACK, OPERATIONALLY TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR RETURN TSDR AALA201712119045Light · malfunctionedAIRCRAFT NOT GROUNDED. 2R EMERGENCY LIGHT STAYS ON CONTINOUSLY. PERFORMED OPS TEST OF EMERGENCY LIGHT SYSTEM PER AMM 33-50-00. NO DEFECTS WERE NOTED, ALL LIGHT FUNCTIONS SHOW NORMAL.SDR AALA201712119066Light · inoperativeAIRCRAFT WAS NOT GROUNDED. LEFT OVERWING EXIT SIGN HAS BULBS OUT. RELAMPED OVERWING EXIT SIGN PER AMM 33-51-01. OPERATIONAL CHECK OK.SDR SWAA2017121118365Sign · missingL2 DOOR LOWER EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROW. R&R SIGN IAW AMM.SDR SWAA2017121118364Sign · missingR1 DOOR LOWER EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROW. R&R SIGN IAW AMM.SDR SWAA2017121118309Lamp · inoperativeR2 DOOR EMERGENCY LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR IPXA2017120724259Battery Pack · inoperativeINSPECTION TYPE:EMERG LIGHT BATT LO. DEFERRED IAW MEL 33-50-4. R/R EMERGENCY BATT POWER SUPPLY IAW AMM 33-51-01-401; TEST OK.SDR AALA20171207001Sign · looseAIRCRAFT IN BASE MAINTENANCE. EXIT SIGN AT R1 DOOR LOOSE (BROKEN SCREW HOLE). REPLACED EXIT SIGN PER AMM 33-51-16.SDR AALA201712089026Light · damagedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT SEAT 14H RIGHT HAND AISLE DAMAGED. INSTALLED EMERGENCY EXIT LIGHT SEAT 14H RIGHT HAND AISLE PER ESO 41072.SDR IPXA2017120724257Sign · detachedINSPECTION TYPE:N/ALEFT DOOR EMER EXIT SIGN FELL OFFREINSTALLED EMER EXIT SIGN IAW MD 11 MM 33 27 05 400SDR IPXA2017120724268Socket · inoperativeINSPECTION TYPE:NAEMERGENCY EXIT LIGHT ON EXTERIOR OF A/C BELOW ENTRY DOOR INOPR&R EXT EMERGENCY LIGHT LAMP HOLDER ASSEMBLY REF AMM 33-51-16 OPS CKS NORMALSDR UIEA2017120802376Light · looseU/D FLOOR MOUNT EMERGENCY LIGHT AT L & R DOOR PADS LOOSE(<P>LOCATED AND RE SECURED LOOSE PADS AT U/D FLOOR MOUNTED EMERGENCY LIGHT AT EMERGENCY DOOR. PER AMM 20-30-01-802-001</P>)SDR MASA2017120712821Battery Pack · dischargedRIGHT ROW 4 EMERGENCY EXIT SIGN INOPERATIVE. REPLACED BATTERY PACK.SDR UIEA2017120702372Pad · looseU/D FLOOR MOUNT EMERGENCY LIGHT AT L & R DOOR PADS LOOSE.(<P>LOCATED AND RE SECURED LOOSE PADS AT U/D FLOOR MOUNTED EMERGENCY LIGHT AT EMERGENCY DOOR. PER AMM 20-30-01-802-001.</P>)SDR JJBA20171207007Bulb · inoperativeCABIN EMERGENCY PASSAGEWAY EXIT C/D SIDE INOP. R&R BULB. OPS CHECK SAT.SDR A6WA2017120745456Light · inoperative4231 EMERGENCY LIGHTS ROW 5 INOP ON FLOOR. PLACARDED & PLACED ON MEL. REMOVED & REPLACED EMERGENCY LIGHT STRIP ROW 5 IAW 33-51 & AWAC SUPP
16-371A. OPS CHECK GOOD.SDR SWAA2017121218385Light · inoperativeLT OVERWING EMERGENCY EXIT DOOR EXTERNAL EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR AALA201712129020Lens · brokenAIRCRAFT NOT GROUNDED. LAVATORY D LOWER EMERGENCY LIGHT LENS BROKEN. REPLACED LIGHT ASSY. AT LOWER EMERGENCY PATH LIGHT AND OPS CHECKED OK IAW AMMSDR AALA201712129014Lens · brokenAIRCRAFT NOT GROUNDED. LOWER EMERGENCY LIGHT LENS BROKEN. REPLACED LOWER EMERGENCY PATH LIGHT AT LAV L AND OPS CHECKED OK IAW AMM .SDR SWAA2017121118347Switch · inoperativeAFT GALLEY EMERGENCY LIGHTS INOP. R&R SWITCH IAW SIP & MM.SDR SWAA2017121118344Battery Pack · failedLT FORWARD EMERGENCY BATTERY PACK FAILED TIME TEST. R&R BATTERY PACK PER AMM.SDR SWAA2017121118336Power Supply · failedBATTERY PACK M1669 FAILED THE CAPACITY CHECK. R&R POWER SUPPLY PER AMM.SDR DALA2017120708500Light · inoperative(AIRCRAFT 6714, L/P 0327553) EMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS:03C / SEAT MOUNTED EMERGENCY LIGHTS. RESEATED LIGHT AT 3C.SDR DALA2017120708499Light · damaged(AIRCRAFT 6714, L/P 0327552) EMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS:02C / SEAT MOUNTED EMERGENCY LIGHTS. RESEATED LIGHT AT 2C.
Back to JASC 3350