N482US, cancelled Mar 1, 2002
Service difficulty reports · 433
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 = 'N482US' AND deregistration_id = 'N482US-2002-03-01' 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 = 'N482US' AND deregistration_id = 'N482US-2002-03-01' 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 QXEA0102002Shear Tie · corrodedPDX - AFT CARGO BAY FRAME 15205 CASTELLATION TIE IN TO BELLY SKIN AT STRINGER 74 HAS CORROSION ON TOP SURFACE AROUND RIVET HOLE. REPAIRED IAW FOKKER SRM 53-02-13, SRM 51-10-04 AND SRM 51-31-01.SDR QXEA0102001Skin · corrodedPDX - AFT CARGO BAY ANTENNA BOX STRUCTURE AND AIRCRAFT INTERIOR BELLY SKIN FORWARD OF AND INSIDE BOX IS CORRODED BETWEEN STRINGER 1 AND 74 AT AFT SIDE OF FRAME 15205. REPAIRED IAW FOKKER SRM 51-31-01 AND SRM 51-31-05.SDR QXEA0102000Skin · corrodedPDX - AFT CARGO BAY FRAME 15635 DRAIN HOLE AND 90 DEGREE FLANGE AREA TOP SURFACE IS CORRODED BETWEEN STRINGER 1 AND 74 AT FORWARD SIDE OF FRAME 15635. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 6 AND SRM 51-10-04, PARAGRAPH 4 B AND C, PAGE 9.SDR QXEA0101996Skin · corrodedPDX - AFT VHF LOWER COMM ANTENNA LOCATION HAS SURFACE CORROSION ON FUSELAGE. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, PARAGRAPH 4 A AND B, SRM 51-31-01.SDR QXEA0101992Frame · crackedPDX - CASTELLATION CRACKED IN RADIUS ON FORWARD SIDE OF FRAME 50-2 ABOVE STRINGER 48. REPAIRED IAW FOKKER SRM 51-10-0, SRM 53-02-18, PAGE 5 AND SRM 53-10-05, PAGE 601.SDR QXEA0101987Frame · crackedPDX - CASTELLATION CRACKED BEYOND 1ST STOP DRILL AND PROGRESSING UP WEB OF CASTELLATION ON FRAME 17565, ABOVE STRINGER 10. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0101986Flange · crackedPDX - CENTER CARGO DOOR LOWER FORWARD CORNER FLANGE ABOVE SEAL MATING SURFACE CRACKED. REPAIRED IAW FOKKER SRM 52-02-04.SDR QXEA0101948Frame · corrodedPDX - AFT CARGO BAY FRAME 14755 HAS CORROSION ON TOP SIDE OF UPPER FLANGE FROM STRINGER 2 TO 72. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA0101943Frame · crackedPDX - FRAME 11405 LT SIDE TO CENTER WING TIE BRACKET IS CRACKED. REPAIRED IAW HORIZON AIR EA 4-53-1520.SDR QXEA0101942Rivet · chafedPDX - RIVET HEAD CHAFED THROUGH, NEAR LATCHING MECHANISM ON CENTER CARGO DOOR SUPPORT ROD. REMOVED AND REPLACED RIVET WITH CR3223 5-2 RIVET.SDR QXEA0101941Structure · dentedPDX - DENT IN CENTER CARGO DOOR, FORWARD, LOWER CORNER, 2.5 INCHES LONG, 1.2 INCHES WIDE, APPROXIMATELY .150 INCH DEEP. REPAIRED IAW FOKKER SRM 51-10-4 AMD SRM 51-31-01.SDR QXEA0101936Frame · crackedPDX - AFT CARGO BAY FRAME 15205 CASTELLATION TIE-IN TO BELLY SKIN BETWEEN STRINGER 1 AND 74 HAS CORROSION ON TOP SURFACE WITH POSSIBLE CRACKS ON VERTICAL WEB. REPAIRED IAW FOKKER SRM 51-10-01, PAGE 6 AND SRM 51-10-04, PARAGRAPH 4B, C, PAGE 9.SDR QXEA0101930Frame · crackedPDX - CASTELLATION CRACKED AT LOWER RIVET ON FRAME 20075 ABOVE STRINGER 45. REPAIRED IAW FOKKER SRM 53-02-13, FIGURE 3, PAGE 5.SDR QXEA0101989Frame · crackedPDX - CASTELLATION CRACKED ADJACENT TO LOWER RIVET ON FRAME 17565 ABOVE STRINGER 55. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 8-9 AND SRM 53-02-13.SDR QXEA0101988Frame · crackedPDX - CASTELLATION CRACKED AT TOP RIVET ON FRAME 17565 BELOW STRINGER 53. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 5.SDR QXEA0101956Skin · chafedPDX - LT SIDE COCKPIT EXTERNAL SKIN HAS A .25 INCH LONG X .100 INCH WIDE CHAFE MARK, 10 INCHES FORWARD OF FRAME 1890, CHAFE IS THROUGH ALCLAD LAYER. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 3, AREA B AND AMM 51-30-00, PAGE 701-706.SDR QXEA0101955Skin · chafedPDX - LT SIDE COCKPIT EXTERNAL SKIN HAS A .75 INCH LONG X .100 INCH WIDE CHAFE MARK, 5 INCH FORWARD OF FRAME 1890, CHAFE IS THROUGH ALCLAD LAYER. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 3, AREA B.SDR QXEA0101954Skin · chafedPDX - LT SIDE COCKPIT EXTERNAL SKIN HAS A 1.2 INCH LONG BY .150 INCH WIDE CHAFE MARK 3 INCHES FORWARD OF FRAME 1890, CHAFE IS THROUGH CLAD LAYER. REPAIRED IAW FOKKER SRM 53-01-01, PARAGRAPH D, AREA B AND SRM 51-01-4, AMM 51-30-00, PAGE 701-706.SDR QXEA0101953Duct · crackedPDX - RT ACM EXHAUST DUCT HAS A 2.5 INCH CRACK ALONG A WELD AT BOTTOM EDGE OF PANEL. REPAIRED IAW FOKKER MM 21-50-8, PAGE 401, PARAGRAPH 2 AND AMM 51-30-00, PAGE 701-706.SDR QXEA0101951Stringer · brokenPDX - RUDDER, RT STRINGER BROKEN AT RIB 6, BEHIND PANEL 57Y. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0101949Skin · dentedPDX - DENT IN FUSELAGE SKIN APPROXIMATELY .040 INCH DEEP, 1 INCH WIDE, 1 INCH LONG, LOCATED 9.375 INCH FORWARD OF CUT OUT FOR THE RT SERVICE EMERGENCY DOOR JUST BELOW STRINGER 55. REPAIRED IAW FOKKER SRM 53-02-02.SDR QXEA0101929Frame · crackedPDX - CASTELLATION CRACKED ADJACENT TO DIMPLE AT LOWER RIVET IN FRAME 17565 ABOVE STRINGER 20. REPAIRED IAW FOKKER SRM 53-02-13, FIGURE 3, PAGE 5 AND SRM 51-31-01.SDR QXEA0101928Skin · crackedPDX - LT FORWARD EMERGENCY EXIT DOOR IS CRACKED IN RADIUS ON OUTER SKIN. REPAIRED IAW FOKKER SRM 52-02-03, FIGURE 3 AND SRM 51-31-05.SDR QXEA0101927Skin · crackedPDX - LT AFT EMERGENCY EXIT DOOR IS CRACKED IN RADIUS ON OUTER SKIN. REPAIRED IAW FOKKER SRM 52-02-03, FIGURE 3.SDR QXEA0101926Skin · crackedPDX - RT AFT EMERGENCY EXIT DOOR IS CRACKED IN RADIUS ON OUTER SKIN. REPAIRED IAW FOKKER SRM 52-02-03, FIGURE 3 AND SRM 51-31-05.SDR QXEA0101925Skin · crackedPDX - RT FORWARD EMERGENCY EXIT DOOR IS CRACKED IN RADIUS ON OUTER SKIN. REPAIRED IAW FOKKER SRM 52-02-03, FIGURE 3 AND SRM 51-31-05.SDR QXEA0101924Support · chafedPDX - LT WING SKIN LOWER SURFACE SUPPORT STRUCTURE CHAFED. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 5 AND SRM 51-30-00, PAGE 701-706.SDR QXEA0101857Skin · crackedPDX - RT AFT EMERGENCY EXIT DOOR IS CRACKED IN RADUIS ON OUTER SKIN. REPAIRED IAW FOKKER SRM 52-02-03, FIGURE 3,SDR QXEA0101817Frame · crackedPDX - CASTELLATION WORKING POSSIBLY CRACKED WITH LOOSE RIVETS ON FRAME 17565 BETWEEN STRINGERS 9 AND 10. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0101816Frame · crackedPDX - CASTELLATION CRACKED BEYOND 1ST STOP DRILL ON FRAME 17565 ABOVE STRINGER 14. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0101950Stop Fitting · wornPDX - LT AFT OVERWING EMERGENCY EXIT APERTURE STOP PLATES TWO EACH ARE STEP WORN. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0101937Skin · dentedPDX - DENT IN FORWARD CARGO DOOR APERTURE, FRAME 5805, WL 50.0. REPAIRED IAW FOKKER SRM 53-02-16, PAGE 3, FIGURE 1.SDR QXEA0101935Frame · corrodedPDX - AFT CARGO BAY FRAME 15635 HAS CORROSION ON AFT SIDE BOTTOM CONNECTION FLANGE TO SKIN BETWEEN STRINGER 3 AND 73. REPAIRED IAW FOKKER SRM 53-01-01 AND SRM 51-10-04.SDR QXEA0101934Skin · corrodedPDX - AFT CARGO BAY BELLY SKIN HAS AREAS MARKED WITH CORROSION AT AFT EDGE OF LOWER CONNECTION ANGLE OF FRAME 15635 TO 8 INCHES AFT OF FRAME BETWEEN STRINGER 2 AND 73. REPAIRED IAW FOKKER SRM 53-01-01 AND SRM 51-10-04.SDR QXEA0101933Frame · corrodedPDX - AFT CARGO BAY ANGLED FRAME THAT TIES INTO FORWARD END OF DOOR LOWER TORSION BOX AT FRAME 15810 HAS CORROSION AT FORWARD AND AFT SIDE OF STRINGER 1 AND 74 CUTOUTS. REPAIRED IAW FOKKER SRM 53-01-01 AND SRM 51-10-04.SDR QXEA0101932Frame · crackedPDX - CASTELLATION CRACKED AT LOWER RIVET HOLE ON FRAME 32-2 ABOVE STRINGER 14. REPAIRED IAW FOKKER SRM 53-10-05, PAGE 601-601A AND SRM 51-31-01.SDR QXEA0101931Frame · crackedPDX - CASTELLATION CRACKED ADJACENT TO LOWER RIVET ON OBLIQUE FRAME 16-2 ABOVE STRINGER 12. REPAIRED IAW FOKKER SRM 53-10-05, PAGE 601-601A AND SRM 51-31-01.SDR QXEA0101923Frame · crackedPDX - CASTELLATION CRACKED IN RADIUS UPPER AND AFT SIDE OF FRAME 50-2 BELOW STRINGER 24. REPAIRED IAW FOKKER SRM 53-10-05, PAGE 601-601A AND SRM 51-31-01.SDR QXEA0101921Frame · crackedPDX - CASTELLATION CRACKED AT LOWER RIVET ON FORWARD SIDE OF FRAME 50-2 ABOVE STRINGER 61. REPAIRED IAW FOKKER SRM 53-10-05, PAGE 601-601A, SRM 51-31-01, PAGE 14(E).SDR QXEA0101920Frame · crackedPDX - CASTELLATION CRACKED AT LOWER RIVET ON FORWARD SIDE OF FRAME 41-2 ABOVE STRINGER 61. REPAIRED IAW FOKKER SRM 51-31-01, PAGE 14(E) AND SRM 53-10-05, PAGE 601-601A.SDR QXEA0101919Frame · crackedPDX - CASTELLATION CRACKED IN RADIUS AT JOGGLE ON AFT SIDE OF FRAME 32-2 ABOVE STRINGER 29. REPAIRED IAW FOKKER SRM 53-10-05, PAGE 601-601A AND SRM 51-31-01.SDR QXEA0101916Frame · crackedPDX - CASTELLATION CRACKED AT LOWER RIVET OF FORWARD SIDE OF FRAME 50-2 ABOVE STRINGER 14. REPAIRED IAW FOKKER SRM 53-10-05, PAGE 601-601A AND SRM 51-31-01.SDR QXEA0101898Frame · crackedPDX - FRAME 12875 AND STRINGER 42 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4 AND SRM 51-31-01.SDR QXEA0101891Frame · crackedPDX - FRAME 11405 AND STRINGER 43 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4.SDR QXEA0101884Frame · crackedPDX - FRAME 13815A AND STRINGER 46 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4 AND SRM 51-31-01.SDR QXEA0101883Frame · crackedPDX - FRAME 13815A AND STRINGER 41 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4 AND SRM 51-31-01.SDR QXEA0101882Frame · crackedPDX - FRAME 13815A AND STRINGER 31 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4 AND SRM 51-31-01.SDR QXEA0101881Frame · crackedPDX - FRAME 13345 AND STRINGER 28 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13 AND SRM 51-31-01.SDR QXEA0101880Frame · crackedPDX - FRAME 13345 AND STRINGER 36 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4, AND SRM 51-31-01.SDR QXEA0101876Rivet · loosePDX - FUSELAGE SKIN TO FRAME 13815A RIVET IS LOOSE AND DOES NOT FILL THE COUNTERSINK. REPAIRED IAW FOKKER SRM 51-31-01.
Back to N482US, cancelled Mar 1, 2002