N517AU, cancelled Feb 12, 2009
Service difficulty reports · 103
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 n_number = 'N517AU' AND deregistration_id = 'N517AU-2009-02-12' 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 n_number = 'N517AU' AND deregistration_id = 'N517AU-2009-02-12' 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 USAA920081407Skin · crackedCLT- MAJOR REPAIR - CRACKED FUSELAGE SKIN AT BS 219.8 AT PILOTS WINDOW UPPER CORNER, REPAIRED FUSELAGE SKIN AT BS 219.8 AT PILOTS WINDOW UPPER CORNER IAW B737 SRM 53-10-01, REPAIR 10. (A)SDR SB07094Windshield · crackedBNA FLT 1552 - DURING CRUISE, CREW REPORTED THE CAPTAIN'S L1 WINDSHIELD BEGAN TO ARC AND THEN SHATTERED. CREW ACCOMPLISHED QRH PROCEDURES. PRESSURIZATION REMAINED NORMAL. OUTER PANE WAS CONFIRMED SHATTERED, WHEREAS, INNER PANE WAS NOT AFFECTED. FLIGHT LANDSDR USAA920070886Skin · crackedCLT - MAJOR REPAIR - C-3 CHECK - NR 6006731, AFT CARGO DOOR EXTERIOR SKIN CRACKED AT UPPER CORNER OF HANDLE CUTOUT. REPLACED AFT CARGO DOOR IAW USAIRWAYS JOB CARD J3-57-52301.SDR USAA070652Intercostal · crackedBS 294.5 & S76 HAS CRACK. REPLACED INTERCOSTAL IAW 51-10-02, DEFECT SIZE: .0625 INCH.SDR USAA070653Intercostal · crackedBS 294.5, S-12L, WEB INTERCOSTAL HAS CRACK. REPLACED INTERCOSTAL IAW SRM 51-10-02, DEFECT SIZE: .25 INCH.SDR USAA070654Intercostal · crackedBS 294.5, S-15L, WEB INTERCOSTAL HAS CRACK. REPLACED INTERCOSTAL IAW SRM 51-10-02, DEFECT SIZE: 1 INCH.SDR USAA070655Skin · crackedBS 407 RBL 1.5, RADIUS ALTIMETER CUTOUT HAS CRACK. INSTALLED REPAIR DOUBLER, FILLER & ADIO ALT PER T/R 53-30-71, DEFECT SIZE: .25.SDR USAA070656Stringer · crackedBS 360 STR 15L HAS CRACK. DEFECTIVE PART REPLACED WITH IDENTICAL PER SRM 51-10-02, DEFECT SIZE: .5 INCH.SDR USAA070657Intercostal · crackedSTA 294.5, S-11L, INTERCOSTAL WEB, CRACK IN RADIUS. REMOVED WEB, FABRICATED NEW & INSTALLED PER DWG 50-07946, SRM 51-10-02, DEFECT SIZE: 0.25 INCH.SDR USAA051618Skin · crackedFOUUND FWD SERVICE DOOR-OUTER SKIN-UPPER HINGE CUT OUT. INSTALLED DOUBLER IAW TR 52-10-13, DEFECT SIZE: .25".SDR USAA051617Skin · crackedFOUND FWD SERVICE DOOR-OUTER SKIN- LOWER HINGE CUT OUT. INSTALLED DOUBLER IAW TR 52-10-13, DEFECT SIZE: .25".SDR SB05171Sill · damagedENROUTE, THE FLIGHT LOST PRESSURIZATION AFTER REACHING CRUISE ALTITUDE. THE FLIGHT DESCENDED TO 10,000 FEET. THE OXYGEN MASKS DID NOT DEPLOY. THE FLIGHT DIVERTED AND LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED THE FORWARD OUTFLOW VALVE AS A PRECASDR SB05155Controller · faultyFA REPORTED A LOUD SQUEAK AND VIBRATION FROM FIRST CLASS CABIN FLOORBOARDS. AT THAT TIME, THE CABIN PRESSURE BEGAN CLIMBING. CABIN ROSE TO APPROX 11,000 FEET. CREW INITIATED DESCENT TO 10,000 FEET AND PERFORMED QUICK REFERENCE HANDBOOK PROCEDURES. CREW REPORTSDR SB05138Outflow Valve · faultyBWI - FLT1243 - DURING CRUISE, CREW REPORTED A LOUD BUZZING NOISE COMING FROM CABIN AND ALMOST INSTANTLY FELT PRESSURE IN THEIR EARS. CREW FOUND CABIN PRESSURE CLIMBING 3,000 TO 4,000 FT PER MINUTE. OUTFLOW VALVE WAS CLOSED PER PROCEDURES WITH NO AFFECT ON PSDR SB05091Odor · detectedDCA FLT1285 DUE TO AN INOPERATIVE APU, A GROUND AIRSTART WAS ACCOMPLISHED PRIOR TO DEPARTURE IN SYR. AN OBNOXIOUS ODOR BECAME PRESENT IN THE COCKPIT AND CABIN SHORTLY THEREAFTER. AFTER DEPARTURE, THE CAPTAIN SENT AN ACAR'S MESSAGE STATING THE ODOR CLEARED SDR USAA050364Skin · crackedPIT - RON - SKIN, 4.500 INCH CRACK, STA 727A, 727B, STR 22R. INSTALLED DOUBLER IAW SRM. (K)SDR USAA050090Frame · crackedPIT - Q6 - FRAME, .0625 INCH CRACK, CRACK RADIATING FROM RIVET AT STA 827S-9R. INSTALLED DOUBLER IAW SRM 53-10-20A. (K)SDR USAA050108Skin · crackedPIT - Q6 - SKIN, 2.2500 INCH CRACK; FUSELAGE SKIN AT FWD SVC DOOR CUT OUT AFT; CUT OUT CRACKED AREAS AND INSTALLED REPAIR DOUBLERS IAW SRM 53-10-01 AND EA 79657. (K)SDR USAA050092Plate · fatiguedPIT - Q6 - MAIN LANDING GEAR FG; INSTALLATION OF REAR SPAR FATIGUE PLATE; INSTALLATION OF REAR SPAR FATIGUE PLATE; LT REAR SPAR UPPER CHORD BETWEEN WBL 150 AND 126. FABRICATED DOUBLER AND INSTALLED IAW EA 79629. (K)SDR USAA050047Web · crackedPIT - FOUND WEB CRACKED 1 INCH, STATION 664 8 INCHES OUTBOARD OF LT INVD SEAT TRACK. PRESSURE DECK WEB REPAIR PER SRM 53-60-51. (M)SDR USAA050119Floor Support · corrodedPIT - Q6 - FLOOR SUPPORT, 16 INCH WIDE SPREAD CORROSION; CORROSION; LEVEL 1; TASK C53-107-01, 02; BS 312 AND 328 BL0 RT 10 INCHES; DEFECTIVE PART REPLACED WITH IDENT PART IAW SRM 51-40-02. (K)SDR USAA050118Sill · corrodedPIT - Q6 - DOOR SILL, 1 INCH X 1 INCH AREA, CORROSION; LEVEL 1; TASK NR C53-107-01, FWD SVC DOOR SILL (AFT) AT NUT PLATE. REPAIRED IAW SRM. (K)SDR USAA050117Floor Support · corrodedPIT - Q6 - FLOOR SUPPORT, 1 INCH DIA AREAS ( 8 EA ); CORROSION; LEVEL 1; TASK NR C53-107-02; FLOOR SUPPORT BS 967-986.5, RBL 17 INCHES. DEFECTIVE PART, REPLACED WITH IDENT PART IAW SRM AND MFG DWG. (K)SDR USAA050116Web · corrodedPIT - Q6 - SHEAR WEB, 2 INCH X 2 INCH AREA, CORROSION; LEVEL 1; TASK NR C53-202-01, BS 1016, LBL 16 SHEAR WEB; DEFECTIVE PART REPLACED WITH IDENT PART IAW SRM 51-10-02 AND MFG DWG. (K)SDR USAA050115Gate · corrodedPIT - Q6 - AFT ENTRY LWR EXHAUST, 1 INCH X 1 INCH AREA (4 PLACES) CORROSION; LEVEL 1; TASK NR C53-107-01; LOWER EXHAUST GATE LOWER IB SURFACE. DEFECTIVE PART REPLACED WITH IDENT PART NR. (K)SDR USAA050114Floorbeam · corrodedPIT - Q6 - FLOORBEAM, .5 INCH X .5 INCH, CORROSION; LEVEL 1; TASK NR C53-107-01; TOP SURFACE OF FLOORBEAM 20 INCH RT OF BL0, BS312; INSTALLED BEAM DOUBLER IAW SRM. (K)SDR USAA050113Floor Support · corrodedPIT - Q6 - FLOOR SUPPORT, 20 INCH X 1.5 INCH AREA, CORROSION; TOP OF FLOOR SUPPORT BETWEEN STA 947-967, RBL 46; DEFECTIVE PART REPLACED WITH IDENT PART IAW SRM 51-40-02-1 AND 51-40-03. (K)SDR USAA050112Skin · delaminatedPIT - Q6 - SKIN, 6.5 INCH X 4.5 INCH AREA DELAMINATION; NR 5 SLAT OB END; REMOVED TOP SKIN AND CORE AND REPLACED IAW SRM. (K)SDR USAA050111Skin · delaminatedPIT - Q6 - SKIN, 4 INCH X 4 INCH AREA DELAMINATION; NR 5 SLAT IB END; REMOVED TOP SKIN, CORE, REPLACED CORE AND TOP SKIN IAW SRM 57-70-10. (K)SDR USAA050110Skin · delaminatedPIT - Q6 - SKIN, 4 INCH X 4 INCH AREA DELAMINATION; NR 2 SLAT, OB END; REMOVED TOP SKIN, CORE, REPLACED CORE, TOP SKIN IAW SRM 51-70-10. (K)SDR USAA050109Skin · delaminatedPIT - Q6 - SKIN - CORE, 4 INCH X 4 INCH DELAMINATION, NR 2 SLAT IB END. REMOVED DAMAGE, INSTALLED INTERNAL DOUBLER, CORE, TOP EXT DOUBLER IAW SRM 51-70-10. (K)SDR USAA050107Structure · crackedPIT - Q6 - NR 2 SLAT, .1250 INCH CRACKS (3 EA); LOWER T CHORD AFT ROW OF FASTENERS AT ACTUATOR MOUNT; INSTALLED DOUBLER IAW SRM 57-43-01, FIG 206. (K)SDR USAA050106Intercostal · crackedPIT - Q6 - INTERCOSTAL, .5 INCH CRACK; LT AND RT SIDES OF FWD ATTACH ANGLE AND INTERCOSTAL BELOW CABIN FLOOR STA 254 BL0. MANUFACTURED NEW INTERCOSTAL IAW MFG DWG 65-45833 AND SRM 51-20-01, 51-40-00. (K)SDR USAA050105Frame · crackedPIT - Q6 - FRAME, .2500 INCH CRACK; BS 907 FRAME BETWEEN STRINGERS S-1 AND S-2R. DOUBLERS INSTALLED IAW SRM 53-00-07, FIG 201 WITH MINOR DEVIATION IAW EA 79620. (K)SDR USAA050104Channel · crackedPIT - Q6 - L CHANNEL, 2 INCH LONG BETWEEN NUT PLATES CRACKED; S5A STRINGER LT SIDE STA 1140 TO 1145. REMOVED AND REPLACED STRINGER AND DOUBLERS IAW SRM 53-00-01 AND FIG 221 AND TYP REP 53-80-40. (K)SDR USAA050103Stiffener · crackedPIT - Q6 - STIFFENER; .5 INCH CRACK; FLOORBEAM STIFFENER BS 328, LBL 28. DEFECTIVE PART REPLACED WITH IDENT PART IAW SRM 51-10-02 AND MFG DWG. (K)SDR USAA050102Skin · crackedPIT - Q6 - FWD ENT DOOR, .1250 INCH CRACKS (3 EA); INTER SKIN AND FRAME AT NR 6 AFT DOOR STOP AND INTER SKIN AT NR 7 DOOR STOP AFT. INSTALLED DOUBLERS IAW TYP. REP. 52-10-16. (K)SDR USAA050101Skin Panel · chafedPIT - Q6 - SKIN PANEL, .015 INCH X 4 INCH LONG; CHAFED; FWD OF STA 867 TO JUST AFT OF STA 887, STR 2L AND 2R. DOUBLER INSTALLED AND TRIPLER IAW TYP. REP.53-30-02, REV B. (K)SDR USAA050100Frame · damagedPIT - Q6 - FRAME, .1562 INCH IN RADIUS (2 HOLES); STA 440 S-24L (FWD CARGO BIN); INSTALLED FABRICATED REPAIR DOUBLER IAW SRM. (K)SDR USAA050099Structure · crackedPIT - Q6 - AFT CARGO DOOR, .4375 INCH CRACK; BOTTOM OUTER T-CHORD FASTENER HOLE, LOWER AFT END; INSTALLED FABRICATED PART IAW SRM. (K)SDR USAA050098Stiffener · crackedPIT - Q6 - STIFFENER, .5 INCH CRACK; STIFFENER CRACKED BETWEEN S-12R AND S13R AT STA 291. DEFECTIVE PART REPLACED WITH IDENT PART IAW SRM AND DWG. (K)SDR USAA050097Frame · crackedPIT - Q6 - FRAME, .2500 INCH LENGTH; FRAME TO SKIN BRACKET AREA IN FRAME STA 360, STR 14R. INSTALLED DOUBLER REPAIR IAW SRM. (K)SDR USAA050096Angle · crackedPIT - Q6 - L ANGLE, 1.2500 INCH CRACK; L ANGLE FOR 360 FRAME AT STR 14L. MANUFACTURED NEW L ANGLE IAW SRM. (K)SDR USAA050095Structure · crackedPIT - Q6 - NR 1 SLAT, .1250 INCH CRACKS-2 EA; LOWER T-CHORD, AFT ROW OF FASTENERS, APPROX 40 INCHES FROM IB EDGE. INSTALLED DOUBLER IAW SRM. (K)SDR USAA050094Strap · crackedPIT - Q6 - STRAP, CRACKED IN HALF, 3 INCH CRACK; LOWER FLOORBEAM STA 312 AND 328 LBBL 12. DEFECTIVE PART REPLACED WITH IDENT PART IAW DWG. AND SRM. (K)SDR USAA050093Skin · crackedPIT - Q6 - RIVET HOLES, .1250 INCH TO .2500 INCH - 7 RIVET HOLES, CRACKED; LWR SKIN AFT FASTENER ROW CENTERED ON SLAT ACT. AREA. INSTALLED DOUBLER IAW SRM 57-43-01.(K)SDR USAA050091Frame · crackedPIT - Q6 - FRAME - .1250 INCH CRACK, RADIATING FROM RIVET HOLE AT STA 907 S-9R. DOUBLER INSTALLED IAW SRM 53-10-20A.SDR USAASB03110Power Supply · dischargedCLT - FOUND AFT SECTION OF AISLE EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY. (M)SDR USAASB02241A/C Pack · contaminatedALB - FLT 1544 - IMMEDIATELY AFTER TAKEOFF, CREW REPORTED A STRONG BURNING ODOR THROUGHOUT CABIN. AT APPROXIMATELY 5,000 FT, THE SMOKE ALARMS SOUNDED. CAPTAIN DECLARED AN EMERGENCY AND ELECTED TO DIVERT TO ALB. FLIGHT LANDED WITHOUT INCIDENT AND TAXIED TO TSDR USAASB02238Engine · odorPILOT REPORTED THE AFT LAVATORY SMOKE DETECTORS SOUNDED DUE TO AN OIL ODOR IN THE CABIN. FLIGHT LANDED AT EWR WITHOUT FURTHER INCIDENT. MAINTENANCE INSPECTED DUCTING AND ISOLATED OIL ODOR COMING FROM RT ENGINE. (RT ENGINE RECENTLY EXPERIENCED AN IMPACT WITH
Back to N517AU, cancelled Feb 12, 2009