N645GT
Service difficulty reports · 716
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 = 'N645GT' 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 = 'N645GT' 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 UIEA2018071001421Shear Tie · corrodedFWD CARGO COMPT AND SHEAR TIE AT STA 645 (BILGE AREA) HAS CORROSION BETWEEN STR 36R AND STR 35R. REMOVED AND REPLACED FWD CARGO COMPT SHEAR TIE AT STA645 (BILGE AREA) STR BETWEEN STR 36R AND STR35R PER SRM 51-40-05-06-0.SDR UIEA2018071001422Floorbeam · corrodedMAIN CABIN STA 287 BETWEEN LBL6 AND LBL 20 FLOORBEAM UPPER T-CAP CORRODED. UPON FURTHER INSP FOUND CORROSION ON EXISTING REPAIR DOUBLER. REMOVED FABRICATED AND INSTALLED REPAIR DOUBLER AT STA 287 BETWEEN LBL6 AND LBL20 PER SRM 53-00-51-2R-2 AND SRM 51-40-02-06SDR UIEA2018071001423Bracket · crackedFWD ENTRY DOOR CUTOUT LWR SILL UPPER SURFACE HAS 2EA CRACKED BRACKET. REMOVED 2EA CRACKED BRACKET PER SRM 57-40-02-06-0. FABRICATED AND INSTALLED 2EA BRACKET AT FWD ENTRY DOOR CUTOUT LWR SILL UPPER SURFACE PER AWG 5602 AND 141T8310.SDR UIEA2018071001427Frame · corrodedAFT CARGO COMPT BILGE FRAME AT STA 197+88 RBL48 HAS CORROSION. REMOVED CORROSION BEYOND LIMITS PER SRM 53-00-07-1A-1 FIG 101 ITEM D. FABRICATED AND INSTALLED REPAIR ANGLE & SHIM PER SRM 53-00-07-2R-4 REPAIR 4.SDR UIEA2018071101437Tip Cap · damagedRT HORIZ STAB T/E OUTB/D TIP HAS DAMAGE. ACCOMPLISHED EA 767-5510-28-A7315.SDR UIEA2018070901389Rib · chafedNR 1 ENGINE CORE COWL O/B 2ND RIB FROM FWD CHAFED. REMOVED FABRICATED & INSTALLED NR 1 ENGINE O/B CONE COWL 2ND RIB FROM FWD PER SRM 54-42-02-1R-2 REPAIR 2.SDR UIEA2018070901390Shear Tie · corrodedFWD CARGO COMPT SHEAR TIE ON FRAME AT STA 588 BETWEEN STR39L & 39R. REMOVED SHEAR TIE A FRAME STA 588 BETWEEN S39L & S39R. FABRICATED AND INSTALLED REPAIR SHEAR TIE AT STA 588 BETWEEN S39L AND S39R PER SRM 51-30-01 & SRM 51-21-01.SDR UIEA2018070901392Shear Tie · corrodedFWD CARGO COMPT SHEAR TIE AT STA 654 & 44 BETWEEN S39L & S39R HAS CORROSION. REMOVED & REPLACED SHEAR TIE AT STA654 & 44 S39L & 39R PER SRM 51-40-05-06-0.SDR UIEA2018070901393Shear Tie · corrodedFWD CARGO COMPT SHEAR TIE AT STA 566 (BILGE) BETWEEN S39L AND S39R HAS CORROSION. REMOVED AND REPLACED SHEAR TIE AT STA 566 BETWEEN S39L AND S39R PER SRM 51-40-05-06-0.SDR UIEA2018070901394Skin · corrodedRT WING SLAT NR 11 HAS CORROSION ON UPPER SURFACE I/B SLAT TRACK. REMOVED CORRODED DOUBLER ON RT WING SLAT NR 11 PER SRM 51-70-10 PALA7. FABRICATED & INSTALLED REPAIR DOUBLER AND FILLER PER SRM 57-43-02-01-1 DETAILIII & SRM 57-43-02-02 R.SDR UIEA2018071601487Skin Panel · chafedLT WING L/B LOWER SURFACE IS CHAFED BELOW NR 6 SLAT. REMOVED AND REPLACED SKIN PANEL/PLATE BELOW NR 6 SLAT ON LT WING PER SRM 5140-02-06-0.SDR UIEA2018071601488Angle · chafedLT WING L/B FUELING DOOR INNER ANGLE CHAFED. REMOVED AND REPLACED LT WING FUEL DOOR ANGLE BRACKET PER SRM 51-40-02-06-0.SDR UIEA2018071601489Bracket · crackedAFT ENTRY DOOR COUTOUT LOWER SILL UPPER SURFACE HAS 2 CRACKED BRACKETS. REMOVED AND REPLACED AFT ENTRY DOOR LOWER SILL 2EA BRACKETS PER SRM 51-40-02-06-0.SDR UIEA201806051020Clamp · brokenAPU PNEUMATIC INOPERATIVE. TROUBLESHOT AND FOUND THE AIR SUPPLY DUCT CLAMP BROKEN.SDR UIEA201806051022Clamp · failedAPU INOPERATIVE. REMOVED AND REPLACED THE PNEUMATIC DUCT CLAMP ON APU PNEUMATIC OUTPUT DUCT AND OPS CHECKED GOOD IAW AMM 36-00-00 .SDR UIEA2018060101007Control Valve · malfunctionedAPU AUTO SHUTDOWN WITH A REVERSE FLOW MESSAGE. REMOVED AND REPLACED THE APU SURGE CONTROL VALVE IAW AMM 49-53-01, OPS CHECKED NORMAL.SDR UIEA2018052900995Igniter · inoperativeAPU WOULD NOT IGNITE. R&R IGNITER ON APU REF AMM 49-41-02 OPS CK NORMAL.SDR UIEA2018052900996Control Valve · faultyAPU AUTO SHUTDOWN. REMOVED AND REPLACED APU SURGE CONTROL VALVE REF AMM 49-53-01 OPS CHECK NORMAL.SDR UIEA201805290971Warning Message · illuminatedAFTER TAKEOFF, FWD EQUIPMENT COOLING EICAS, QRH EQUIPMENT COOLING STBY. ACCOMPLISHED AN ADJUSTMENT AND TEST OF THE EQUIPMENT COOLING SYSTEM IAW AMM 21-53-00.SDR UIEA201805290972Warning Message · false activationCENTER RIGHT FUEL PUMP EICAS WITH CENTER FUEL IN FLIGHT. OPS CHECKED IAW AMM 28-22-00, COULD NOT DUPLICATE.SDR UIEA2018052500956Apu · shutdownAPU AUTO SHUTDOWN, UNABLE RESTART. REMOVED AND REPLACED THE APU AND OPS CHECKED GOOD IAW AMM 49-11-01.SDR UIEA201805290959Filter · warning messageRIGHT ENGINE FUEL FILTER EICAS MESSAGE DURING CLIMB. MESSAGE DISAPPEARED AFTER 2 MINUTES. REPLACED THE FUEL FILTER IAW AMM 73-11-02 IAW FIM 73-11-FT803. OPS AND LEAK CHECKED GOOD.SDR UIEA201805290963Valve · malfunctionedLEFT ENGINE BLEED OVERHEAT, QRH PROCEDURES COMPLETED. REMOVED AND REPLACED THE LEFT ENGINE FAN AIR VALVE IAW AMM 36-11-16. OPS CHECKED GOOD.SDR UIEA2018052500962Warning Message · false activationEICAS MESSAGE FOR THE LT BLEED OVERHEAT FOLLOWED BY LT BLEED VALVE CLOSED, COMPLIED WITH QRH PROCEDURE AND RESUMED NORMAL OPS. PERFORMED A BITE IAW 36-20-01, FAULT TREE 802, OPS CHECKED OK.SDR UIEA2018052500961Connector · disconnectedEMERGENCY LIGHTS INOPERATIVE AT SEATS 37H AND 38H. CONNECTED THE CONNECTORS AT SEATS 37H AND 38H AND CHECKED GOOD IAW 33-51-00.SDR UIEA2018042750802Pump · malfunctionedAPU SHUTDOWN DURING PILOTS PRE FLIGHT INSPECTION, WHILE TURNING ON FUEL BOOST PUMPS. PERFORMED A BCPU BITE CHECK, RESET FAULT, APU RESTART COMPLIED WITH IAW 49-61-00.SDR UIEA201805010807Idg · failedRIGHT GENERATOR DRIVE EICAS MESSAGE WHEN GOING TO IDLE FOR DESCENT. REMOVED AND REPLACED THE NR 2 ENG IDG IAW AMM 24-11-01-404-024, OPS AND LEAK CHECKED SATISFACTORY.SDR UIEA201804250790Idg · disconnectedRIGHT GENERATOR DRIVE EICAS MESSAGE. RECONNECTED THE RT IDG, SERVICED & OPS CHECKED IAW AMM 24-11-00 & AMM 12-13-03.SDR UIEA2018041900743Terminal · brokenRIGHT ENGINE FIRE LOOP 1 STATUS MESSAGE. REPLACED BROKEN TERMINAL AT AFT LOWER FIRE LOOP IAW AMM 20-51-00.SDR UIEA2018040800633Connector · unsecureSTATUS MESSAGE FOR THE RIGHT ENGINE CONTROL, CAUTION MESSAGE ON LANDING. FOUND A LOOSE CONNECTOR AT P114. SEATED AND SECURED THE CONNECTOR. OPS CHECKED IAW AMM 71-00-01 TASK A87-A88.SDR UIEA2018032800467Shutoff Valve · malfunctionedRIGHT ENGINE BLEED OFF EICAS MESSAGE ON IDLE DURING DESCENT APPROXIMATLEY 8 DIFFERENT MESSAGES DURING DESCENT PHASE. OPS CHECKED PRSOV IAW 36-11-09, PERFORMED FIM 36-10-08. NO FAULTS FOUND INSPECTED. VISUALLY PRSOV NO PROBLEMS FOUND. REMOVED AND REPLACEDSDR UIEA2018032000441Light · inoperativeEMERGENCY LIGHT AT SEAT 21 A AND C INOPERATIVE. REPAIRED IAW SWPM 20-10-13SDR UIEA2018032000442Lamp · inoperativeEMERGENCY LIGHTS BY SEAT 17K INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED GOOD IAW AMM 33-51-00.SDR UIEA2018032000443Starter · malfunctionedNR 2 ENGINE STARTER MOTOR UNABLE TO SEDUCE. REMOVED AND REPLACED THE STARTER MOTOR . OPS CHECKED NORMAL IAW AMM 80-11-01.</P>)SDR UIEA2018032000444Intake Duct · damagedLEFT ENGINE OTBD THRUST REVERSER FAN AIR VALVE INTAKE DUCT HAS A THREE HOLE. REMOVED AND REPLACED THE INTAKE DUCT IAW AMM 36-11-01.SDR UIEA2018022400269Warning Message · false activationDURING FLIGHT, WEATHER FAIL WARNING DISPLAYED ON ND. WEATHER RADAR SYSTEM STATUS MESSAGE DISPLAYED. SWITCHED TO SYSTEM NR 2 TO RESUME RADAR DISPLAY. PERFORMED AN OPS CHECK IAW AMM 34-45-00. NO PROBLEMS FOUND.SDR UIEA2018022700287Connector · dirty"L OIL FILTER" STATUS MESSAGE INDICATED AFTER START. INSPECTED OIL FILTER DIFFERENTIAL PRESSURE SWITCH, CLEANED CONNECTOR & OPS CHK GOOD IAW AMM 79-35-01.SDR UIEA2018022600281Control Valve · faultyRT PACK OFF INOP. R&R RT FLOW CONTROL VALVE. OPS CK GOOD IAW AMM 21-51-00.SDR UIEA2018021600236Radar · failedNR 1 AND 2 WEATHER RADARS FAILED ON ND. STATUS MESSAGE. PERFORMED A BITE CHECK AND OPS CHECK OF THE WEATHER RADAR IAW AMM 34-43-00. FAIL WS MODE AND W/S WX MODE ARE INOPERATIVE IAW AMM.SDR UIEA2018021500226Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT ROW 12D. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-51-10. OPS CHECKED NORMAL.SDR UIEA2018021500233Radar · unknownNR 1 WEATHER RADAR SYSTEM FAILED EN ROUTE. COULD NOT DUPLICATE. PERFORMED RADAR BITE CHECK IAW AMM 34-43-00. OPS CHECKED OK.SDR UIEA2018020800195Warning Message · false activationDURING CLIMB AT 10.000 FT MSL, AN INTERMITTENT LEFT WING ANTI-ICE MESSAGE. PERFORMED A GROUND TEST IAW AMM 30-11-02. OPS CHECKED GOOD.SDR UIEA2018020800193Pressure Switch · failedLEFT WING ANTI-ICE MESSAGE INTERMITTENT DURING CLIMB OUT. COMPLIED WITH QRH. REMOVED AND REPLACED THE LT WING ANTI-ICE PRESSURE SWITCH IAW AMM 30-11-04. OPS TESTED NORMAL ON GROUND.SDR UIEA2018020600183Warning Message · false activationLEFT ENGINE OIL FILTER STATUS MESSAGE AFTER ENGINE START. INSPECTED LEFT ENGINE OIL BYPASS SYSTEM AND OPS CHECKED GOOD IAW AMM 79-35-00</P>)SDR UIEA2018011800087Connector · unknownDURING PUSHBACK, THE RIGHT ENGINE START SWITCH WILL NOT ENGAGE IN THE GROUND POSITION. REMOVED THE CONNECTOR ON P94 FROM START VALVE. CONNECTED THE CONNECTOR AND OPS CHECKED OK IAW AMM 80-12-00.SDR UIEA2018011500066Connector · corrodedRIGHT CENTER FUEL PUMP NO LOW PRESSURE LIGHT INDICATION OR ASSOCIATED EICAS WITH TANK EMPTY. CLEANED CORROSION FROM CONNECTOR S-424. OPS CHECKED IAW AMM 28-42-00. NO DEFECTS NOTED.SDR UIEA2018010800033Warning Message · false activationDURING FLIGHT, LENS WEATHER RADAR FAILED LEFT AND RIGHT. OPS CHECKED THE NR 2 WEATHER RADAR GOOD IAW 34-43-00.SDR UIEA2018010600016Connector · looseEMERGENCY LIGHT INOPERATIVE AT MID CABIN LAVATORY AND ROWS 20AC, 21AC. REPLACED THE LAMPS IN THE MID CABIN LAVATORY FLOOR AND SECURED THE CONNECTOR AT SEATS 20 AND 21 IAW AMM 33-51-00.SDR UIEA2018010400013Warning Message · false activationDURING FLIGHT, EICAS FOR THE WEATHER RADAR FAILED, LEFT AND RIGHT RADAR. OPS CHECKED THE NR 2 WEATHER RADAR WAS GOOD IAW AMM 34-43-00. PERFORMED ACTION PLAN AP-13754 AND FIM 34-43 FT 805 SYSTEM OPS CHECKED NORMAL.SDR UIEA2017123102451Battery Pack · corrodedEXTERIOR EMERGENCY LIGHTS INOPERATIVE ON RT SIDE OF ACFT, AFT OF FLAPS. FOUND CORROSION ON THE F1 OF POWER PACK, CLEANED CORROSION, OPS CHECKED OK IAW AMM 33-51-00.
Back to N645GT