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 UIEA2018111122567Fuse · failedUPPER DECK EXIT LIGHT AT THE RIGHT CREW DOOR WAS INOPERATIVE. REPLACED THE FUSE ON THE BATTERY POWER SUPPLY M5168. EMERGENCY LIGHTS OPS CHECKED GOOD IAW AMM 33-51-04-710-001.SDR 29GA2018111200001Light · noneFLIGHT# 0088 ELH/FLL REPORT: DURING PROPER SHUT DOWN EMERGENCY LIGHT WILL NOT TURN OFF. CORRECTIVE ACTION: PERFORMED OPERATIONAL TEST OF EMERGENCY LIGHTING SYSTEM, OPS TEST GOOD REF SAAB 340 AMM 33-50-00-05.SDR MASA2018111111517Light · inoperativeEMERG FLOOR LUMIN STRIP AT 2DF INOP. REPLACEDSDR MASA2018111111516Light · inoperativeEMERG FLOOR LUMIN STRIP AT 1DF INOP. REPLACEDSDR DALA201811206715Lens · missing(AIRCRAFT 7008, L/P 5239320) EMERGENCY LIGHT RED LENS COVER MISSING IN ISLE AT MID GALLEY. INSTALLED RED LENS COVER CKS OK.SDR DALA2018112006712Lamp · inoperative(AIRCRAFT 7002, L/P 5186343) EMERGENCY AREA LIGHT AT STA. 1098RT, L33885 INOP. REMOVED AND REPLACED INOP LAMP AT STA. 1098RT, RESEATED GROUND AT GB-5 OPS CHECKS NORMAL. REF B777 WDM 33-51-64.SDR DALA2018112006711Battery Pack · inoperative(AIRCRAFT 7002, L/P 5186346) PASS SEAT EMERGENCY LIGHTS INOP AFT ZONE 2. REMOVED AND REPLACED BATTERY AT DOOR 3R M33404 OPS CHECKS NORMAL.SDR DALA201811206710Light · detached(AIRCRAFT 7008, L/P 5239321) EMERGENCY LIGHT AT SEAT 55F HANGING DOWN. INSTALLED LIGHT CKS OK.SDR AALA201811149020Battery Pack · dischargedGRU - THE AIRCRAFT WAS NOT GROUNDED. OFAR BATTERY PACK LT INOP. OFAR BATTERY PACK LT REPLACED IAW AMM 33-51-06. OK FOR SVC.SDR FDEA201811103173Light · inoperativeL1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED THE L1 SLIDE LIGHT, OPS CHECK GOOD IAW AMM 33-51-06-2-1.SDR YENA2018111400778Switch · failedFT # 466, RSW-BOS. HAD BATTERIES TO EMER EXIT LIGHTS CHANGED, THINGS WORKED. HAD ON PWR TRANSFER FROM EXTERNAL POWER TO APU, ALL EXIT LIGHTS CAME ON AND REMAINED ON W/ SWITCH IN ARM POSITION; R & R EMER EXIT LT SWITCH (4WL) IAW ESPM 20-45-21. ALL OPS NORMAL ATSDR YENA2018111400777Battery Pack · failedFT # 466, RSW-BOS. EMER EXIT LIGHTS IN CABIN (ALL) REMAIN ON FOR FLIGHT UNABLE TO RESET; REMOVED AND REPLACED AFT AND RH OVER WING EMER EXIT, EMER LIGHT BATTERY IAW AMM 33-51-38. OPS CHK GOOD NO FURTHER DEFECTS NOTED AT THIS TIME.SDR YENA2018111400776Battery Pack · failedFT # 466, RSW-BOS. EMER EXIT LIGHTS IN CABIN (ALL) REMAIN ON FOR FLIGHT UNABLE TO RESET; REMOVED AND REPLACED AFT AND RH OVER WING EMER EXIT, EMER LIGHT BATTERY IAW AMM 33-51-38. OPS CHK GOOD NO FURTHER DEFECTS NOTED AT THIS TIME.SDR YENA2018111400775Power Supply · inoperativeDURING HEAVY MAINTENANCE, AFT LEFT EMERGENCY LIGHT EPSU (13WL) FAILS. SEVERAL LIGHT DO NOT ILLUMINATE; REF HAECO NR 440530-22560, REMOVED AND REPLACED 13WL ESPU IAW A320 AMM 33-51-38. SYSTEM OPS CKS GOOD. SUPPLEMENTAL INFORMATION TO FOLLOW.SDR DALA2018111406626Lens · detached(AIRCRAFT 692, L/P 5357868) EXIT SIGN (COVER) ABOVE 2 LEFT (L2) IS DETACHED. RESECURED EXIT SIGN ABOVE DOOR 2 LEFT (L2)COVER AS PER BOEING 757 AMM 25-00.SDR SWAA2018111326713Lens · missingEXIT ROW SIGN LENS MISSING. SECURED LENS PER SIP.SDR SWAA2018111326712Lens · unsecureCENTER CABIN EMERGENCY EXIT SIGN LENSES FELL OFF. SECURED LENS PER SIP.SDR REXA2018111201074Bulb · inoperativeRH WING EMERGENCY LIGHT 8 INOP
REMOVED AND REPLACED BULB FOR EXTERIOR EMERGENCY LIGHT 8 IAW CRJ 200 AMM 33-51-21. OPS CHK GOOD.SDR MASA2018111011513Light · inoperativeCOAT CLOST PHOTO LUMNISC LIGHT INOP
PLACED ON MELSDR AALA201811210001Battery Pack · dischargedEMERGENCY BATTERY PACK FAILED A 10 MINUTE TIME TEST. REPLACED THE BATTERY PACK.SDR DALA2018111606652Lens · damaged(AIRCRAFT 7110, L/P 0819669) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / INTERIOR. INSTALLED LENS COVER. CKS GOOD.SDR DALA2018111606651Lens · damaged(AIRCRAFT 7110, L/P 0819687) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / INTERIOR. INSTALLED LENS COVER. CKS GOOD.SDR DALA2018111626650Lens · damaged(AIRCRAFT 7110, L/P 0819684) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE /INTERIOR. INSTALLED LENS COVER. CKS GOOD.SDR DALA2018111626649Lens · damaged(AIRCRAFT 7110, L/P 0819683) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / INTERIOR. INSTALLED LENS COVER. CKS GOOD.SDR DALA2018111626648Lens · damaged(AIRCRAFT 7110, L/P 0819679) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / INTERIOR. INSTALLED LENS COVER. CKS GOOD.SDR DALA2018111626647Lens · damaged(AIRCRAFT 7110, L/P 0819670) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / INTERIOR. INSTALLED LENS COVER. CKS GOOD.SDR DALA2018110906628Fuse · blownDURING SVC CHECK FOUND SEAT MOUNTED EMERGENCY LIGHTS IN 1ST CLASS IN-OP. FOUND BLOWN FUSE ON POWER SUPPLY 33094, CHECKED BULBS IN SIDE OF B/E SEATS. FOUND WRONG BULBS IN 3 SEATS. RELAMPED SEATS, R&R FUSE REF AMM 33-51.SDR DALA2018111206627Lens · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / INTERIOR. INSTALLED LENS COVER. CKS GOOD.SDR SWAA2018111326734Battery · dischargedL2 DOOR SLIDE UPPER EMERGENCY LIGHT INOP. R&R BATTERY PER AMM.SDR SWAA2018111326733Battery · dischargedR2 DOOR SLIDE EMERGENCY LIGHT INOP. R&R BATTERY PER AMM.SDR SWAA2018111326732Battery · dischargedR2 DOOR EMERGENCY LOWER LIGHT INOP. R&R BATTERY PER AMM.SDR SWAA2018111326731Battery · dischargedRT AISLE EMERGENCY LIGHT INOP BETWEEN ROW 16 TO ROW 19. R&R BATTERY PER AMM.SDR SWAA2018111326730Light · inoperativeRT OVERWING ESCAPE EMERGENCY LIGHT BULB INOP AT ROW 16. RELAMPED LIGHT IAW MM.SDR SWAA2018111326727Battery Pack · dischargedL1 DOOR SLIDE EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018111326726Battery Pack · dischargedFORWARD SERVICE UPPER EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018111326725Battery Pack · dischargedLT AISLE EMERGENCY EXIT LIGHT INOP AT ROW 4. R&R BATTERY PACK PER AMM.SDR SWAA2018111326687Light · inoperativeRT AISLE EMERGENCY LIGHT INOP AT ROW 16. RELAMPED LIGHT IAW MM.SDR SWAA2018111326674Battery · dischargedAFT CENTER AISLE EMERGENCY LIGHT INOP. R&R BATTERY PER AMM.SDR SWAA2018111326673Battery Pack · dischargedFLIGHT DECK DOME EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018111326660Light · inoperativeLT STOWAGE BIN EMERGENCY EXIT LIGHT INOP AT NR 17. RELAMPED LIGHT PER AMM.SDR YENA2018111390772Light · malfunctionedFT # 1150, MCO-ATL. EMER LIGHTS CONTINUOUSLY CYCLE ON & OFF; PERFORMED RESET OF EMERGENCY/CIDS SYSTEM REF AMM 23-73-00 NO FAULTS ADVISED MCC BOB.SDR HNAA2018111300280Light · inoperative624 33-51 0013420 09NOV18 RIC CLOSE
LEFT OVERWING EMERGENCY LIGHT INOP
29490 00 PAL
FACT 09NOV18 13:37 RIC
REMOVED AND REPLACED LEFT OVERWING EMERGENCY LIGHT
ASSY IN REFSDR SIMA20181109001Light · inoperativeLT OVERWING AFT EMERGENCY LIGHT INOP. REMOVED AND REPLACED LT OVERWING AFT EMERGENCY LIGHT LAMP IAW AMM TASK 33-50-10-000-801-A AND 33-50-10-400-801-A. OPS CHECK GOOD.SDR MYWA20181112085Charger · inoperativeLH EMERGENCY EXIT LIGHT PARTIALLY LIT, AFT OVERWING EXIT RELAMPED AND NO HELP. CHECKED AND FOUND BATTERY CHARGER AT FAULT. REPLACED BATTERY CHARGER AS PER AMM 33-51-06, OPS CHECK OK.SDR MASA2018110911511Bulb · inoperativeROW 11 EMERGENCY FLOOD LT INOP
PLACED ON MELSDR CALA2018110902344Lamp · inoperativeSEATS 14 & 24 ABC EEL PATHWAY LIGHTING INOP. RELAMPED REF AMM 33-51-15 OPS CHECKED OK. ACP IDT INSP OF RELAMPING OF EPL LIGHT AT SEAT 14 AND 24 REF GMM 09-10-05 AND AMM 33-51-15. OPS CK GOOD.SDR CALA2018110902342Power Supply · faultedWHILE PERFORMING EMERGENCY LIGHT TEST, GOT AFT L EPSU FAULT MESSAGE REMOVED AND REPLACED AFT L EPSU AND BATTERY PACK, REF AMM 33-51-38. OPS CHECK GOOD AT THIS TIME. ADD EMP:U098939 ROTABLE PARTS CHANGE WAS INDICATED - TT # 1248220 SN OFF 8117 IPC REFERENCE # SDR AALA201811099002Charger · unknownSEAT MOUNTED EMERGENCY LIGHTS AT 9D THRU 14D WERE VERY DIM. TROUBLESHOT AND REPLACED THE CHARGER IAW AMM 33-51-07. SYSTEM OPS NORMALLY.SDR AALA20181109001Battery · weakSEAT MOUNTED EMERGENCY LIGHTS AT 9D THRU 14D WERE VERY DIM. TROUBLESHOT AND REPLACED THE BATTERY PACK IAW AMM 33-51-07. SYSTEM OPS NORMALLY.SDR UIEA2018110902553Battery Pack · inoperativeEMERGENCY LIGHTS WERE INOPERATIVE ON THE MAIN DECK. REPLACED THE BATTERY PACK. OPS CHECKED GOOD.
Back to JASC 3350