N510AU, cancelled Jun 4, 2003
Service difficulty reports · 52
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 = 'N510AU' AND deregistration_id = 'N510AU-2003-06-04' 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 = 'N510AU' AND deregistration_id = 'N510AU-2003-06-04' 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 USAASB02154Panel · illuminatedDURING CRUISE, ENROUTE, THE NR1 ENGINE DRIVEN HYDRAULIC PUMP (A) SYSTEM LOW PRESSURE LIGHT ILLUMINATED. FIVE MINUTES LATER, THE NR 2 ENGINE DRIVEN HYDRAULIC PUMP (B) SYSTEM LOW PRESSURE LIGHT ILLUMINATED. HYDRAULIC SYSTEM QUANTITY WAS OK AND HYDRAULIC SYSTEMSDR USA2002F00076Light · failedPILOT REPORTED THE EMERGENCY LIGHTS AT SEAT ROW 10ABC INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LIGHT ASSEMBLY. OPERATIONAL CHECK NORMAL.SDR USAASB01315Battery Pack · dischargedTPA - MAINTENANCE FOUND THE LEFT OVERWING EMERGENCY LIGHT EXTINGUISHES AFTER A FEW SECONDS OF OPERATION. MAINTENANCE REMOVED AND REPLACED THE BATTERY PACK. OPERATIONAL CHECK GOOD. (M)SDR USAASB01241Hydraulic Line · crackedDTW - FLT 1291 - ON CLIMB-OUT FROM DTW, EN ROUTE TO PHL, CAPTAIN REPORTED A FAILURE OF THE 'A' HYDRAULIC SYSTEM ALONG WITH HYDRAULIC QUANTITY LOSS. CAPTAIN DECIDED IT WAS BEST TO RETURN TO FIELD TO DTW. FLIGHT LANDED WITHOUT FURTHER INCIDENT AND WAS TOWED TOSDR USAASB00297Light · failedROA-PIT - FLT 1295 - AFTER LANDING GEAR EXTENSION THE RIGHT MAIN GEAR DOWN LOCK LIGHT DID NOT ILLUMINATE. A VISUAL INSPECTI0N COULD NOT CONFIRM THE LANDING GEAR WAS DOWN AND LOCKED. THE GEAR WAS EXTENDED MANUALLY BUT THERE WAS STILL NO DOWN AND LOCKED INDICASDR USAASB00101Clamp · looseCHS - FLT 1452 - ON CLIMB-OUT FROM RSW, AT FL270, CAPTAIN RECEIVED A RIGHT WING BODY OVERHEAT INDICATION. LIGHT EXTINGUISHED IMMEDIATELY AFTER BLEED SWITCH WAS TURNED OFF. CAPTAIN DESCENDED FLIGHT TO FL250, AND AT THIS POINT, THE ALTITUDE WARNING HORN SOUNDEDSDR USAA000294Keelbeam · crackedTPA - FOUND KEEL BEAM CRACKED, RBL 630 KEEL BEAM. INSTALLED DOUBLER PER SRM 53-60-12. (M)SDR USAASB99135Light · inoperativePHL - PILOT REPORTED THAT THE LOW LEVEL EMERGENCY LIGHTS IN THE AFT SECTION OF THE CABIN, AT ROWS 17-21 ABC, ARE INOPERATIVE. MAINTENANCE FOUND THE SEAT ASSEMBLY AT ROW 17 ABC SHORTING OUT THE LOW LEVEL EMERGENCY LIGHTS. REPAIRED BROKEN WIRES AND REPLACED THSDR USAA990548Keel Beam · corrodedCLT - DURING Q4 CHECK, FOUND .5 INCH BY 14 INCH CORRODED AREA AT RT KEEL BEAM AT BS 710 - BS 724, RBL 6.3, WL 148.5. CORROSION LEVEL 1, CORROSION TASK C53-212-01. REMOVED DAMAGE BY BLENDING/SPOT FACING AND INSTALLED DOUBLER PER EA 64676. (M)SDR USAA990547Bracket · crackedCLT - DURING Q4 CHECK, FOUND 2 INCH CRACK IN LOWER FLANGE AT ANTENNA SADDLE BRACKET AT STATION 727E - 727D. REPLACED SADDLE BRACKET. (M)SDR USAA990546Floor · corrodedCLT - DURING Q-4 CHECK, FOUND 3 INCH CORROSION AT LT LAV FLOOR PAN. CORROSION LEVEL 1, CORROSION TASK NR C53-107-02. NEW WEB INSTALLED PER SRM 51-10-02. (M)SDR USAA990545Angle · corrodedCLT - DURING Q-4 CHECK, FOUND 40 INCH CORROSION AT Z-ANGLE AT BS 947 TO 986. CORROSION LEVEL 1, CORROSION TASK NR C53-107-02. REPLACED Z-ANGLE PER SRM 51-10-02. (M)SDR USAA990544Angle · corrodedCLT - DURING Q-4 CHECK, FOUND 1 INCH BY 39 INCH CORRODED AREA AT Z-ANGLE AT STATION 947 TO 986. CORROSION LEVEL 1, CORROSION TASK NR C53-107-02. REPLACED Z-ANGLE PER SRM 51-10-02. (M)SDR USAA990543Mount · corrodedCLT - DURING Q4 CHECK, FOUND 2 INCH DIAMETER CORRODED AREA AT AFT OUTBOARD LAV MOUNT AT STATION 1012, RBL 37, FLOOR LEVEL. CORROSION LEVEL 1, CORROSION TASK NR C53-107-02. REPLACED SUPPORT MOUNT PER SRM 51-10-02. (M)SDR USAA990542T-Cap · corrodedCLT - DURING Q-4 CHECK, FOUND .5 INCH CORRODED AREA SEVERAL PLACES AT T-CAP AT BS 1016 LBL 28-33. CORROSION LEVEL 1. INSTALLED T-CAP REPAIR PER SRM 53-00-51 FIG 202. (M)SDR USAA990541Strap · corrodedCLT - DURING Q-4 CHECK, FOUND 2 INCH BY 14 INCH AREA OF CORROSION AT STRAP AT STATION 1016 TO 1038, WL 3 FLOOR LEVEL. CORROSION LEVEL 2, CORROSION TASK NR C53-107-02. REPLACED STRAP WITH IDENTICAL PAR PER SRM 53-60-51. (M)SDR USAA990540Beam · corrodedCLT - DURING Q4 CHECK, FOUND PREVIOUS BLEND OUT TOP OF T-CAP ON BEAM AT STATION 328 LBL 49, WL 208. INSTALLED REPAIR DOUBLERS AND SPLICE OT CAP PER SRM 53-10-51. (M)SDR USAA990539Mount · corrodedCLT - DURING Q-4 CHECK, FUOND 2 INCH DIAMETER CORRODED AREA IN FORWARD INBOARD LAV MOUNT AT STATION 993 RBL 19 FLOOR LEVEL. CORROSION LEVEL 1. CORROSION TASK NR C53-107-02. DEFECTIVE PART REPLACED WITH IDENTICAL PART NUMBER PER SRM 51-10-02. (M)SDR USAA990538Floorbeam · corrodedCLT - DURING Q-4 CHECK, FOUND SEVERAL 1 INCH DRAIN CORRODED AREAS IN FLOORBEAM AT STATION 986.5 FROM LEFT CREASE BEAM TO RIGHT CREASE BEAM FLOOR LEVEL. CORROSION LEVEL 1, CORROSION TASK NR C53-107-2. REPLACED BEAM 'T' CAP PER TR 53-10-05. (M)SDR USAA990537Clip · crackedCLT - DURING Q4 CHECK, FOUND 1 INCH CRACK IN RADIUS OF VERTICAL FLANGES AT ATTACH CLIP/BRACKETS AT LBL 2 AND RBL 2 AT STATION 727D. DEFECTIVE PART REPLACED WITH IDENTICAL PART NUMBERS PER SRM 51-10-02. (M)SDR USAA990536Frame · crackedCLT - DURING Q-4 CHECK, FOUND .125 INCH CRACK AT FRAME STATION 400 BETWEEN STRINGER 8L - STRINGER 9L (OVERHEAD BIN ATTACH). INSTALLED DOUBLER REPAIR PER SRM 53-00-07 AND EA 64581. (M)SDR USAA990535Frame · crackedCLT - DURIGN Q-4 CHECK, FOUND .12 5INCH CRACK AT FRAME STATION 440 BETWEEN STRINGER 8L - STRINGER 9L (OVERHEAD BIN ATTACH). INSTALLED DOUBLER REPAIR PER SRM 53-00-07 AND EA 64581. (M)SDR USAA990534Frame · crackedCLT - DURING Q-4 CHECK, FOUND FUSELAGE FRAME CRACKED .200 INCH IN LENGTH, THREE (3) HOLES AT CLIP ATTACH ON FRAME. REMOVED DAMAGE AND INSTALLED DOUBLER PER SRM 53-00-07, AND EA 64581. (M)SDR USAA990533Clip · crackedCLT - DURING Q-4 CHECK, FOUND .125 INCH CRACK IN CLIP AT STATION 380, TOP CENTER CLIP (STRINGER TO FRAME ATTACH CLIP). DEFECTIVE PART REPLACED WITH IDENTICAL PART NUMBER PER SRM 51-10. (M)SDR USAA990532Bracket · crackedCLT - DURING Q-4 CHECK, FOUND .25 INCH CRACK AT ANTENNA BRACKET AT 727 D TO E. INSTALLED NEW PART, IDENTICAL NUMBER PER SRM 51-10-02. (M)SDR USAA990531Angle · crackedCLT - DURIGN Q-4 CHECK, FOUND 2 INCH CRACK (FASTENER HOLE TO HOLE) AT LOWER END OF BS 618 LEFT FRAME INNER CHORD ANGLE. DEFECTIVE PART REPLACED WITH IDENTICAL PART NUMBER PER SRM 51-10-02. (M)SDR USAA990476Floorbeam · corrosionCLT - DURING Q-4 CHECK, FOUND 1.5 INCH BY .5 INCH CORRODED AREA ON FLOORBEAM AROUND FLOORBOARD HOLE AT BS 412 BL 0. CORROSION LEVEL 1. INSTALLED STRAP ON AFT SIDE PER SRM 53-10-51. (M)SDR USAA990460Frame · crackedCLT - DURNG Q-4 CHECK, FOUND .125 INCH CRACK IN FRAME AT STATION 400 BETWEEN STRINGER 8R - STRINGER 9R (O/HEAD BIN ATTACH). INSTALLED DOUBLER PER SRM 53-00-07 AND EA 64581. (M)SDR 99ZZZM404Brackets · crackedCLT - DURING Q4 CHECK, FOUND 1 INCH CRACK IN RADIUS OF VERTICAL FLANGES AT ATTACH CLIP/BRACKETS AT LBL 2 AND RBL 2 AT STATION 727D. DEFECTIVE PART REPLACED WITH IDENTICAL PART NUMBERS PER SRM 51-10-02. (M)SDR USAASB98269Socket · failedPIT - MAINTENANCE FOUND THE EMERGENCY FLOOR TRACK LIGHTING AT SEAT ROW 22 INOP. MAINTENANCE REMOVED AND REPLACED THE LIGHT SOCKET AT SEAT ROW 22 FLOOR TRACK LIGHT. OPERATIONAL CHECK GOOD. (M)SDR USAASB98210Light · inoperativeCLT - PILOT REPORTED THAT THE SEAT MOUNTED EMERGENCY EXIT LIGHT AT ROW 12 IS INOP. MAINTENANCE REMOVED AND REPLACED TWO LAMPHOLDER ASSEMBLIES AT SEAT ROW 12. OPERATIONAL CHECK GOOD. (M)SDR USAASB98123Light · inoperativeTPA - DURING B-CHECK, MAINTENANCE FOUND THE EXTERIOR EMERGENCY LIGHT AT THE AFT SERVICE DOOR INOP. MAINTENANCE FOUND THE LIGHT SOCKET WAS BROKEN DUE TO EXCESSIVE CORROSION. REPLACED ENTIRE LIGHT ASSEMBLY. OPERATIONAL CHECK GOOD. (M)SDR USAASB97341Seal · failedCLT - FLT 81 - SHORTLY AFTER LEVELING OFF AT FL330, AIRCRAFT EXPERIENCED A RAPID DECOMPRESSION. CREW DECLARED AND EMERGENCY, DESCENDED TO 10,000 FT AND RETURNED TO FIELD TO CLT. PASSENGER OXYGEN MASKS DEPLOYED AND OXYGEN GENERATORS ACTIVATED. FLIGHT LANDED SDR USAASB97319Wire Harness · failedLAX - FLT 36 - AT DEPARTURE TIME, CREW REPORTED THAT ONE FLOOR LEVEL EMERGENCY LIGHT IN THE FORWARD CABIN WAS INOP. AIRCRAFT WAS RELEASED FOR CONTINUED SERVICE PER MEL. MAINTENANCE REMOVED AND REPLACED A PORTION OF THE HARNESS AND THE LAMP HOLDER. OPS CHECKSDR USAASB97309Adc · failedPIT - FL 152 - SHORTLY AFTER TAKEOFF, THE AUTO-PILOT DISENGAGED, THE FIRST OFFICERS AIRSPEED DECREASED, THE STALL WARNING SOUNDED AND THE STICK SHAKER ACTIVATED. FLIGHT RETURNED TO PIT AND LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED THE RIGHT AIR DSDR USAASB97311Battery · dischargedPHL - MAINTENANCE FOUND A STRIP OF EMERGENCY LIGHTS IN THE FORWARD CABIN INOP. MAINTENANCE REMOVED AND REPLACED THE BATTERY AND CHARGER ASSEMBLY. OPS CHECK GOOD. (M)SDR 97ZZZM1171Charger · inoperativePHL - MAINTENANCE FOUND A STRIP OF EMERGENCY LIGHTS IN THE FORWARD CABIN INOP. MAINTENANCE REMOVED AND REPLACED THE BATTERY AND CHARGER ASSEMBLY. OPS CHECK GOOD. (M)SDR USAASB97282Wire · brokenCLT - FOUND FLOOR TRACK LIGHTING AT ROW 3 INOPERATIVE. MAINTENANCE REPAIRED A BROKEN WIRE. OPERATIONAL CHECK GOOD. (M)SDR USAASB97278Wire · brokenORD - FORWARD 4 EMERGENCY FLOOR LIGHTS INOPERATIVE. MAINTENANCE REPAIRED A BROKEN WIRE. OPERATIONAL CHECK GOOD. (M)SDR USAASB97271Socket · failedCLT - MAINTENANCE FOUND THE FLOOR TRACK EMERGENCY LIGHTING INOPERABLE AT ROWS 9 AND 18. MAINTENANCE REMOVED AND REPLACED THE LIGHT SOCKET (PN 08169-1) AT ROW 9 AND RELAMPED THE LIGHT (PN 013071BPEGPL) AT ROW 18. OPS CHECK GOOD. (X)SDR USAASB97242Battery Pack · failedMIA - EMERGENCY EXIT LIGHTS ROW 18 (FLOOR) INOPERATIVE. REPLACED BATTERY PACK. OPERATIONAL CHECK OK. (X)SDR USAASB97137O-Ring · failedBWI - FLT 2399 - AT FL 210, THE NR 1 ENGINE A-SYSTEM HYDRAULIC LOW PRESSURE LIGHT ILLUMINATED. CAPTAIN SHUT DOWN THE NR 1 ENGINE HYDRAULIC PUMP AND MAINTAINED 3,000 PSI AND ONE-FOURTH QUANTITY IN A-SYSTEM HYDRAULICS. FLIGHT DIVERTED TO BWI AS A PRECAUTIONARYSDR USAASB96010Sensor · failedFLT NR 7015 - PIT - AFTER EXTENSION, RED NOSE GEAR LIGHT FAILED TO EXTINGUISH. MAINTENANCE REPLACED THE NOSE GEAR LOCK SENSOR. INDICATIONS NORMAL. (M)SDR USAA950997Floor Beam · corrosionINT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND 2 INCH BY 4 INCH CORROSION BS 947.5 TO BS 967 RBL 45 ON FLOOR BEAM T-CAP. FABRICATED NEW T-CAP 18 INCHES LONG, REPAIRED PER SRM 53-00-51. CORROSION TASK NR C53-107-02. CORROSION LEVEL 2. (M)SDR USAA950996Angle · corrosionINT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND 1 INCH BY 1 INCH CORROSION AT CLIP NUT HOLES, AFT CARGO BIN AFT CENTER BULKHEAD LOWER ATTACH ANGLE. REPLACED ATTACH ANGLE, REPAIRED PER SRM 51-10-02. CORROSION TASK NR C53-202-01, CORR5OSION LEVEL 2. (M)SDR USAA950998Stringer · corrosionINT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND 1 INCH BY 2 INCH CORROSION BS 870 S-21L. INSTALLED FILLER AND DOUBLER, REPAIRED PER SRM 51-70-11 FIG 1. CORROSION TASK NR C53-202-01. CORROSION LEVEL 2. (M)SDR USAA950995Skin · chafedINT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND CROWN SKIN CHAFED UNDER DORSAL FIN CONTACT AREA, S-1 BS 887 TO BS 867. INSTALLED EXT SKIN DOUBLER. REPAIRED PER TR 53-30-03, SRM 53-00-01. (M)SDR USAA950999Dump Shoot Base · corrosionINT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND 3 INCH BY 6 INCH CORRODED AREA AFT CARGO BS 986.50- BS 1006 DUMP SHOOT BASE. INSTALLED NEW BASE PER DRAWING 65-45781, REPAIRED PER BOEING DRAWING 65-45781. CORROSION TASK NR C53-208-01. CORROSION LEVEL 2. (M)SDR USAA950993Stringer · crackedINT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND .5 INCH CRACK BS 500 C PLUS 16, STRINGER 16R. INSTALLED DOUBLER, REPAIRED PER EO 5393X228. (M)SDR USAA950992Stringer · crackedINT - DURING Q-3 CHECK VISUAL, FOUND .5 INCH CRACK BS 500 C PLUS 4 STRINGER 16R. INSTALLED DOUBLER, REPAIRED PER EO 539X228. (M)
Back to N510AU, cancelled Jun 4, 2003