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 QXEA0101875Frame · crackedPDX - FRAME 15205 AND STRINGER 21 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 9 AND SRM 51-31-01.SDR QXEA0101874Frame · crackedPDX - FRAME 15205 AND STRINGER 53 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 9 AND SRM 51-31-01.SDR QXEA0101873Frame · crackedPDX - FRAME 15205 AND STRINGER 52 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4 AND SRM 51-31-01.SDR QXEA0101872Stringer Clip · crackedPDX - FRAME 14285 AND STRINGER 47 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0101868Stringer Clip · crackedPDX - FRAME 13815B AND STRINGER 47 CLIP CRACKED. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0101847Clip · crackedPDX - FRAME CLIP CRACKED AT STRINGER 47 AND FRAME 16060. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4 AND SRM 51-31-01.SDR QXEA0101822Frame · crackedPDX - CASTELLATION CRACKED AT LOWER RIVET ON FORWARD SIDE OF FRAME 50-2, ABOVE STRINGER 25. REPAIRED IAW FOKKER SRM 51-10-4, SRM 53-02-13, PAGE 5 AND SRM 53-10-05.SDR QXEA0101821Frame · crackedPDX - CASTELLATION CRACKED PAST PREVIOUS STOP DRILL ON AFT SIDE OF FRAME 16-2, ABOVE STRINGER 29. REPAIRED IAW FOKKER SRM 53-10-05, PAGE 601-601A AND FOKKER MM 51-31-01.SDR QXEA0101819Skin · crackedPDX - EMPENNAGE SKIN GOUGED FROM INSIDE, FORWARD OF OBLIQUE FRAME 58.5-2, ABOVE STRINGER 9, APPROXIMATELY .2 INCHES LONG, .050 INCH WIDE, .040 INCH DEEP. REPAIRED IAW FOKKER SRM 53-02-01, PAGE 3.SDR QXEA0101818Frame · crackedPDX - CASTELLATION CRACKED AT JOGGLE FOR LOWER RIVET ON FRAME 17565 ABOVE STRINGER 50. REPAIRED IAW FOKKER SRM 53-10-05, PP 601A AND SRM 53-02-13, PAGE 5.SDR QXEA0101815Frame · crackedPDX - POSSIBLE CRACK IN CASTELLATION ADJACENT TO DIMPLE AT LOWER RIVET IN FRAME 17565, ABOVE STRINGER 19. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0101814Rivet · missingPDX - ATTACH ANGLES MISSING RIVETS ABOVE RT FIXED WINDOW, FRAME STATION 4050 AND STRINGER 45. REPAIRED IAW FOKKER MM 51-31-01.SDR QXEA0101797Floorbeam · corrodedPDX - FLOORBEAM BL600L FROM FRAME 3820 TO 4900 TOP TIE PLATE HAS LARGE BUBBLES OF PAINT AND CORROSION. REPAIRED IAW FOKKER SRM 51-10-4 AND SRM 51-31-01.SDR QXEA0101998Clip · corrodedPDX - FRAME 16660 CLIP CORRODED AT STRINGER 74. REPAIRED IAW FOKKER SRM 53-01-01 AND SRM 51-10-04.SDR QXEA0101866Frame · corrodedPDX - AFT CARGO BAY FRAME 15205 CASTELLATION TIE-IN TO BELLY SKIN HAS CORROSION ON TOP SURFACE AT STRINGER 3. REPAIRED IAW FOKKER SRM 53-01-01 AND SRM 51-10-04.SDR QXEA0101820Frame · crackedPDX - CASTELLATION CRACKED IN RADIUS LOWER END OF FRAME 32-2, FORWARD SIDE ABOVE STRINGER 23. REPAIRED IAW FOKKER MM 53-10-05, PAGE 610-601A.SDR QXEA0102004Rudder · damagedPDX - REMOVE RUDDER FOR SHEET METAL REPAIR. REPAIRED IAW FOKKER MM 27-20-01, PAGE 404, PARAGRAPH 3D AND MM 27-20-02, PAGE 201.SDR QXEA0101862Frame · corrodedPDX - AFT CARGO BAY FRAME 16060 HAS CORROSION ON TOP SURFACE OF LOWER FLANGE ON FORWARD SIDE BETWEEN STRINGER 1 AND 74. REPAIRED IAW FOKKER SRM 51-10-01 AND SRM 51-10-04.SDR QXEA0101851Skin · corrodedPDX - LT WING FUEL ACCESS PANEL 73A, MATING FLANGE ON WING SHOWS FRETTING CORROSION. REPAIRED IAW FOKKER SRM 51-30-03, PAGES 703 AND 704, PARAGRAPH 3-C, STEPS 1 THRU 10.SDR QXEA0101850Panel · corrodedPDX - LT WING FUEL ACCESS PLATE 73B, MATING FLANGE ON WING SHOWS FRETTING CORROSION. REPAIRED IAW FOKKER SRM 51-30-03, PAGES 703-704, PARAGRAPH 3-C STEPS 1 -10.SDR QXEA0101849Panel · corrodedPDX - LT WING FUEL ACCESS PANEL 73C MATING FLANGE ON WING SHOWS LIGHT FRETTING CORROSION. REPAIRED IAW FOKKER SRM 51-30-03, PAGES 703-704, PARAGRAPH 3-C, STEPS 1-10.SDR QXEA0101848Seat Track · wornPDX - LT OUTBOARD SEAT TRACK HAS WORN AREA AT BOTTOM OF GROOVE APPROXIMATELY STATION 192. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101843Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK HAS LIGHT PITTING CORROSION ON OUTBOARD FLANGE AT APPROXIMATELY STATION 331 TO 335. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101842Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK HAS SEVERAL GOUGES ON TOP OF RAIL AT APPROXIMATELY STATION 677 TO 683. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101841Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK HAS A GOUGE ON TOP OF TRACK AT APPROXIMATELY STATION 673.5. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101840Seat Track · scratchedPDX - LT OUTBOARD SEAT TRACK HAS A SCRATCH ON TOP OF RAIL AT APPROXIMATELY STATION 491. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101839Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION BOTTOM OF CHANNEL AT APPROXIMATELY STATION 223 TO 225. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101838Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION AT APPROXIMATELY STATION 228 TO 242, BOTTOM OF CHANNEL. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101837Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION ON INBOARD FLANGE AT APPROXIMATELY STATION 248-249. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101836Seat Track · wornPDX - LT INBOARD SEAT TRACK HAS WORN AREA FRONT TOP EDGE OF RAIL AT APPROXIMATELY STATION 254. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101835Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION INBOARD FLANGE AT APPROXIMATELY STATION 306. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101834Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION ON INBOARD FLANGE AT APPROXIMATELY STATION 327 TO 330. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101833Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION AT APPROXIMATELY STATION 331-333 ON INBOARD FLANGE. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 1B(2).SDR QXEA0101832Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION ON OUTBOARD FLANGE AT APPROXIMATELY STATION 347-357. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101831Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION IN BOTTOM OF CHANNEL AT APPROXIMATELY STATION 357-359. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101830Seat Track · damagedPDX - LT INBOARD SEAT TRACK HAS SLIGHT DAMAGE TO HOLE EDGE AT APPROXIMATELY STATION 370-371. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101829Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION ON INBOARD FLANGE AT APPROXIMATELY STATION 376-425. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101828Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING ON OUTBOARD FLANGE AT APPROXIMATELY STATION 475-478. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101827Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION ON OUTBOARD FLANGE AT APPROXIMATELY STATION 510-520. REPAIRED IAW FOKKER MM 53-40-01, PAGE 205, FIGURE 204 AND SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101826Seat Track · gougedPDX - LT INBOARD SEAT TRACK HAS SEVERAL GOUGES IN TOP OF RAIL THE DEEPEST APPROXIMATELY .003 INCH AT APPROXIMATELY STATION 510-512. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101825Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION IN BOTTOM OF CHANNEL AT APPROXIMATELY STATION 559-562. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101824Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION ON INBOARD FLANGE AT APPROXIMATELY STATION 561-563. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101823Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS LIGHT PITTING CORROSION ON OUTBOARD FLANGE AT APPROXIMATELY STATION 684-695. REPAIRED IAW FOKKER SRM 51-10-4, PARAGRAPH 4B(2).SDR QXEA0101813Seat Track · corrodedPDX - RT INBOARD SEAT TRACK HAS LIGHT CORROSION ON TOP OF RAIL AT APPROXIMATELY STATION 180.5 TO 187. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101812Seat Track · corrodedPDX - RT INBOARD SEAT TRACK HAS PITTING CORROSION ON INBOARD AND OUTBOARD FLANGES AT APPROXIMATELY STATION 202-256. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 9-B2.SDR QXEA0101811Seat Track · damagedPDX - RT INBOARD SEAT TRACK HAS PITTING ON INBOARD FLANGE AT APPROXIMATELY STATION 193-200. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101810Seat Track · damagedPDX - RT INBOARD SEAT TRACK HAS PITTING ON INBOARD FLANGE AT APPROXIMATELY STATION 256-272. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101809Seat Track · damagedPDX - RT OUTBOARD SEAT TRACK HAS PITTING ON OUTBOARD FLANGE AT APPROXIMATELY STATION 387-398. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101808Seat Track · gougedPDX - RT OUTBOARD SEAT TRACK HAS A GOUGE ON THE TOP RAIL AT APPROXIMATELY STATION 337-338. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101807Seat Track · wornPDX - RT OUTBOARD SEAT TRACK HAS WEAR ON TOP OF RAIL AT APPROXIMATELY STATION 195-196. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.
Back to N482US, cancelled Mar 1, 2002