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 AALA20161228031Powerpack · inoperativeAIRCRAFT IN BASE MAINTENANCE. FORWARD CABIN DOOR 1L EMERGENCY LIGHT POWER PACK M33093 FOUND INOPERABLE. REPLACED POWER PACK M33093 PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161228030Powerpack · inoperativeAIRCRAFT IN BASE MAINTENANCE. FORWARD CABIN DOOR 3L EMERGENCY LIGHT POWER PACK M33400 FOUND INOPERABLE. REPLACED POWER PACK M33400 PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161228029Sign · brokenAIRCRAFT IN BASE MAINTENANCE. AFT CABIN 4R DOOR CUTOUT, ATTACHED EXIT IDENTIFIER BASE FOUND BROKEN. REPLACE EXIT IDENTIFIER BASE PER AMM 33-51-01 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161228028Powerpack · inoperativeAIRCRAFT IN BASE MAINTENANCE. AFT CABIN DOOR 1L EMERGENCY LIGHT POWER PACK M33424 FOUND INOPERABLE. REPLACED POWER PACK PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161228027Powerpack · inoperativeAIRCRAFT IN BASE MAINTENANCE. CABIN - DOOR 4R AFT EMERGENCY LIGHT POWER PACK M33409 FOUND INOPERABLE. REPLACED POWER PACK M33409 PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161230013Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT AT SEAT 2A HAS A DETACHED LENS COVER. REPLACED LENS COVER IAW AMM 33-60-98. OPERATIONAL CHECK GOOD.SDR AALA20161230012Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT BY SEAT 26C HAS A DETACHED LENS COVER. SECURED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20161230011Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT BY L1 DOOR IS MISSING LENS COVER. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161230009Lens · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT L4 DOOR HAS A BROKEN LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR ASAA2016122819192Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS M1673, M1670, AND M1695 FAILED DEEP CYCLE TEST. ACFT GROUNDED. REPLACED M1695 EMERGENCY LIGHT BATTERY PACK AND POWER SUPPLY, M1670 BATTERY PACK AND M1695 BATTERY PACK IAW AMM 33-51-06 AND WDM 33-51-13. TESTED - OPS. NORMAL.SDR ASAA2016122819188Light · brokenLIGHTED COVER FOR EXIT LIGHT BROKEN OFF. ACFT GROUNDED. REPLACED EXIT LIGHT ASSY.SDR ASAA2016122819187Battery Pack · inoperativeR1 DOOR EMERGENCY LIGHTS INOPERATIVE. ACFT GROUNDED. REMOVED & REPLACED THE BATTERY PACK, OPS CHECKED GOOD IAW AMM 33-51-06-960-805.SDR ASAA2016122819186Lamp · inoperativeL2 EXTERIOR EMERGENCY SPOTLIGHT INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMP. OPS NORMAL.SDR DALA2016122910162Lens · missingR1 DOOR RED TRACK EMERGENCY LIGHT LENS IS MISSING. REPLACED THE LENS.SDR SWAA2016123010881Lens · looseL1 DOOR EXIT LIGHT LENS LOOSE. SECURED THE LENS IAW MM.SDR SIMA20161228002Power Supply · inoperativeBOTH LT AND RT EMERGENCY LIGHTS UNDER OVERWING EXIT DOORS ARE INOPERATIVE. R & R THE NR 4 POWER SUPPLY AND BATTERY HOLDER ASSY IAW AMM 33-50-04. OPS CHECKED GOOD.SDR SIMA20161228001Battery Pack · inoperativeILLUMINATED EXIT SIGNS AT PAX DOOR AND GALLEY CEILING, AND FWD 2 CABIN OVERHEAD EMERGENCY LIGHTS DO NOT ILLUMINATE. REMOVED AND REPLACED THE NR 1 EPSU BATTERY PACK AND CHARGER IAW AMM 33-51-17. OPS CHECKED GOOD.SDR AALA20161229001Battery Pack · dischargedAIRCRAFT NOT GROUNDED. SEAT MOUNTED EMERGENCY LIGHTS AT SEATS 9D THROUGH 15D ARE VERY DIM. REMOVED AND REPLACED BATTERY PACK M10952 IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA201612299008Lens · missingAIRCRAFT WAS NOT GROUNDED. MISSING SEAT MOUNTED EMERGENCY LIGHT LENS AT ROW 3L. REPLACED LENS PER AMM 33-51-18.SDR AALA201612299005Light · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY LIGHT LENS MISSING AT SEAT 27C. REPLACED SEAT MOUNTED LIGHTS PER AMM 33-51-18.SDR AALA201612299004Light · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY LIGHT LENS MISSING AT SEAT 6C. REPLACED SEAT MOUNTED LIGHT PER AMM 33-51-18.SDR AALA201612299003Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY LIGHT LENS MISSING AT SEAT 8D. REPLACED SEAT MOUNTED LIGHT PER AMM 33-51-18.SDR AALA20161229012Light · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT L1187 AT L1 DOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161229011Light · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT L1191 AT R2 DOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2016122910870Charger · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. R & R BATTERY CHARGER IAW MM.SDR SWAA2016122910863Fuse · inoperativeRIGHT OVERWING EXIT LIGHT INOPERATIVE. R & R BATTERY PACK FUSE IAW MM.SDR JJBA20161228026Bulb · inoperativeEMERGENCY LIGHT ABOVE CABIN DOOR INOPERATIVE. R & R THE BULB. OPS CHECKED GOOD.SDR R61A201612280763Light · unsecureCREW REPORTED THAT THE L2 DOOR WOULD NOT CLOSE. MAINTENANCE FOUND TRIM SCREW LOOSE, SECURED IAW AMM AND L2 DOOR OPS CHECKED GOOD.SDR R61A201612280762Light · missingCREW REPORTED THAT THE EMERGENCY LIGHT STRIP AT ROW 16 WAS MISSING. MAINTENANCE REPLACED THE LIGHT IAW AMM AND OPS CHECKED GOOD.SDR HNAA2016122800349Bulb · inoperativeEMERGENCY LIGHT IS OUT JUST AT OF RIGHT HAND EMERGENCY EXIT. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR MASA2016122812779Lamp · inoperativeROW 8 EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMP.SDR SWAA2016122810861Lens · crackedEMERGENCY EXIT LIGHT LENS CRACKED AT ROW 25 DEF. R & R THE LENS IAW MM.SDR SWAA2016122810858Lens · crackedEMERGENCY EXIT LIGHT LENS CRACKED AT ROW 27 ABC. R & R THE LENS IAW MM.SDR SWAA2016122810844Lens · missingEMERGENCY EXIT LIGHT LENS MISSING AT ROW 23 ABC. INSTALLED THE LENS IAW MM.SDR JJBA20161228024Light · unsecureEMERGENCY LIGHT NEAR GALLEY UNSECURE. SECURED FLOOR EMERGENCY LIGHT. OPS CHECKED SAT.SDR AALA201612289005Light · inoperativeAIRCRAFT WAS NOT GROUNDED. SEAT ROW 11ABC EMERGENCY FLOOR PROX LIGHT INOPERABLE. REMOVED AND REPLACED EMERGENCY FLOOR PROX LIGHT AT ROW 11ABC PER CMM 25-22-52.SDR AALA201612289006Cover · missingAIRCRAFT WAS NOT GROUNDED. MISSING EMERGENCY EXIT LIGHT COVER AT ROW 11 RIGHT SIDE OF AIRCRAFT. REPLACED EXIT LIGHT COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161229009Sign · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT L3 DOOR IS MISSING. REPLACED EXIT SIGN IAW AMM 33-00-00. OPERATIONAL CHECK GOOD.SDR AALA20161229005Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT NEAR FIRST CLASS GALLEY IS MISSING LENS COVER. REPLACED THE LENS COVER IAW AMM 33-51-14. OPERATIONAL CHECKED GOOD.SDR AALA20161229004Lens · missingEMERGENCY EXIT SIGN AT R2 DOOR HAS A MISSING LENS COVER. REPLACED THE LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR SWAA2016122910848Lens · missingRIGHT OVERWING EXIT LIGHT LENS MISSING. R & R LIGHT ASSY IAW MM.SDR SWAA2016122910847Lens · looseL1 DOOR EXIT LIGHT LENS LOOSE. R & R LENS IAW MM.SDR MASA2016122712778Light · inoperativeCEILING FLOOD LIGHT ROW 9 INOPERATIVE.SDR R61A201612270761Light · inoperativeCREW REPORTED THAT THE FLIGHT DECK EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED FLIGHT DECK EMERGENCY LIGHT ASSY IAW AMM AND OPS CHECKED GOOD.SDR SIMA20161227001Inverter · inoperativeEMERGENCY LIGHTS NR 7 AND 8 INOPERATIVE. R & R THE INVERTER IAW AMM 33-50-11. OPS CHECKED GOOD.SDR CALA2016122701181Battery Pack · inoperativeEMERGENCY LIGHTS ABOVE RIGHT OVERWING EXITS INOPERATIVE. R & R THE BATTERY PACK. OPS CHECKED GOOD.SDR CALA2016122701180Lamp · inoperativeEMERGENCY EXIT LIGHT ARMED, BULB ON OVERHEAD PANEL INOPERATIVE. REPLACED THE LAMP. OPS NORMALSDR CALA2016122701177Battery Pack · inoperativeEMERGENCY EXIT LIGHT SIGN AFT OF R3 DOOR AND TWO EMERGENCY CEILING LIGHTS RT SIDE AFT OF R3 DOOR INOPERATIVE. REMOVED AND REPLACED EXIT SIGN AND REPLACED THE LAMPS. ALL LIGHTS STILL INOPERATIVE. WHILE PERFORMING TEST OF EMERGENCY LIGHTS, FOUND THAT THE EXSDR CALA2016122701173Retainer · brokenSEAT 20ABC FWD RED EMERGENCY LIGHT FOUND TO BE INOPERATIVE WITH A BROKEN CONNECTOR ANGLE ON INBOUND. OPS CHECKED. REMOVED AND REPLACED BROKEN ANGLE ASSY AND OPS CHECKED GOOD IAW AMM 33-51-11. PLASTIC RETAINER ANGLE BROKEN, LIGHT ASSY WAS FUNCTIONAL.SDR MASA2016122712775Light · inoperativeALL CABIN EMERGENCY LIGHTS INOPERATIVE.
Back to JASC 3350