N590AA
Service difficulty reports · 109
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 = 'N590AA' AND registry_match = 'registration' 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 = 'N590AA' AND registry_match = 'registration' 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 AALA20131231001Portable Light · inoperativeLT NR 1 DOOR PORTABLE EMERGENCY LIGHT INOPERATIVE. REPLACED LT NR 1 DOOR PORTABLE EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20121113011Doubler · corrodedAFT CARGO INNER SKIN DOUBLER HAS CORROSION FROM STATIONS 1155 TO 1212. INSTALLED DOUBLER ON INNER SKIN DOUBLER PER EA MD80-53-027062.SDR AALA20121002005Bungee Cylinder · brokenDFW - CREW REPORTED DURING GEAR RETRACTION RIGHT GEAR UNSAFE INDICATION. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND RIGHT MAIN LANDING GEAR BUNGEE CYLINDER FRACTURED AT UPPER ATTACH POINT. REMOVED ASDR AALA20120823003Mount · corrodedCENTER G-1 GALLEY MOUNT AT STATION 160 CORRODED. INSTALLED NEW G1 GALLEY MOUNT PER AARD 51-10-00-5.SDR AALA20120822008Cusp Web · corrodedLOWER CUSP UNDER G-1 GALLEY HAS CORROSION AT DRAIN. INSTALLED REPAIR DOUBLER FROM RIGHT BUTTLINES 39.5 TO 52 AND STATIONS 149 TO 160 PER AARD 53-20-00-16.SDR AALA20110814DFW01Warning System · activatedDFW - CREW REPORTED TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED AFTER TAKEOFF. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. CURRENTLY UNDERGOING MAINTENANCE FOR MULTIPLE LEAKS. SYSTEM GROUND CHECK NSDR AALA20101120DFW01Switch · defectiveDFW - CREW REPORTED DURING CLIMB TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED. POWER WAS REDUCED AND LIGHT WENT OUT BUT WHEN POWER WAS APPLIED TO ENGINES LIGHT CAME BACK ON. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOSDR AALA20100722LGA01Battery Pack · dischargedSEAT MOUNT ESCAPE LIGHTS INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20091208TUL02Frame · crackedFRAME AND STIFFENER CRACK AT LONGERON 2 RIGHT AT STATION 1418. INSTALLED REPAIR DOUBLERS PER ENGINEERING AUTHORIZATION MD80-53-0082 60.SDR AALA20091204TUL01Skin · corrodedCORROSION ON SKIN AT MID CARGO STATION 726 TO 731, LONGERON 29 RIGHT TO 30 RIGHT. REMOVED CORROSION AND REPAIRED WITH EXTERNAL DOUBLER IAW SRM 53-04-00 FIG 12B, SHT 6.SDR AALA20091203TUL07Cusp Web · crackedCUSP CRACKED AT LIGHTENING AT STATION 220, RIGHT SIDE. REMOVED AND REPLACED CUSP PER AARD 53-20-00-16.SDR AALA20091203TUL04Beam · corrodedCORROSION AT MID CARGO ALONG LOWER DOOR CUTOUT BEAM AT STATION 636 TO 655. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-03.SDR AALA20091202TUL13Attach Angle · crackedFUSELAGE TO VERTICAL STABILIZER ATTACH ANGLE CRACKED. REMOVED DAMAGE AND INSTALLED REPAIR ANGLE PER AARD 53-10-00-2.SDR AALA20091202TUL12Cusp Web · crackedCRACK IN LEFT CUSP AT STATION 215. INSTALLED NEW CUSP SHEET.SDR AALA20091202TUL11Stop Fitting · crackedAFT PRESSURE BULKHEAD JAMB HAS CRACKED STOP. INSTALLED NEW STOP.SDR AALA20091202TUL07Web · corrodedWEB MEMBRANE CUT AT INBOARD OF NUMBER 4 SEAT TRACK AT STATION 218. REPAIRED WEB MEMBRANE PER SRM 53-14-01 AND AARD 53-20-00-16.SDR AALA20091202TUL01Cusp Web · corrodedRIGHT CUSP AT STATION 732 TO 738 CORROSION OUT OF LIMITS. INSTALLED DOUBLER AT STATION 732 TO 738 PER AARD 53-20-00-16.SDR AALA20091201TUL08Cusp Web · corrodedCORROSION OUT OF LIMITS ON CUSP AT STATION 418 LEFT SIDE. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20091201TUL07Cusp Web · corrodedCORROSION ON CUSP OUT OF LIMITS STATION 160. INSTALLED DOUBLERS PER AARD 53-20-00-16.SDR AALA20091201TUL06Cusp Web · corrodedCUSP CORROSION OUT OF LIMITS. INSTALLED CUSP REPAIR PER AARD 51-20-00-16.SDR AALA20091130TUL06Skin · scratchedDEEP SCRATCH IN FUSELAGE AT APPROXIMATELY STATION 245 ABOVE LONGERON 18 LEFT. INSTALLED DOUBLER PER SRM 53-04-02.SDR AALA20091130TUL05Rib · crackedNUMBER 5 LEFT SLAT AT NUMBER 15 OUTBOARD RIB CRACK INDICATION. REMOVED AND REPLACED OUTBOARD ATTACH RIB PER ESO81117.SDR AALA20091130TUL01Rib · crackedNUMBER 5 RIGHT SLAT AT NUMBER 15 OUTBOARD RIB CRACKED. REPLACED CRACKED NUMBER 15 RIB AT NUMBER 5 RIGHT SLAT.SDR AALA20091127TUL02Support · crackedSUPPORT CASTING CRACKED BELOW NUMBER 5 SEAT TRACK AT RIGHT STATION 927. REMOVED AND INSTALLED NEW SEAT TRACK SUPPORT PER SRM 51-01.SDR AALA20091125TUL13Intercostal · crackedINTERCOSTAL ATTACH ANGLE CRACKED BELOW NUMBER 5 SLAT TRACK. REPAIRED PER ENGINEERING AUTHORIZATION MD80-008221 DATED 11/24/09.SDR AALA20091125TUL08Pan · crackedRIGHT WINDOW PAN IS CRACKED AT THE RIGHT FORWARD LOWER CORNER. REMOVED DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20091125TUL07Pan · crackedRIGHT UPPER AFT TAB CRACKED ON WINDOW PAN, STATION 1117. REMOVED DAMAGED SECTION AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20091125TUL02Stop Fitting · crackedAFT CARGO DOOR NR 1 STOP FITTING CRACKED ON AFT SIDE OF DOOR. REMOVED AND REPLACED STOP FITTING PER ESO 80174.SDR AALA2009061000003Battery Pack · dischargedLGA - SEAT EXIT LIGHTS FOR ROW 3 TO ROW 20 INOPERATIVE. REPLACED BATTERY PACK FOR SEAT EXIT LIGHTS FOR ROW 3 TO 20.SDR AALA2009022600001Relay · inoperativeDFW - CAPTAIN ADVISED DISPATCH THAT AT 500FT AGL THE LANDING GEAR WAS IN QUESTION. FLIGHT ABORTED APPROACH. THE CREW DECLARED AN EMERGENCY DID FLY BY OF THE TOWER AND WAS ADVISED THAT THE GEAR LOOKED OK. FLIGHT LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROSDR AALA200800351Battery Pack · inoperativeLGA - EMERGENCY EXIT SIGN LIGHT AT AFT CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY EXIT SIGN LIGHT AT AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070399Accumulator · leakingDFW INFLIGHT - DURING CLIMB CREW COULD SMELL ODOR IN COCKPIT. FLIGHT ATTENDANT REPORTED SMELL AND SMOKE IN CABIN. TURNED PACKS TO COLD AND RETURNED TO DFW AND LANDED WITHOUT INCIDENT. SMOKE CLEARED PRIOR TO LANDING. FOUND LEFT THRUST REVERSER ACCUMULATOR SDR AALA20060235Line · leakingTPA - INFLIGHT AFTER TAKEOFF SMOKE APPEARED IN COCKPIT AND CABIN. RETURNED TO TPA AND LANDED WITHOUT INCIDENT. FOUND OIL LINE LEAKING FROM APU. REPAIRED LINE AND REPLACED BOTH PACKS SOCKS. ACCOMPLISHED PACK BURN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050838Actuator · inoperativeJFK - FLIGHT DIVERTED TO JFK DUE TO THREE RED GEAR WARNING LIGHTS WHEN LANDING GEAR WAS LOWERED. AIRCRAFT LANDED WITHOUT INCIDENT. FOUND LANDING GEAR HANDLE MECHANICALLY BINDING. FREED UP SLIDING ACTION OF HANDLE AND THREE RED LIGHTS EXTINGUISHED. AIRCRAFTSDR AALA20040995Battery Pack · inoperativeDFW - OVERHEAD EMERGENCY LIGHTS AT ROWS 23 THROUGH 26 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS AT ROWS 23 THROUGH 26. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20030555Battery · inoperativeDURING OVERNIGHT MAINTENANCE, FIRST CLASS OVERHEAD EMERGENCY EXIT LIGHTS INOPERATIVE. RESEATED EMERGENCY EXIT LIGHT BATTERY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20020356Beam · corrodedTUL - FOUND CORROSION ON AFT CARGO DOOR BEAM STATION 1155-1212. REMOVED AND REPLACED AFT CARGO DOOR BEAM FROM STATION 1117 TO 1250 PER AARD 53-10-00-3. (M)SDR AALA20020357Frame · crackedTUL - FOUND CANT FRAME AT STATION 1485 HAS CRACKS UNDER AFT STAIR ACTUATOR CASTING ATTACH POINT. CUT OFF DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR PER AARD 53-10-00-33 (CANT FRAME REPAIR). (M)SDR AALA20020347Frame · gougedTUL - FOUND FRAME AT STATION 1401 HAS DEEP GOUGE AT INSTRUMENT AIRLINE ATTACH POINT AT LONGERON 21 RT. INSTALLED REPAIR DOUBLER AT STATION 1401 PER SRM 53-03 PAGE 5. (M)SDR AALA20020344Support · corrodedTUL - FOUND CORROSION ON F/B SUPPORT STATION 1212 L29R-L30. INSTALLED NEW FLOOR SUPPORT AT STATION 1212 L29R TO L30 SRM 51-01. (M)SDR AALA20020348Frame · crackedTUL - FOUND FRAME 1416 CRACKED FROM UNDER FILLER BLOCKS LONGERON 2R AND LONGERON 2L. REMOVED AND REPLACED CRACKED ANGLE FRAME 1416 L5L TO L5R. (M)SDR AALA20020352Web · damagedTUL - FOUND HOLE IN CUSP UNDER NR 6 SEAT TRACK. CUT OUT AND INSTALLED DOUBLER .025 7075 T6 PER AARD 53-00-00-02. (M)SDR AALA20020350Shear Tie · crackedTUL - FUOND TWO SHEAR TIES CRACKED ON AFT SIDE OF FRAME 1433 JUST INBOARD OF STRINGER 3R AND STRINGER 3L. REMOVED AND REPLACED WITH NEW SHEAR TIE PER SRM 53-01. (M)SDR AALA20020346Frame · crackedTUL - FOUND FRAME 1429 SHEAR TIE CRACKED 2 PLACES RIGHT AFT SIDE LONGERON 2 RT. INSTALLED NEW SHEAR TIE SRM 51-01. (M)SDR AALA20020345Stiffener · crackedTUL - FOUND THE VERTICAL STIFFENER ON THE FORWARD SIDE OF AFT PRESS BULKHEAD ABOVE VAULT DOOR IS CRACKED. REMOVED CRACKED STIFFENER AND INSTALLED NEW STIFFENER PER SRM 51-01-00. (M)SDR AALA20020361Rib · tornTUL - FOUND OUTBOARD LEADING EDGE RIB TORN AT AFT UPPER CORNER ON LEFT HORIZONTAL STABILIZER. INSTALLED NEW LEADING EDGE RIB ON LEFT HORIZONTAL STABILIZER OUTBOARD END PER SRM 55-01. (M)SDR AALA20020349Shear Tie · crackedTUL - FUOND FRAME 1429 SHEAR TIE CRACKED LEFT AFT SIDE JUST OUTBOARD OF TAIL TIE FITTING. INSTALLED NEW SHEAR TIE PER SRM 53-01. (M)SDR AALA20020360Skin · damagedTUL - FOUND CREASE IN FUSE SKIN STATION 278 AT LONGERON 26 LT. CUT OUT DAMAGED AREA AND INSTALLED DOUBLER PER SRM 53-04 FIG 12B SHEETS 7-22 AND 35. (M)SDR AALA20020358Floorbeam · damagedTUL - FOUND FLOORBEAM LOWER FLANGE AT 389 RBL 15 DAMAGED FROM CARGO DOOR. CUT OUT DAMAGE AND INSTALLED L-ANGLE DOUBLER PER AARD 53-20-00-21. (M)SDR AALA20020351Web · corrodedTUL - FOUND CORROSION ON LEFT CUSP AT STATION 1155. CUT OUT CORROSION AND INSTALLED DOUBLER PER SRM 53-01 PAGE 18. (M)
Back to N590AA