N713UP, cancelled Aug 27, 2013
Service difficulty reports · 176
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 = 'N713UP' AND deregistration_id = 'N713UP-2013-08-27' 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 = 'N713UP' AND deregistration_id = 'N713UP-2013-08-27' 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 UPS02839925Finger Doubler · corrodedINSPECTION TYPE: LNSV, RIVET POPPED ON RT FWD SECTION OF FUSELAGE NEXT TO D10 CONDITIONED AIR DOOR. REMOVED POPPED RIVET AT STA 8 AND FOUND FINGER DOUBLER SEVERLY CORRO DED. FABBED NEW FINGER DOUBLER IAW DAC DWG 5613862 MATERIAL ID 02570 75T6 PO 0349922 IAW SDR UPS01837349Fire Warning · false activationINSPECTION TYPE:N/A ATB-LOWER CARGO COMPT FIRE WARNING LIGHT ILLUM TEMPORARY. PERFORMED MX TEST ON CARGO COMP LOWER PIT SMOKE DETECTOR SYSTEM, NO FAULTS NOTED SYSTEM OPERATES NORMALLY IAW SECURAPLANE TECHNOLOGIES LLC AIRCRAFT MAINT MANUAL.SDR UPS01835706Extinguisher · leakingINSPECTION TYPE:N/A PORTABLE FIRE EXTINGUISHER LEAKING NEEDS RECHARGE. REMOVED AND REPLACED FIRE EXTINGUISHER IN COURIER AREA.SDR UPS01835456Indicator · intermittentON FINAL, GEAR DOWN & LOCK INDICATOR INTERMITTENT. DECLARED EMERGENCY. REPAIRED BROKEN WIRE AT PIN 5 (BLUE WIRE) CONN. P1-213 ON LT MLG DOWN LIMIT SWITCH & REPLACED CONNECTOR.CHECKED NORMALLY.SDR UPS01835449Light · inoperativeINSPECTION TYPE:PREFLT, BOTH COCKPIT & ENTRY DOOR EMERGENCY LIGHTS INOP REMOVED & REPLACED EMERGENCY BATTERY & RELAY UNIT. OPS CHECK GOOD. OK FOR SERVICE.SDR UPS01834669Longeron · crackedINSPECTION TYPE:C2, STA 1770 LONG 17R IS CRACKED. REMOVED, FABRICATED AND REPLACED LONGERON IAW DC8-53B-009-39 AND SRM 53-2-2 FIG 10.SDR UPS01834664Longeron · crackedINSPECTION TYPE:C2, STA 1770 LONG 17L IS CRACKED. REMOVED, FABRICATED AND REPLACED LONGERON IAW DWG 5644130 AND SRM 53-2-2 FIG 10.SDR UPS01834668Fitting · corrodedINSPECTION TYPE:C2, STA 1150 - 1160 ATTACHMENT FITTING IS CORRODED BEYOND LIMITS ABOVE LONG 31R. REMOVED AND REPLACED FITTING IAW DWG 3754914 AND SRM 51-1-21.SDR UPS01834685Fitting · corrodedINSPECTION TYPE:C2, STA 1230 BATHTUB FITTING IS CORRODED BEYOND LIMITS BETWEEN LONG 34L AND 35L. REMOVED AND REPLACED FITTING IAW DWG 3755845 AND SRM 51-1-20D.SDR UPS01834684Fitting · corrodedINSPECTION TYPE:C2, STA 1160 BATHTUB FITTING IS CORRODED BEYOND LIMITS BETWEEN LONG 35R AND LONG 36. REMOVED AND REPLACED FITTING IAW DWG 3755845 AND SRM 51-1-20D.SDR UPS01834683Fitting · corrodedINSPECTION TYPE:C2, STA 1152 BATHTUB FITTING IS CORRODED BEYOND LIMITS BETWEEN LONG 35R - 36. REMOVED AND REPLACED FITTING IAW DWG 3755845 AND SRM 51-1-20D.SDR UPS01834670Fitting · crackedINSPECTION TYPE:C2, STA 1160 BATHTUB FITTING IS CRACKED BETWEEN LONG 34R AND 35R. REMOVED AND REPLACED FITTING IAW DWG 3755843 AND SRM 53-2-0 FIG 2D.SDR UPS01834605Fitting · crackedINSPECTION TYPE:C2 STA 1160 LONG 32R BANANA FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 3755847, AND SRM 51-1-20D.SDR UPS01834597Doubler · crackedINSPECTION TYPE:C2 STA. 1340 LONG. 31L FINGER DOUBLER IS CRACKED AND CORRODED REMOVED,FABRICATED,AND REPLACED FINGER DOUBLER I.A.W. DWG. 5750322, AND SRM.51-1-20D,51-1-21SDR UPS01834593Longeron · crackedINSPECTION TYPE:C2 STA.1350 LONG. 35R IS CRACKED REMOVED AND REPLACED LONGERON ST. 1270-1350 I.A.W. DWG. 3758593,AND SRM. 51-1-20DSDR UPS01834671Panel · crackedINSPECTION TYPE:C2, LEFT HAND SIDE OF LOWER HORIZONTAL STAB FWD CONSTANT PANEL IS CRACKED BETWEEN 1ST THREE BOLT HOLES. REMOVED AND REPLACED LOWER FWD CONSTANT PANEL IAW DC8-5510-1074L.SDR UPS01834667Fitting · crackedINSPECTION TYPE:C2, STA 440 - 460 LONG 31L SPLICE FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 3750257 AND SRM 51-1-20D.SDR UPS01834663Fitting · crackedINSPECTION TYPE:C2 STA 1770 LONG 17L END FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 4772397 AND SRM 51-1-20D.SDR UPS01834662Fitting · crackedINSPECTION TYPE:C2, STA 1770 LONG 17R END FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 4772397 AND SRM 51-1-20D.SDR UPS01834595Fitting · crackedINSPECTION TYPE:C2 STA. 600 LONG. 31L SPLICE FITTING IS CRACKED. REMOVED AND REPLACED FITTING I.A.W. DWG.3750257,AND SRM. 51-1-20DSDR UPS01834598Seat Track · wornINSPECTION TYPE:C2 STA. 325 BL.0 SEAT TRACK IS WORN BEYOND LIMITS. REPAIRED SEAT TRACK I.A.W. SRM. 53-2-3 FIG.8SDR UPS01834682Frame · corrodedINSPECTION TYPE:C2, FRAME 1060 IS CORRODED BEYOND LIMITS AT LONG 36. REPAIRED FRAME IAW SRM 53-2-0 FIG 2.SDR UPS01834651Fitting · crackedINSPECTION TYPE:C2 AFT SIDE STA 1140 LONG 35L FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 3758497 AND SRM 51-1-20D.SDR UPS01834649Fitting · crackedINSPECTION TYPE:C2 STA 1152 LONG 35L FRAME TO LONGERON FITTING IS CRACKED AFT SIDE OF FRAME. REMOVED, FABRICATED AND REPLACED FITTING IAW DWG 3758570 AND SRM 51-1-20D.SDR UPS01834596Fitting · corrodedINSPECTION TYPE:C2 STA. 1152 BATHTUB FITTING BETWEEN LONG. 35R AND LONG. 36 IS CORRODED BEYOND LIMITS REMOVED AND REPLACED FITTING I.A.W. DWG. 3755845,AND SRM. 53-2-0 FIG. 2DSDR UPS01834648Fitting · crackedINSPECTION TYPE:C2 STA 340 LONG 33R BANANA FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 3755827 AND SRM 51-1-20D.SDR UPS01834647Finger Doubler · corrodedINSPECTION TYPE:C2 STA 1350 LONG 31L - 31R FINGER DOUBLER IS CORRODED BEYOND LIMITS. REMOVED, FABRICATED AND REPLACED DOUBLER IAW DWG 5779915 AND SRM 51-1-21, 51-1-20D.SDR UPS01834646Skin · corrodedINSPECTION TYPE:C2 STA 1050 - 1350 LONG 31L - 31R SKIN IS CORRODED BEYOND LIMITS. REMOVED AND REPLACED SKIN AND INTERNAL DOUBLER IAW SRM 51-3-0, 51-1-21, 51-1-20D.SDR UPS01834594Fitting · crackedINSPECTION TYPE:C2 STA. 280 BANANA FITTING IS CRACKED AT LONG. 33R REMOVED AND REPLACED FITTING I.A.W. DWG. 3755827, AND SRM. 51-1-20DSDR UPS00833081Battery Pack · dischargedEMERGENCY EXIT LIGHTS FAILED OPS CHECK. REPLACED EMERGENCY EXIT LIGHT BATTERY PACK.SDR UPS00832147Battery Pack · dischargedEMERGENCY EXIT LIGHT INOPERATIVE. REPLACED BATTERY PACK OPS CHECK OK.SDR UPS00831477Intercostal · corrodedINSPECTION TYPE:B-CK, FIRST BAY FWD OF MLG W/W JUST RT OF KEEL BEAM HAS R4 INTERCOSTAL CORRODED. REMOVED R4 INTERCOSTAL. FABRICATED NEW INTERCOSTAL FROM 2024-0 MAT AND HEAT TREATED TO T3 CONDITION IAW BAC 5602. HEAT TREATED VERIFIED. INSTALLED INTERCOSTAL SDR UPS00831476Intercostal · corrodedINSPECTION TYPE:B-CK, FIRST BAY FWD OF MLG W/W JUST RT OF KEEL BEAM HAD R3 INTERCOSTAL CORRODED. REMOVED R3 INTERCOSTAL. FABRICATED NEW INTERCOSTAL FROM 2024-0 MAT AND HEATED TO T3 CONDITION IAW BAC-5602. HEAT TREAT VERIFIED. INSTALLED INTERCOSTAL PER SRM SDR UPS00831475Intercostal · corrodedINSPECTION TYPE:B-CK, FIRST BAT FWD OF MLG W/W JUST RT OF KEEL BEAM HAD R2 INTERCOSTAL CORRODED. REMOVED R2 INTERCOSTAL. FABRICATED NEW INTERCOSTAL FROM 2024-0 MAT AND HEAT TREATED TO T3 CONDITION IAW BAC5602. HEAT TREATED VERIFIED. INSTALLED INTERCOSTAL PSDR UPS00831474Intercostal · corrodedINSPECTION TYPE:B-CK, FIRST BAT FWD OF MLG W/W JUST RIGHT OF KEEL BEAM HAS R1 INTERCOSTAL CORRODED. REMOVED R1 INTERCOSTAL. FABRICATED NEW INTERCOSTAL FROM 2024-0 MAT AND HEAT TREATED TO T3 CONDITION IAW BAC-5602. HEAT TREAT VERIFIED BY CONDUCTIVITY. INSTASDR UPS99830624Mechanism · out of adjustINSPECTION TYPE:N/A, AFTER TAKEOFF DURING GEAR RETRACTION DOOR NOT LATCHED (RIGHT) REMAINED ILLUMINATED. CHECKLIST FOLLOWED, AFTER THREE GEAR RETRACTION CYCLES LIGHT FINALLY EXTINGUISHED. ADJUSTED RIG ON RIGHT HAND MAIN GEAR DOOR ACTUATOR PER M/M 32-32-07. SDR UPS99829564Keel Beam · crackedINSPECTION TYPE:N/A, MAIN LANDING GEAR DOOR SUB KEEL BEAM STRUCTURE HAS SEVERAL CRACKS.SDR UPS99828649Shear Tie · crackedINSPECTION TYPE-C3, FS 220 LONG 30L TO 31L THE SHEAR TIE IS CRACKED. REPAIRED SHEAR TIE IAW SRM 53-2-0 FIG 2B.SDR UPS99828651Longeron · crackedINSPECTION TYPE-C3, LONG 35L AT FS 1260 TO 1280 IS CRACKED. REPAIRED LONG 35L IAW DH SK713-863.SDR UPS99828650Longeron · crackedINSPECTION TYPE-C3, LONG 34L AT FS 1260 TO 1280 IS CRACKED. REPAIRED LONG 34L IAW DH SK713-862.SDR UPS99828648Doubler · corrodedINSPECTION TYPE-C3, THE INTERNAL DOUBLER AT 620, LONG 35R TO 36, HAS HEAVY CORROSION. REPAIRED DOUBLER IAW DH SK713-629.SDR UPS99828647Fitting · corrodedINSPECTION TYPE-C3, BATH TUB FITTING CORRODED OUT OF LIMITS BETWEEN LONG 33R AND 34R AT FS 340. REMOVED AND REPLACED FITTING IAW SRM 53-2-0.SDR UPS99828607Longeron · crackedINSPECTION TYPE-C3, LONG 35R IS CRACKED AT FS 1490. REMOVED, FABRICATED AND REPLACED LONGERON IAW DWG 3646937 AND SRM 53-2-2.SDR UPS99828606Skin · corrodedINSPECTION TYPE-C3, KEEL SKIN AT FS 1070 BETWEEN LONG 35L AND 35R, IS CORRODED BEYOND LIMITS. REPAIRED SKIN IAW DH SK713-530.SDR UPS99828605Fitting · corrodedINSPECTION TYPE-C3, LONG 27R END FITTING AT FS 70 IS CORRODED BEYOND LIMITS. REMOVED AND REPLACED END FITTING IAW SRM 51-1-20D.SDR UPS99828672Doubler · crackedINSPECTION TYPE:C3 RT, WING L/E LWR SKIN BUTT SPLICE DOUBLER HAS A 30 CRACK AT XFS 341.5. REPAIRED DOUBLER IAW DH SK713-051.SDR UPS99828604Shear Tie · crackedINSPECTION TYPE-C3, SHEAR TIE AT FS 420 BETWEEN LONG 30R AND 31R IS CRACKED. REPAIRED CRACKED SHEAR TIE IAW SRM 53-2-0 FIG 2A.SDR UPS99828603Skin · crackedINSPECTION TYPE-C3, RT WING L/E LWR SKIN AT XFS 536.655 IS CRACKED AND THE INTERNAL DOUBLER HAS A PIECE MISSING. REPAIRED IAW DH SK713-942.SDR UPS99828671Fitting · corrodedINSPECTION TYPE:C3, LONGERON 21R FWD END FITTING IS CORRODED BEYOND LIMITS AT FS 70. REMOVED AND REPLACED FITTING IAW SRM 51-1-21 AND 51-3-0.SDR UPS99828602Fitting · corrodedINSPECTION TYPE-C3, LONG 30R END FITTING AT FS 70 IS CORRODED BEYOND LIMITS. REMOVED AND REPLACED FITTING IAW SRM 51-1-20D AND 51-1-21.
Back to N713UP, cancelled Aug 27, 2013