N745VJ
Service difficulty reports · 256
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 = 'N745VJ' 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 = 'N745VJ' 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 AALA2019123069002Lock · out of adjustAIRCRAFT WAS NOT GROUNDED: 2L LAV DOOR LOCK GETS STUCK IN THE LOCKED POSITION MAKING IT DIFFICULT TO OPEN FROM THE INSIDE. ADJUSTED 2L LAV DOOR LOCK PER AMM 25-40-00SDR AALA201909129001Windshield · crackedAIRCRAFT WAS GROUNDED: PILOT REPORTS CAPTAINS WINDSHIELD CRACKED ON CLIMBOUT, RETURNED. MAINTENANCE REPLACED CAPTAINS WINDSHIELD ASSEMBLY IAW AMM 56-11-11-400-001-A. PERFORMED ANTI-ICING & DEFOGGING SYSTEM OPERATIONAL TEST IAW AMM 30-42-00-710-001-A.SDR AALA2019080529018Relay · burnedAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS 2EA GFI RELAYS (69QA AND 70QA) SHOW SIGNS OF HEAT DAMAGE, APPEAR BURNED. REMOVED & REPLACED 2EA GFI RELAYS (69QA & 70QA) IAW A319 ESPM: 20-46-50. PERFORMED CENTER TANK PUMPS GFI OPS CHECK IAW AMM 28-18-00. OPS CHECKESDR AALA201907089009Cids · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS LAV E HAS CONTINUOUS SMOKE DETECTOR CHIMES. NO SMOKE NOTED. MAINTENANCE REMOVED AND REPLACED CIDS 1 IAW AMM 23-73-34. FAULT CLEARED, OK FOR SERVICE.SDR AALA201907079017Cids · faultyAIRCRAFT WAS GROUNDED: SMOKE DETECTOR AURAL ALERT FALSE WARNING LAV E MULTIPLE FALSE ALERTS ON DESCENT APPROACH AND LANDING. MAINTENANCE REPLACED CIDS 1 PER AMM 23-73-34 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201907079015Smoke Warning · false activationAIRCRAFT WAS GROUNDED: SMOKE WARNING DISPLAYED IN LAVATORY E, NO ECAM MESSAGE. MAINTENANCE PERFORMED SATISFACTORY OPERATIONAL TEST OF LAVATORY SMOKE DETECTION SYSTEM PER AMM 26-17-00-710-001-A, NO DEFECTS NOTED.SDR AALA201907039010Smoke Warning · false activationAIRCRAFT WAS NOT GROUNDED: SMOKE DETECTOR LAVATORY E ALERT. MAINTENANCE RESET # 1 CIDS DIRECTOR AND PEFORMED SATISFACTORY OPERATIONAL CHECK PER MM 26-16-00.SDR AALA201907029018Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: LAVATORY E SMOKE MESSAGE DISPLAYED ON CIDS PANEL AND CHIMES SOUNDED. MAINTENANCE REPLACED LAVATORY E SMOKE DETECTOR PER AMM 26-17-15.SDR AALA201907019043Control Unit · malfunctionedAIRCRAFT WAS NOT GROUNDED: LAVATORY SMOKE INDICATION ON PANEL AT FLIGHT ATTENDANT STATION, "LAVATORY E" MESSAGE DISPLAYED. NO INDICATION OF SMOKE OR FUMES WENT AWAY. MAINTENANCE RESET SDCU PER TSM 24-00-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201906279007Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: DURING DEPLANING, A LAVATORY SMOKE MESSAGE DISPLAYED ON GALLEY PANEL. NO INDICATION IN COCKPIT OR SMELL FROM EITHER LAVATORIES. MAINTENANCE RESET SDCU PER TSM 24-00-00 AND PERFORMED LAVATORY E SMOKE DETECTOR TEST, NO FAULTS NOTED.SDR AALA2019061109008Brake Sys · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS ON LANDING WITH BRAKE APPLICATION, FELT AS IF THE BRAKES WERE GRABBING & THEN LETTING GO AS IF THE ANTI-SKID WAS GOING ON AND OFF. ACCOMPLISHED OPS TEST OF AUTOBRAKE DECEL RATE ARMING IAW AMM 32-42-00. ALSO ACCOMPLISHED OPSSDR AALA201905179023Hinge Fitting · excess playAIRCRAFT WAS GROUNDED: RIGHT HAND MAIN LANDING GEAR DOOR AFT HINGE BEARING HAS PLAY. REPLACED HINGE FITTING PER CMM 52-81-18.SDR AALA201905179022Hinge Fitting · excess playAIRCRAFT WAS GROUNDED: RIGHT HAND MAIN LANDING GEAR DOOR FORWARD HINGE FITTING BEARING HAS PLAY. REPLACED HINGE FITTING PER CMM 52-81-18.SDR AALA201902069009Switch · inoperativeTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS SWITCH INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT SWITCH 4WL. OPERATIONS CHECK GOOD PER ESPM 20-42-21 AND AMM CH 33-51-00.SDR AALA2018071109018Lamp · dimOVERWING EMERGENCY EXIT SIGNS WAS DIM. REPLACED THE LAMP. OPS CHECKED GOOD.SDR AALA201807099028Light · unknownROW 24 EMERGENCY LIGHT WAS INOPERATIVE. EXAMINED ROW 24 EMERGENCY LIGHT, NO FAULT FOUND. PERFORMED AN OPS CHECK, TESTED GOOD IAW AMM 33-51-00-710-001A.SDR AALA2018060769021Proximity Switch · looseLEFT DOOR EMERGENCY EXIT ECAM MESSAGE DURING FLIGHT, PRESSURE WAS NORMAL. FLIGHT ATTENDANT INSPECTED THE DOOR AND NOTICED THE SMALL ACCESS, LOWER DOOR, WAS LOOSE. MAINTENANCE ADJUSTED THE HANDLE PROXIMITY SWITCH PER AMM 52-71-13, PER TSM 52-21-00-810-800A ASDR AALA201806069033Chiller · odorFLIGHT ATTENDANTS REPORTED AN ELECTRICAL ODOR IN THE AFT GALLEY NEAR THE LEFT AFT SERVICE DOOR. ODOR WOULD COME AND GO. TROUBLESHOT THE GALLEY CHILLER. REMOVED AND REPLACED THE AFT GALLEY CHILLER IAW AMM 25-34-51-400. OPS CHECKED GOOD. OK FOR SERVICE. THE ASDR AALA201804209014Hinge Arm · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION LEFT ELEVATOR HINGE ARM NR 4 ON LEFT HORIZONTAL STABILIZER. REPLACED LEFT ELEVATOR HINGE ARM NR 4 PER EA 278663 AND DRAWING D55182732.SDR AALA201804049009Slide · unserviceableLEFT OVERWING SLIDE FOUND TO BE UNSERVICEABLE. REPLACED THE LEFT OVERWING SLIDE IAW 26C19053012, AND 8834463.SDR AALA201803299017Skin · crackedRIGHT ELEVATOR HAS A CRACK IN THE SKIN. REPLACED THE RIGHT ELEVATOR IAW J/C 26L30027001R.SDR AALA201804039015Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM AT FRAME 68, -Y1160. REPLACED THE FLOORBEAM IAW SRM 51-72-11.SDR AALA201804019005Door Sill · corrodedCORROSION AROUND THE FASTENER HOLES AND TOP OF THE R2 DOOR SILL, INBOARD AND FORWARD OF FRAME 68, Z-500, Y-1300. REPLACED THE DOOR SILL IAW SRM 51-42-11, 51-75-12, AND DRAWING D53480505.SDR AALA201803299005Floor Support · corrodedCORRODED FLOOR SUPPORT, FRAME 68, WATERLINE Z-500, Y765. REPLACED THE FLOOR SUPPORT IAW DRAWING D53472780, AND SRM 51-72-11.SDR AALA2018042409021Door Sill · corrodedCORROSION ON L2 DOOR SILL AT FRAMES 64 TO 70, STRINGER 23L, Z-500. INSTALLED A MODIFIED PART IAW SRM 51-72-11 AND DRAWING D52480505.SDR AALA201804069019Floorbeam · corrodedCORROSION ON THE FLOORBEAM, FRAME 66, Z-500, Y1292. REPLACED THE FLOORBEAM IAW SRM 51-72-11.SDR AALA201804019004Floorbeam · corrodedCORROSION ON THE FORWARD WET AREA LEFT FLOORBEAM AT FRAME 16, Z 500, Y1292. REPLACED THE FLOORBEAM IAW SRM 51-42-11, AND 53-11-01-04G.SDR AALA201803279006Floorbeam · corrodedCORROSION FOUND AT MOUNTING POINT ON THE RIGHT FLOORBEAM LOCATED AT -Y765 FORWARD OF FRAME 66. REPLACED THE FLOORBEAM IAW SRM 51-42-11.SDR AALA201803099024Bustle · looseAIRCRAFT WAS NOT GROUNDED. SLIDE BUSTLE/COVER TRIM IS LOOSE. RE-SECURED R2 DOOR SLIDE BUSTLE.SDR AALA201708159028Shear Pin · looseDURING REPLACEMENT OF R1 DOOR ASSIST CYLINDER DIAPHRAGM, THE ASSOCIATED SHEAR PIN WAS FOUND TO BE LOOSE. SECURED THE SHEAR PIN IAW TIME LIMITED REPAIR IAW EA 272508. REPLACED R1 DOOR DAMPER EMERGENCY OPERATION CYLINDER AND SHEAR PIN IAW AMM 52-11-14 AND AMM SDR AALA201707129005Lens · missingR2 DOOR EXIT SIGN LENS MISSING. REPLACED R2 DOOR EXIT SIGN LENS.SDR AALA201705199006Accumulator · leakingAFTER PUSH BACK AND NR 1 ENGINE START, BRAKE ACCUMULATOR PRESSURE DROPPED WELL BELOW GREEN BAND. REPLACED THE BRAKE ACCUMULATOR.SDR AALA201705089004Girt Bar · obstructedL2 DOOR WOULD NOT ARM. FOUND TRASH IN GIRT BAR CONNECTION , REMOVED FOD, OPS CHECKED GOOD.SDR AALA201607259010Floor Panel · delaminatedAFT CARGO BAY FLOOR PANEL 151VG HAS A DELAMINATED AREA. REPLACED THE FLOOR PANEL IAW AMM 53-42-14.SDR AALA201603099018Floor Panel · erodedAIRCRAFT IN BASE MX. AFT CARGO BAY FLOOR PANEL 151ZG FOUND WITH UPPER LAYER ERODED & HONEYCOMB SHOWING. INSTALLED NEW AFT CARGO BAY FLOOR PANEL 151ZG IAW AMM 53-42-14-400-001-A.SDR AALA201512079017Hinge Fitting · wornAIRCRAFT IN BASE MX. RT ELEVATOR HINGE FITTING NR 6 BEARING WORN. REPLACED HINGE FITTING IAW AMM 55-16-42-400-001A.SDR AALA201512079016Hinge Fitting · wornAIRCRAFT IN BASE MX. LT ELEVATOR HINGE FITTING NR 6 BEARING WORN. REPLACED HINGE FITTING IAW AMM 55-16-42-400-001A.SDR AALA201512079018Skin · saturatedAIRCRAFT IN BASE MX. LT ELEVATOR HAS 2 AREAS OF WATER INGRESS, 81" FROM INBD EDGE & 4.5" FROM TE, 110" FROM INBD EDGE & 16" FROM TE. ELEVATOR REPAIRED IAW SRM 55-21-11-201 PARAGRAPH 5E FIGURE 205.SDR AALA201511239016Pump · inoperativeFUEL CTR TANK PUMP 1 LOW PRESSURE. REPLACED CTR TANK PUMP NR 1 & ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECKED IAW AMM 28-21-51-000-002-A.SDR AALA201509129001Pressure Switch · failedCENTER TANK NR 1 FUEL PUMP FAULT ON CLIMB OUT. REPLACED THE CTR TANK NR 1 FUEL PUMP, BUT THE FAULT REOCCURRED ON THE NEXT FLIGHT. REPLACED THE PRESSURE SWITCH IAW AMM 28-21-15 & ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201508249004Beam · crackedRIGHT SIDE BOX BEAM FLANGE AFT HOLE HAS CRACK INDICATIONS ON THE AFT SIDE OF THE HOLE. REPAIRED IAW EO 5315Y066.SDR AALA201508249003Beam · crackedLEFT SIDE BOX BEAM FLANGE AFT HOLE HAS CRACK INDICATIONS ON THE FWD & AFT SIDE OF THE HOLE. REPAIRED IAW EO 5315Y066.SDR AALA201508209003Lens · missingDOOR L1 EMER EXIT LIGHT COVER MISSING AT DOOR L1 FLOOR. REPLACED MISSING EMER LIGHT COVER L1 DOOR.SDR AALA201505089002Lens · missingEMERGENCY EXIT LIGHT COVER AT DOOR 2R IS MISSING. REPLACED THE EEL LENS COVER AT DOOR 2R.SDR AALA201504249008Battery Pack · no testEMERGENCY POWER SUPPLY UNIT BATTERIES FAILED TEST. REPLACED THE BATTERIES FOR THE AFFECTED EPSU 10WL, 11WL, 12WL & 13WL.SDR USAA2015032400003Power Supply · inoperativeEMERGENCY LIGHTS SYS, OPERATIONS TEST FAILED. REPLACED EPSU 13WL IAW AMM 33-51-38. OPERATIONAL CHECKED GOOD AT THIS TIME.SDR USAA2015031600011Slide · unserviceableDURING SCHEDULED SLIDE CHANGE IAW JC 26L00025010, PRIOR TO INSTALLATION, FOUND NEW SLIDE UNSERVICEABLE DUE TO PACK BOARD SHAFT RETAINING PINS MISSING BALL & CABLE.SDR USAA2014112000001Battery · dischargedAFT FLASHLIGHT INOPERATIVE. INSTALLED SERVICEABLE BATTERY IN AFT FLASHLIGHT, CHECKED GOOD.SDR USAA2014110700001Unknown · odorPLASTIC SMELL AROUND SEAT ROW 18. GND RUN PACKS, APU AIR, GALLEY EQUIPMENT & INSPECTED CABIN, NO DISCREPANCIES NOTED. NO PRIOR HISTORY, ACFT OK FOR SERVICE.SDR USAA2014091900002Fire Warning · false activationCREW RECEIVED ECAM, ENG 2 FIRE LOOP A FAULT, WHILE THE ENG 2 FIRE LOOP B WAS ON MEL. IAW TSM 24-00-00-810-818-A & RESET ENG 2 FDU LOOP SYS AS REQUIRED, FAULT CLEARED. ACCOMPLISHED & PASSED OPERATIONS CHECK OF ENG FIRE & OVERHEAT DETECTION IAW AMM 26-12-00-71
Back to N745VJ