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 CALA2017041401002Light · inoperativeL2 EMERGENCY EXTERIOR LIGHT INOP. RELAMPED L2 EXTERIOR EMERGENCY LIGHT. OPS CHECK GOOD. REF AMM 33-51-00-715-039.SDR CALA2017041401001Light · unsecureSEAT 28D EMERGENCY EXIT ROW LIGHT HAS SEPARATED FROM SEAT AND IS HANGING. RESECURED 28D EMERGENCY EXIT ROW LIGHT, OPS CHK GOOD.SDR CALA2017041400998Light · inoperative49ABC SEAT EMER LT 1EA FOUND INOP. REPLACED 49ABC SEAT EMER LT AND OP TEST CARRIED OUT FOUND NORMAL AS PER AMM 33-51-12-332-001 REV 87.SDR CALA2017041400987Sign · dimFLIGHT DECK DOOR OVERHEAD PORTABLE EMERGENCY EXIT SIGN FOUND DIM. FLIGHT DECK DOOR OVERHEAD PORTABLE EMERGENCY EXIT SIGN ASSY REPLACED AND TEST CARRIED OUT NORMAL IAW AMM 33-51-01.SDR CALA2017041400986Cover · missingROW 20ABC EXIT COVER ON SIDEWALL IS MISSING. REPLACED THE COVER AND BULBS. SIGN SECURED AND LIGHT CHECKS NORMAL.SDR CALA2017041400985Power Supply · inoperativeL2 AND R2 DOOR SIDEWALL EXIT SIGNS INOPERATIVE. REPLACED THE POWER SUPPLY M733 AND LAMP 776. OPS CHECKED NORMAL.SDR CALA2017041400997Lens · missing3K SEAT FWD EMERGENCY LIGHT LENS FOUND MISSING. REPLACED THE LIGHT ASSY AND OP TEST CARRIED OUT, FOUND NORMAL IAW AMM 33-51-12-332-001, REV 87.SDR CALA2017041400996Lamp · inoperativeSEATS 21ABC AND 42ABC, EMERGENCY LIGHTS INOPERATIVE. LAMPS REPLACED AT SEAT 21ABC AND 42ABC. TESTED OK IAW AMM 33-51-12- 201. OPS CHECKED GOOD IAW AMM 33-51-12-201.SDR CALA2017041400995Fuse · faultyDURING EMERGENCY LIGHT CHECK, EXTERIOR RT FWD 2 LIGHTS INOPERATIVE. FOUND BAD FUSE AT POWER SUPPLY UNIT (M7920). FUSE REPLACED AND WIRES CHECKED FOR SHORT TO GROUND AT CONNECTOR DM7920 PIN 15. NO FAULTS NOTED. IAW WDM 33-51-41 PG1 SH1. REINSTALLED POWER SUSDR DALA2017050103506Lens · missingR1 DOOR EXIT IDENTIFIER LENS MISSING. REPLACED IAW MM. OPERATIONS CHECKED GOOD.SDR SWAA2017040813197Guard · brokenFORWARD P5 OVERHEAD PANEL THE EMERGENCY EXIT LIGHT SWITCH GUARD BROKEN. R & R SWITCH GUARD IAW SOPM.SDR SWAA2017041813169Lens · looseR1 DOOR LOWER EXIT LIGHT LENS LOOSE. SECURED THE LENS IAW SIP.SDR SWAA2017041813160Cover · missingFORWARD GALLEY DOOR EXIT LIGHT COVER MISSING. REPLACED THE COVER ASSEMBLY IAW AMM.SDR SWAA2017041813157Sign · crackedMID CABIN CEILING OVERWING EMERGENCY EXIT SIGN LIGHT FRAME CRACKED. R & R SIGN ASSEMBLY IAW AMM.SDR AALA201704179071Light · brokenR2 AFT DOOR EMERGENCY LIGHT ASSY BROKEN. REPLACED R2 AFT DOOR EMERGENCY LIGHT ASSY PER AMM 33-51-00. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704179070Portable Light · inoperativePORTABLE EMERGENCY LIGHT FLASHLIGHT PORTION INOP. REMOVED AND REPLACED PORTABLE LIGHT ASSY. OPS CKED NORMAL PER MM 33-53-00. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704179056Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 4C HAS A MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201704179044Lens · crackedAIRCRAFT WAS GROUNDED. MAIN CABIN AFT LOWER CEILING PANEL EMERGENCY EXIT LIGHT LENS COVER CRACKED AT 253GLC. REPLACED MAIN CABIN AFT LOWER CEILING PNL EMERGENCY EXIT LIGHT LENS COVER.SDR AALA201704179043Lens · crackedAIRCRAFT WAS GROUNDED. MAIN CABIN AFT LOWER CEILING PANEL EMERGENCY EXIT LIGHT LENS COVER CRACKED AT 254CRC AND 253GLC. REPLACED MAIN CABIN AFT LOWER CEILING PANEL EMERGENCY EXIT LIGHT LENS COVER.SDR REXA2017041300507Light · missingFLOOR TRACK LIGHTING IN GALLEY MISSING. RESECURED EMER FLOOR LIGHT IN GALLEY IAW AMM 33-51-10. OK FOR SVC.SDR AALA201704179035Battery Pack · dischargedAIRCRAFT NOT GROUNDED. EMERGENCY LIGHT TEST "FAILED". REPLACED BATTERY PACK ABOVE LT NR 1 DOOR.SDR AALA201704179027Lens · looseAIRCRAFT NOT GROUNDED. 10D EMERGENCY LIGHT COVER NOT SECURED. REPLACED EMERGENCY LIGHT AT SEAT 10D.SDR AALA201704179025Lens · brokenAIRCRAFT NOT GROUNDED. FOUND EMERGENCY LIGHT LENS BROKEN AT L4 DOOR LOWER RIGHT HAND. REMOVED AND REPLACED EMERGENCY LIGHT LENS BROKEN AT L4 DOOR.SDR SWAA2017041713104Lamp · inoperativeR2 DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE LAMP IAW AMM.SDR REXA2017041300502Bulb · inoperativeLEFT WING EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BULB IAW AMM 33-51-15. OPS CHECKED GOOD.SDR DALA2017041703129Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED. REPLACED THE LENS.SDR DALA2017041303023Battery Pack · faultedWHILE COMPLETING WC 0591-0204 FOUND EPSU BATTERIES WL12 AND 13 FAULTY. REPLACED BATTERIES WL12 AND 13. LP 9699379SDR DALA2017041403022Power Supply · faultedDURING B CHECK, FOUND EPSU 16WL AND 13WL FAULTY. REPLACED EPSU 13WL AND 16WL.SDR DALA2017041403017Lens · unsecureSEAT 1C MOUNTED EMERGENCY LIGHT LENS LOOSE. SECURED THE LENS.SDR SIMA20170413002Lamp · inoperativeRIGHT CENTER FUSELAGE FAIRING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-10.SDR DALA2017041302978Battery Pack · inoperativeCEILING EMERGENCY LIGHTS AT ROWS 23 THROUGH 25 INOPERATIVE. REPLACED THE BATTERY PACK B5104 IAW AMM 33-53. CHECKED GOOD.SDR YENA201704130253Epsu · failedFOUND L4 AND R4 LOWER EMERGENCY LIGHTS INOPERATIVE. R & R THE EPSU 13WL AND EPSU BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR YENA201704130252Battery · failedFOUND L4 AND R4 LOWER EMERGENCY LIGHTS INOPERATIVE. R & R THE EPSU 13WL AND EPSU BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR AALA20170414006Lens · damagedG2 GALLEY AISLE EMERGENCY LIGHT BASE AND LENS DAMAGED. R&R G2 GALLEY EPL LIGHT ASSY, OPS CHECK GOOD IAW AMM 33-51-14. AIRCRAFT IN BASE MAINTENANCE.SDR SWAA2017041713155Light · damagedRIGHT EMERGENCY LIGHT STRIP DAMAGED AT ROW 1. R & R THE LIGHT IAW AMM.SDR SWAA2017041713154Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R & R THE BATTERY IAW AMM.SDR SWAA2017041713153Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R & R THE BATTERY IAW AMM.SDR SWAA2017041713147Sign · looseFORWARD ENTRY DOOR EMERGENCY EXIT SIGN FOUND LOOSE. SECURED THE SIGN IAW SIP.SDR SWAA2017041713136Lens · discoloredRIGHT OVERWING EMERGENCY LIGHT LENS DISCOLORED. R & R THE LENS IAW MM.SDR SWAA2017041713133Lens · looseOVERHEAD EMERGENCY LIGHT LENS LOOSE AT ROW 2. SECURED THE LENS IAW AMM.SDR SWAA2017041713125Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R & R THE BATTERY IAW AMM.SDR SWAA2017041713117Light · damagedLEFT EMERGENCY LIGHT STRIP DAMAGED AT ROW 1. R & R THE LIGHT IAW AMM.SDR SWAA2017041713098Lamp · inoperativeRIGHT FORWARD OUTSIDE EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW SIP.SDR R61A201704120281Light · detachedGREEN FLOOR LIGHTING STRIP IS COMING OUT OF FLOOR. SECURED THE LIGHT IAW AMM 25-24-01.SDR DALA2017041403123Battery Pack · inoperativeNR 2 GALLEY CEILING EMERGENCY LIGHTS ARE INOPERATIVE. REPLACED THE BATTERY IAW AMM 33-57. OPS CHECKED GOOD.SDR HNAA2017041700119Light · out of positionONE CABIN FLOOR EMERGENCY LIGHT IS MISSING, SUSPECT IT TO BE UNDER THE FLOOR. REMOVED CENTER FLOOR FROM ROWS 1-12 FOUND LIGHT UNDER FLOOR AT ROW 12. SECURED LIGHTS AND SECURED THE FLOOR PANELS FROM ROW 1-12 WITH RETAINED HARDWARE.SDR HNAA2017041700118Bulb · burned outCABIN FLOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR AALA201704139030Light · missingEMERGENCY EXIT PLACARD MISSING AT DOOR 1R. REPLACED EMERG EXIT SIGN LIGHT ASSY AT DOOR 1R. PERFORMED OPS TEST IAW M/ M 33-51-01. GND TEST NML. THE AIRCRAFT WAS NOT GROUNDED.SDR ASAA2017041220447Lens · detachedEXIT LIGHT COVER NEAR L1 DOOR DETACHED. ACFT GROUNDED. REATTACHED EXIT LIGHT COVER NEAR L1 DOOR. OK FOR SERVICE.SDR SIMA20170412001Light · inoperativeMID CABIN OVERHEAD EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE MID CABIN CEILING EMERGENCY LIGHT.
Back to JASC 3350