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 USAA2012082900023Frame · cracked2S CHECK - CRACK ON EMERGENCY EXIT DOOR 844 FORWARD SEGMENT FRAME BETWEEN FR40 TO FR41 & BETWEEN BEAM 2 & BEAM 3. REPLACED EMERGENCY EXIT DOOR 844 FORWARD SEGMENT FRAME IAW EO 5210Y228.SDR USAA2012082900022Frame · cracked2S CHECK - CRACK ON EMERGENCY EXIT DOOR 844 AFT SEGMENT FRAME BETWEEN FR40 TO FR41 & BETWEEN BEAM 2 & BEAM 3. REPLACED EMERGENCY EXIT DOOR 844 AFT SEGMENT FRAME IAW EO 5210Y228.SDR USAA2012082900021Frame · cracked2S CHECK - CRACK ON EMERGENCY EXIT DOOR 834 AFT SEGMENT FRAME BETWEEN FR40 TO FR41 & BETWEEN BEAM 2 & BEAM 3. REPLACED EMERGENCY EXIT DOOR 834 AFT SEGMENT FRAME IAW EO 5210Y228.SDR USAA2012082100015Floor Panel · delaminated2S CHECK - DELAMINATION ON FLOOR PANEL 151VG BETWEEN FR53 TO FR55A & BETWEEN -Y765 TO Y765. REPLACED FLOOR PANEL 151VG IAW A319 SRM 53-02-00 & IRM 9701 REV G.SDR USAA2012082100004Floor Panel · delaminated2S CHECK - DELAMINATION ON FLOOR PANEL 151ZG BETWEEN FR55A TO FR59 & BETWEEN -Y765 TO Y765. REPLACED FLOOR PANEL 151ZG IAW A319 SRM 53-02-00 & IRM 9701 REV G.SDR USAA2012082100003Floor Panel · delaminated2S CHECK - DELAMINATION ON FLOOR PANEL 131CG BETWEEN FR28 TO FR34 & BETWEEN -Y765 TO Y765. REPLACED FLOOR PANEL 131CG IAW A319 SRM 53-02-00 & IRM 9701 REV G.SDR USAA2012033000004Lens · missingRED LENS COVER FOR FLOOR PATH EMERGENCY LIGHTING ATTACHED TO SEAT 8D IS MISSING. REPLACED MISSING LENS. OPS CHECKED GOOD.SDR USAA2011100300033Floor Panel · damagedC11 CHECK - SURFACE DAMAGE ON FLOOR PANEL 232LF BETWEEN FR24 TO FR28 & BETWEEN -Y254 TO -Y765. REPLACED FLOOR PANEL 232LF IAW MCGILL IRM 9701 REV G.SDR USAA2011093000006Floor Panel · delaminatedC11 CHECK - DELAMINATED FLOOR PANEL 261DF AT FR66, Y0. REPLACED FLOOR PANEL 261DF AT FR66, Y0 IAW MCGILL 9701 REV G.SDR USAA2011092800014Skin · saturatedC11 CHECK - WATER INGRESS ON LEFT ELEVATOR UPPER SURFACE 5 INCHES FORWARD OF TRAILING EDGE AND 80 INCHES INBOARD OF OUTBOARD EDGE. REPAIRED LEFT ELEVATOR UPPER SURFACE IAW A319 SRM 55-21-11 FIGURES 204, 205.SDR USAA2011092700028Shear Tie · corrodedC11 CHECK - LEVEL 2 SURFACE CORROSION ON SHEAR TIE BETWEEN FR69 TO FR70, Y1292. REPLACED SHEAR TIE BETWEEN FR69 TO FR70, Y1292 IAW A319 SRM 51-41-00 AND AIRBUS DRAWING D53474180.SDR USAA2011100500007Fitting · corrodedC11 CHECK - LEVEL 2 SURFACE CORROSION ON CORNER SHAPE FITTING AT FR68, Y1584. REPLACED CORNER SHAPE FITTING AT FR68, Y1584 IAW A319 SRM 51-72-11 & AIRBUS DRAWING D5340505.SDR USAA2011100400020Fitting · corrodedC11 CHECK - LEVEL 2 CORROSION ON CORNER FITTING AT FR68, -Y1584. REPLACED CORNER FITTING AT FR68, -Y1584 IAW A319 SRM 51-72-1 AND AIRBUS DRAWING D53480505.SDR USAA2011093000016Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT FR20, -Y254. REPLACED FLOORBEAM AT FR20, -Y254 IAW A319 SRM 51-42-11.SDR USAA2011093000015Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT FR24, -Y189. REPLACED FLOORBEAM AT FR24, -Y189 IAW A319 SRM 51-72-11.SDR USAA2011093000008Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR20 TO FR24, S23R, -Y765. REPLACED FLOORBEAM BETWEEN FR20 TO FR24, 23R, -Y765 IAW A319 SRM 51-72-11.SDR USAA2011093000007Floorbeam · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR66 TO FR70, S23R, -Y765. REPLACED FLOORBEAM BETWEEN FR66 TO FR70, S23, -Y765 IAW AIRBUS DRAWING 18D53472780.SDR USAA2011093000005Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOOR BEAM AT FR12, -Y765. REPLACED FLOORBEAM AT FR12, -Y765 IAW A319 SRM 53-11-15.SDR USAA2011092900017Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT FR20, S23R, -Y765. REPLACED FLOORBEAM AT FR20, S23R, -Y765 IAW A319 SRM 51-72-11.SDR USAA2011092900016Floorbeam · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM FR68, S23L, Y765. REPLACED FLOORBEAM FR68, S23L, Y765 IAW A319 SRM 51-72-11.SDR USAA2011092800032Beam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON Z-BEAM AT FR68, Y1162.5. REPLACED Z-BEAM AT FR68, Y1162.5 IAW A319 SRM 51-72-11.SDR USAA2011092800031Beam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON Z-BEAM AT FR67, Y1162.5. REPLACED Z-BEAM AT FR67, Y1162.5 IAW A319 SRM 51-72-11.SDR USAA2011092800013Beam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON Z-BEAM AT FR66, Y1162.5. REPLACED Z BEAM AT FR66, Y1162.5 IAW A319 SRM 51-72-11.SDR USAA2011092800012Floorbeam · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT 6 INCHES FORWARD OF FR66, S23R, -Y254. REPLACED FLOORBEAM AT 6 INCHES FORWARD OF FR66, S23R, -Y254 IAW A319 SRM 51-72-11.SDR USAA2011092800011Floorbeam · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR64 TO FR66, -Y765. REPLACED FLOORBEAM BETWEEN FR64 TO FR66, -Y765 IAW A319 SRM 51-72-11.SDR USAA2011092800010Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT FR16, -Y81. REPLACED FLOORBEAM AT FR16, -Y81 IAW A319 SRM 51-72-11.SDR USAA2011092700027Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT FR16, Y1292. REPLACED FLOORBEAM AT FR16, Y1292 IAW A319 SRM 51-72-11.SDR USAA2011092700026Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR16 TO FR24, -Y1292. REPLACED FLOORBEAM BETWEEN FR16 TO FR24, -Y1292 IAW A319 SRM 51-42-11 & 53-11-15.SDR USAA2011092700025Shear Tie · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON SHEAR TIE BETWEEN FR69 TO FR70, -Y1160. REPLACED SHEAR TIE BETWEEN FR69 TO FR70, -Y1160 IAW A319 SRM 51-72-11.SDR USAA2011092700024Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR16 TO FR24, Y254. REPLACED FLOORBEAM BETWEEN FR16 TO FR24, Y254 IAW A319 SRM 51-72-11 & 53-11-14.SDR USAA2011092700023Floorbeam · corrodedC11 CHECK - EXFOLIATION CORROSION ON FLOORBEAM AT FR66, -Y464.8. REPLACED FLOORBEAM AT FR66, -Y464.8 IAW A319 SRM 51-72-11.SDR USAA2011092800004Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM FORWARD OF FR16 ,Y503.2. REPLACED FLOORBEAM FORWARD OF FR16 ,Y503.2 IAW A319 SRM 51-72-11.SDR USAA2011092700031Floorbeam · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR64 TO FR66, -Y1292. REPLACED FLOORBEAM BETWEEN FR64 TO FR66, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2011092700030Floorbeam · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68 & BETWEEN -Y1292 TO -Y1162.5. REPLACED FLOORBEAM BETWEEN FR66 TO FR68 & BETWEEN -Y1292 TO -Y1162.5 IAW A319 SRM 51-72-11.SDR USAA2011092700029Floorbeam · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR68, -Y1162.5. REPLACED FLOORBEAM AT FR68, -Y1162.5 IAW A319 SRM 51-72-11.SDR USAA2011092700003Sill · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON L2 DOOR WAY SILL PLATE AT FR66. REPAIRED L2 DOOR WAY SILL PLATE AT FR66 IAW A319 SRM 53-41-14 PRINCIPLE 6.SDR USAA2011062800023Wire Harness · faultyCLT-LGA - EL - EN ROUTE TO LGA, LANDING GEAR LGCIU 1 FAULT ANNUNCIATED ON ECAM WITH NO GEAR INDICATION. RETURNED TO CLT AND DECLARED EMERGENCY LANDING. REMOVED AND REPLACED LEFT GEAR DOWN LOCK SENSOR HARNESS PER AMM 32-11-43. GEAR SWING PERFORMED PER AMM 07SDR USAA2011060100006Power Supply · inoperativeTPA - EEL - FORWARD EMERGENCY LIGHT POWER SUPPLY INOPERATIVE. REMOVED AND REPLACED FORWARD POWER SUPPLY UNIT.SDR USAA2011050691778Fan · seizedFLT 2165 - LOUD MOTOR SOUND HEARD, FOLLOWED BY ELECTRICAL SMOKE ODOR, FOLLOWED BY VENT EXTRACT FAULT. REMOVED AND REPLACED VENT EXTRACT FAN 18HQ PER AMM 21-26-51-400-001 OPERATIONAL CHECK WAS GOOD. (FAN WAS SEIZED).SDR USAA2011033191290Damper · low pressureFLT 1709 - CLT-BDL - EMERGENCY EGRESS SYSTEM - DOOR L1 DAMPER LOW ON CHARGE. SERVICED L1 DOOR DAMPER PER 52-10-00.SDR USAA2011032891259Skin · crackedPIT - RUDDER DISBOND INSPECTION - CRACK ON FUSELAGE SKIN BETWEEN FR63 TO FR64 & BETWEEN S41L TO S42L. REPAIRED FUSELAGE SKIN BETWEEN FR63 TO FR64 & BETWEEN S41L TO S42L IAW A319 SRM 53-00-11.SDR USAA2011021190698Cylinder · low pressureFLT 2048 - BOS - EES - PASSENGER DOOR ACCUMULATOR LOW. MAINTENANCE SERVICED PASSENGER DOOR ACCUMULATOR IAW AIRBUS MAINTENANCE MANUAL 52-10-00.SDR USAA2010120692864Accumulator · low pressureFLT 1406 - PHL-BOS - EMERGENCY EGRESS SYSTEM - L1 EMERGENCY ACCUMULATOR REQUIRES SERVICING. SERVICED L1 EMERGENCY ACCUMULATOR. OPERATIONAL CHECK WAS GOOD.SDR USAA2010091491984Bottle · low pressureFLT 1060 - CLT-DCA - EMERGENCY EGRESS SYSTEM - FORWARD ENTRY DOOR (L1) ASSIST BOTTLE LOW PRESSURE. SERVICED (L1) FORWARD ENTRY DOOR ASSIST BOTTLE PER AMM 52-10-00-614.SDR USAA2010071291394Wire Harness · defectiveFLT 759 - PHL-ORD - EMERGENCY LIGHTS - ROW 12ABC SEAT MOUNTED FLOOR LEVEL EMERGENCY LIGHT INOPERATIVE. REPLACED WIRING HARNESS (26-3351-3-0011) ON SEAT MOUNTED EMERGENCY LIGHT PER AIRCRAFT WIRING MANUAL REFERENCE 33-51-08. OPERATIONAL CHECK WAS GOOD.SDR USAA2010051790975Coffeemaker · faultyLOGPAGE:7007564 - FLT 1597 - SYR-CLT - BURNING SMELL - FLIGHT ATTENDANT REPORTS ELECTRICAL SMOKE SMELL FORWARD GALLEY COFFEE POT, PULLED COFFEE POT AND CHILLER CIRCUIT BREAKER. SMELL WENT AWAY. REMOVED AND REPLACED COFFEEMAKER PER AMM 25-35-15-04. OPERATIONASDR USAA2010051290949Fitting · groovedMCN - RIB 5 MOD - MAJOR REPAIR - LEFT MAIN LANDING GEAR DOOR ACTUATOR FITTING FORWARD LUG BORE WORN / GROOVED BETWEEN FR42 TO FR43, Y325. REPLACED LEFT MAIN LANDING GEAR DOOR ACTUATOR FITTING BETWEEN FR42 TO FR43, Y325 IAW EA 130404.SDR USAA2010011590113Cylinder · low pressureFLT NR 1888 - EMERGENCY EGRESS SYSTEM - L1 DOOR EMERGENCY CYLINDER NEEDS SERVICE. SERVICED L1 DOOR EMERGENCY CYLINDER PER AMM 52-10-00-614.SDR USAA2009090392332Lens · missingFLT 1170 - CLT-PIT - EMERGENCY LIGHTS - EMERGENCY LIGHT LENS BELOW EXIT SIGN IN GALLEY (A/C RIGHT) IS MISSING. REPLACED EMERGENCY LIGHT LENS BELOW EXIT SIGN IN GALLEY.SDR USAA2009082692250Slide · failedFLT 1678 - FORWARD LEFT DOOR SLIDE FAILS EMERGENCY LIGHT CHECK. REMOVED AND REPLACED LEFT FORWARD DOOR SLIDE. DOOR SLIDE WAS OVERHAULED AND INSPECTED - PASSED ALL FUNCTIONAL, LIGHTING AND INTEGRITY TESTS.
Back to N745VJ