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 QXEA0101806Seat Track · damagedPDX - RT INBOARD SEAT TRACK HAS HOLE EDGE DAMAGE ON TOP OF RAIL AT APPROXIMATELY STATION 653. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101804Seat Track · damagedPDX - RT OUTBOARD SEAT TRACK HAS PITTING ON INBOARD FLANGE AT APPROXIMATELY STATION 388-405. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101803Seat Track · gougedPDX - RT OUTBOARD SEAT TRACK HAS A GOUGE IN INBOARD FLANGE AT APPROXIMATELY STATION 503. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101802Seat Track · gougedPDX - RT OUTBOARD SEAT TRACK HAS GOUGE ON TOP RAIL AT APPROXIMATELY STATION 434. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101801Seat Track · damagedPDX - RT OUTBOARD SEAT TRACK HAS PITTING ON OUTBOARD FLANGE AT APPROXIMATELY STATION 520-531. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101800Seat Track · wornPDX - RT OUTBOARD SEAT TRACK HAS A WORN SPOT ON TOP RAIL AT APPROXIMATELY STATION 593. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101799Seat Track · damagedPDX - RT OUTBOARD SEAT TRACK HAS A CHAFE ON OUTBOARD FLANGE AT APPROXIMATELY STATION 583. REPAIRED IAW FOKKER SRM 53-40-01, FIGURE 204.SDR QXEA0101798Seat Track · damagedPDX - RT OUTBOARD SEAT TRACK HAS PITTING ON OUTBOARD FLANGE AT APPROXIMATELY STATION 656-567. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR QXEA0101897Frame · crackedPDX - FRAME 12875 AND STRINGER 36 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4.SDR QXEA0101896Frame · crackedPDX - FRAME 12405 AND STRINGER 43 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4.SDR QXEA0101895Frame · crackedPDX - FRAME 12405 AND STRINGER 42 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4.SDR QXEA0101894Frame · crackedPDX - FRAME 12405 AND STRINGER 40 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4.SDR QXEA0101893Frame · crackedPDX - FRAME 12405 AND STRINGER 39 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4.SDR QXEA0101892Frame · crackedPDX - FRAME 12405 AND STRINGER 36 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4.SDR QXEA0101890Frame · crackedPDX - FRAME 11405 AND STRINGER 32 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4.SDR QXEA0101889Frame · crackedPDX - FRAME 10966 AND STRINGER 44 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4.SDR QXEA0101888Frame · crackedPDX - FRAME 10966 AND STRINGER 43 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4.SDR QXEA0101887Frame · crackedPDX - FRAME 10346 AND STRINGER 32 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4.SDR QXEA0101879Frame · crackedPDX - AFT CARGO BAY FRAME 13815B CASTELLATION TIE IN TO BELLY SKIN IS CRACKED AT STRINGER 73. REPAIRED IAW FOKKER SRM 53-02-11, FIGURE 1, PAGE 2.SDR QXEA0101878Frame · crackedPDX - AFT CARGO BAY FRAME 13815B CASTELLATION TIE IN TO BELLY SKIN IS CRACKED AT STRINGER NR 2. REPAIRED IAW FOKKER SRM 53-02-11, FIGURE 1, PAGE 2.SDR QXEA0101877Clip · crackedPDX - FUSELAGE BELLY FAIRING FRAME CLIP IS CRACKED AT FRAME 13815B AT THE 6 O'CLOCK POSITION. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0101871Stringer Clip · crackedPDX - FRAME 13815B AND STRINGER 32 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4.SDR QXEA0101870Stringer Clip · crackedPDX - FRAME 13815B AND STRINGER 40 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4.SDR QXEA0101869Stringer Clip · crackedPDX - FRAME 13815B AND STRINGER 41 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4.SDR QXEA0101867Stringer Clip · crackedPDX - FRAME 13815B AND STRINGER 45 CLIP CRACKED. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4.SDR QXEA0101805Paint · missingPDX - RT INBOARD SEAT TRACK HAS PAINT MISSING IN BOTTOM CHANNEL AT APPROXIMATELY STATION 623-638. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9-B2.SDR QXEA0101858Doubler · corrodedPDX - DOUBLER FORWARD OF FRAME 16660 BETWEEN STRINGER 1 AND 74 CORRODED. REPAIRED IAW FOKKER SRM 52-01-01, PAGE 6 AND SRM 51-10-4.SDR QXEA0101856Panel · corrodedPDX - FRETTING CORROSION PRESENT ON LT WING FUEL PANEL 71A FLANGE. REPAIRED IAW FOKKER SRM 57-01-01, PARAGRAPH 4 AND SRM 51-10-4.SDR QXEA0101855Panel · corrodedPDX - FRETTING CORROSION PRESENT ON LT WING FUEL PANEL 73A FLANGE. REPAIRED IAW FOKKER SRM 57-01-01, PARAGRAPH 4 AND SRM 51-10-4.SDR QXEA0101854Panel · corrodedPDX - FRETTING CORROSION PRESENT ON LT WING FUEL PANEL 73B FLANGE. REPAIRED IAW FOKKER SRM 57-01-01 AND SRM 51-10-4.SDR QXEA0101853Panel · corrodedPDX - FRETTING CORROSION PRESENT ON LT WING FUEL PANEL 73C FLANGE. REPAIRED IAW FOKKER SRM 57-01-01 AND SRM 51-10-4.SDR QXEA0101852Skin · corrodedPDX - LT WING FUEL ACCESS PANEL 71A, MATING FLANGE ON WING SHOWS FRETTING CORROSION. REPAIRED IAW FOKKER SRM 51-30-03, PAGE 703, PARAGRAPH 3 A-C.SDR QXEA0101796Panel · corrodedPDX - FRETTING CORROSION AROUND SCREW HOLES ON PANEL 74C. REPAIRED IAW FOKKER SRM 57-01-01 AND SRM 51-10-4.SDR QXEA0101795Panel · corrodedPDX - RIGHT WING FUEL PANEL 72A HAS FRETTING CORROSION. REPAIRED IAW FOKKER SRM 57-01-01 AND SRM 51-10-4.SDR QXEA0101794Bolt · strippedPDX - INSIDE FUEL PANEL 72A, 5TH VENT STRUT FROM FORWARD SPAR TOP AND BOTTOM OUTBOARD MOUNTING BOLTS WILL NOT TIGHTEN UP. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0101793Skin · crackedPDX - RUDDER APERTURE FOR PANEL 574 IS CRACKED AT NUT PLATE HOLES. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0101904Frame · corrodedPDX - AFT CARGO BAY FRAME 13015 CASTELLATION TIE IN TO BELLY SKIN OUTBOARD OF STRINGER 1 HAS CORROSION ON TOP SURFACE. REPAIRED IAW FOKKER SRM 51-10-04, PARAGRAPH 4B, C, PAGE 9.SDR QXEA0101903Frame · corrodedPDX - AFT CARGO BAY FRAME 13015 CASTELLATION TIE IN TO BELLY SKIN BETWEEN STRINGER 1 AND 74 HAS CORROSION ON TOP SURFACE. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9 AND SRM 53-01-01, PAGE 6.SDR QXEA0101900Frame · corrodedPDX - AFT CARGO BAY FRAME 13815A HAS CORROSION ON TOP OF FRAME UNDER FLOOR SUPPORT 4 WAY TIE-IN AT STRINGER 74. REPAIRED IAW FOKKER SRM 51-10-04, PARAGRAPH 4B, C, PAGE 9.SDR QXEA0101899Frame · corrodedPDX - AFT CARGO BAY FRAME 13815A CASTELLATION TIE-IN TO BELLY SKIN BETWEEN STRINGER 1 AND 2 HAS CORROSION ON TOP SURFACE. REPAIRED IAW FOKKER SRM 51-10-04, PARAGRAPH 4B, PAGE 9.SDR QXEA0101886Frame · corrodedPDX - AFT CARGO BAY FRAME 13815A CASTELLATION TIE-IN TO BELLY SKIN BETWEEN STRINGER 73 AND 74 HAS CORROSION ON TOP SIDE. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 6 AND SRM 51-10-04, PAGE 4.SDR QXEA0101885Skin · corrodedPDX - AFT CARGO BAY INTERIOR BELLY SKIN HAS CORROSION 1 INCH INBOARD OF STRINGER 73 EXTENDING UNDER FRAME 13815A CASTELLATION TIE-IN AT AFT SIDE OF FRAME. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 6 AND SRM 51-10-04, PAGE 4.SDR QXEA0101861Rib · crackedPDX - RUDDER STRUCTURE RIB NR 5 IS CRACKED BETWEEN RIVETS. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0101860Rib · crackedPDX - RUDDER STRUCTURE RIB NR 4 IS CRACKED BETWEEN RIVETS. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0101859Spoiler · dentedPDX - DENT ON RT NR 5 LIFE DUMPER PANEL 82G. REPAIRED IAW FOKKER SRM 51-70-0, PAGE 13, FIGURE 7, PARAGRAPH C.SDR QXEA0101792Rib · crackedPDX - FOUND NR 6 RIB CRACKED BEHIND PANEL 573. REMOVED AND REPLACED RIB PER FOKKER SRM 51-31-01.SDR QXEA0101902Frame · crackedPDX - AFT CARGO BAY FRAME 13815A CASTELLATION TIE IN TO BELLY SKIN IS CRACKED AT STRINGER 2. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4, FIGURE 2.SDR QXEA0101901Frame · crackedPDX - AFT CARGO BAY FRAME 13815A CASTELLATION TIE-IN TO BELLY SKIN IS CRACKED AT STRINGER 73. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4, FIGURE 2.SDR QXEA0101865Fitting · corrodedPDX - NR 2 NACELLE AFT MOUNT BEAM AT ENGINE CHATTER PROOF BOLT END HAS SURFACE CORROSION ON FORWARD LUG. REPAIRED IAW FOKKER SRM 51-01-04.SDR QXEA0101864Bolt · corrodedPDX - FORWARD ENGINE MOUNT BEAR ATTACH BOLTS AND NUTS HAVE SURFACE CORROSION ON RT STUB WING. REPAIRED IAW REF:43-13-1B, CHAPTER 6, PARAGRAPH 165.
Back to N482US, cancelled Mar 1, 2002