N484US, cancelled Aug 14, 2002
Service difficulty reports · 317
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 = 'N484US' AND deregistration_id = 'N484US-2002-08-14' 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 = 'N484US' AND deregistration_id = 'N484US-2002-08-14' 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 QXEA0002201Doubler · damagedPDX- DISCOVERED HOLE ON DOUBLER PLATE STATION 181496 STRINGER 5. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 8.SDR QXEA0002200Structure · corrodedPDX- AFT CARGO DOOR HINGE ATTACH POINT ON DOOR OPENING APERTURE AFT NUT PLATE BULGED. REPAIRED IAW FOKKER SRM 51-31-01, PAGE 13 AND SRM 51-31-05.SDR QXEA0002175Skin · nickedPDX- SKIN NICKED ON RIGHT SIDE OF ANTENNA MOUNT ON AFT FUSELAGE BETWEEN FRAME 16060 AND 16660. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 6, AND SRM 51-30-03, PAGE 703.SDR QXEA0002171Bracket · gougedPDX- RIGHT HAND AIR CYCLE MACHINE BAY SKIN BELOW UPPER AIR CYCLE MACHINE MOUNT BRACKET IS DENTED AND GOUGED. REPAIRED IAW FOKKER SRM 53-02-01.SDR QXEA0002170Bracket · gougedPDX- LEFT HAND BAY SKIN BELOW UPPER AIR CYCLE MACHINE BRACKET IS DENTED AND GOUGED. REPAIRED IAW FOKKER SRM 53-02-01.SDR QXEA0002263Angle · crackedPDX- REPAIR ANGLE CRACKED AT INBOARD RIVET ON BOTTOM LEFT HAND CENTER OF FUSELAGE FORWARD EDGE OF 91BC. REPAIRED IAW FOKKER SRM 53-53-04 PAGE 15 AND 51-31-01.SDR QXEA0002158Skin · chafedPDX- CHAFE ON RIGHT HAND INBOARD FLAP UPPER SKIN, 27.5 INCHES FORWARD OF TRAILING EDGE. REPAIRED IAW FOKKER SRM 57-02-05 AND 51-10-4.SDR QXEA0002257Rivet · missingPDX- 2 RIVETS ON THE EXTERNAL FUSELAGE SKIN JUST FORWARD OF THE APU EXHAUST REQUIRES INSTALLATION. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0002180Clip · crackedPDX- FRAME CLIP CRACKED AT 13815B BETWEEN STRINGER 2 AND 3. REPAIRED IAW FOKKER SRM 53-02-13 AND SRM 51-31-01.SDR QXEA0002179Clip · crackedPDX- FRAME CLIP CRACKED AT FRAME 13815A BETWEEN STRINGER 2 AND 3. REPAIRED IAW FOKKER SRM 53-02-13 AND SRM 51-31-01.SDR QXEA0002178Clip · crackedPDX- CLIP AT FRAME 16060 CRACKED AT STRINGER 1 AND 2. REPAIRED IAW FOKKER SRM 53-02-13 AND SRM 51-31-01.SDR QXEA0002176Clip · crackedPDX- FRAME CLIP AT FRAME 16660 CRACKED BETWEEN STRINGERS 1 AND 74. REPAIRED IAW FOKKER SRM 53-02-13 AND SRM 51-31-01.SDR QXEA0002173Flange · dentedPDX- ACCESS DOOR 21A AFT FLANGE DENTED. REPAIRED IAW FOKKER SRM 52-40-03 AND SRM 51-10-4.SDR QXEA0002172Flange · chafedPDX- ACCESS DOOR 23A IS CHAFED AROUND DOOR FLANGE. REPAIRED IAW FOKKER SRM 52-01-01 AND SRM 51-10-4.SDR QXEA0002066Clip · crackedPDX- CRACKED CLIP AT FRAME 9305, LOWER INBOARD SIDE OF LEFT HAND INBOARD SEAT TRACK. REPAIRED IAW FOKKER SRM 51-31-01 AND 51-30-02.SDR QXEA0002072Clip · crackedPDX- CLIP CRACKED ON BOTH ENDS AT FRAME 16660 AND STRINGER 58. REPAIRED IAW FOKKER SRM 53-02-13 PAGE 4 FIGURE 2.SDR QXEA0002261Skin · chafedPDX- AFT EDGE OF NOSE LANDING GEAR APERTURE IS CHAFED BY RIGHT NOSE GEAR DOOR. REPAIRED IAW FOKKER SRM 52-01-01 AND 53-01-01.SDR QXEA0002250Rivet · loosePDX- LEFT HAND WING AT STATION 1700 INBOARD FLAP HAS 5 SMOKING RIVETS. REPAIRED IAW FOKKER SRM 51-00-00 AND HORIZON AIR EA 4-57-441.SDR QXEA0002227Angle · loosePDX- RIGHT VERTICAL CONNECTION ANGLE HAS LOOSE HI-LOKS AT FRONT SPAR. REPAIRED IAW FOKKER SRM 51-30-02.SDR QXEA0002226Angle · loosePDX- RIGHT VERTICAL CONNECTION ANGLE HAS LOOSE AND SMOKING HI-LOKS AT SPAR 1. REPAIRED IAW FOKKER SRM 51-30-02.SDR QXEA0002224Angle · crackedPDX- RIGHT VERTICAL CONNECTION ANGLE CRACKED AT HI-LOK HOLES AT SPAR 2. REPAIRED IAW FOKKER SRM 55-31-00.SDR QXEA0002222Angle · crackedPDX- LEFT HAND VERTICAL CONNECTION ANGLE CRACKED AT HI-LOK HOLES AT SPAR 1. REPAIRED IAW FOKKER SRM 55-31-00.SDR QXEA0002221Angle · crackedPDX- LEFT VERTICAL CONNECTION ANGLE CRACKED AT HI-LOK HOLES AT SPAR 2. REPAIRED IAW FOKKER SRM 55-31-00.SDR QXEA0002184Angle · crackedPDX- ANGLE CRACKED AT FRAME 4175 ABOVE STRINGER 12. REPAIRED IAW FOKKER SRM 53-14-06, PAGE 2 AND SRM 51-31-01.SDR QXEA0002183Angle · crackedPDX- ANGLE CRACKED FORWARD OF FRAME 4175 ABOVE STRINGER 12. REPAIRED IAW FOKKER SRM 53-14-06, PAGE 2 AND SRM 51-31-01.SDR QXEA0002182Angle · crackedPDX- ANGLE CRACKED AFT OF FRAME 4175 ABOVE STRINGER 12. REPAIRED IAW FOKKER SRM 53-14-06, PAGE 2 AND SRM 51-31-01.SDR QXEA0002270Frame · corrodedPDX- AFT CARGO PIT FRAME 13815A HAS CORROSION ON FRAME NUT PLATE ABOVE STRINGER 74. REPAIRED IAW FOKKER SRM 51-31-01 AND HORIZON AIR EA 4-53-1280.SDR QXEA0002204Stringer Clip · crackedPDX- FRAME 16060 STRINGER 56 CLIP IS CRACKED. REPAIRED IAW FOKKER SRM 53-10-05, PAGE 601 AND SRM 53-02-13, PAGE 4.SDR QXEA0002192Frame · corrodedPDX- FRAME CAP AND SPLICE AT FRAME 13815A HAS EXFOLIATION CORROSION ABOVE STRINGER 74. REPAIRED IAW FOKKER SRM 51-31-01 AND HORIZON AIR EA 4-53-1280.SDR QXEA0002185Clip · crackedPDX- CLIP CRACKED AT FRAME 4175, LOWER OUTBOARD SIDE OF LEFT HAND INBOARD SEAT TRACK. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0002181Mount · corrodedPDX- ANTENNA MOUNT BETWEEN 15205 FRAME TO 15635, STRINGER 1 AND 74 HAS CORROSION AND NO PAINT. REPAIRED IAW FOKKER SRM 51-10-4.SDR QXEA0002080Clip · crackedPDX- CRACKED CLIP AT FRAME 16060 AND STRINGER 45. REPAIRED IAW FOKKER SRM 53-02-13 PAGE 4 FIGURE 2.SDR QXEA0002079Clip · crackedPDX- CRACKED CLIP AT FRAME 16060 AND STRINGER 43. REPAIRED IAW FOKKER SRM 53-02-13 PAGE 4 FIGURE 2.SDR QXEA0002078Clip · crackedPDX- SUSPECTED CRACKED CLIP AT FRAME 16060 AND STRINGER 46. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0002077Clip · crackedPDX- SUSPECTED CRACKED CLIP AT FRAME 16060 AND STRINGER 47. REPAIRED IAW FOKKER SRM 53-02-13 PAGE 4 FIGURE 2.SDR QXEA0002076Clip · crackedPDX- SUSPECTED CRACKED CLIP AT FRAME 16060 AND STRINGER 48. REPAIRED IAW FOKKER SRM 53-02-13 PAGE 4 FIGURE 2.SDR QXEA0002075Clip · crackedPDX- SUSPECTED CRACKED CLIP AT FRAME 16660 AND STRINGER 50. REPAIRED IAW FOKKER SRM 53-02-13 PAGE 4 FIGURE 2.SDR QXEA0002074Clip · crackedPDX- SUSPECTED CRACKED CLIP AT FRAME 16660 AND STRINGER 32. REPAIRED IAW FOKKER SRM 53-02-13 PAGE 4 FIGURE 2.SDR QXEA0002073Clip · crackedPDX- SUSPECTED CRACKED CLIP AT FRAME 16660 AND STRINGER 30. REPAIRED IAW FOKKER SRM 53-02-13 PAGE 4 FIGURE 2 AND 53-02-13.SDR QXEA0002071Clip · crackedPDX- CRACKED CLIP AT FRAME 16660 AND STRINGER 57. REPAIRED IAW FOKKER SRM 53-02-13 PAGE 4 FIGURE 2.SDR QXEA0002070Clip · crackedPDX- CRACKED CLIP AT FRAME 16660 AND STRINGER 44. REPAIRED IAW FOKKER SRM 53-02-13 PAGE 4 FIGURE 2.SDR QXEA0002067Angle · crackedPDX- CRACKED ANGLE AT AFT INBOARD LOWER CORNER OF LEFT MAIN WHEEL WELL AT FRAME 13345. REPAIRED IAW HORIZON AIR EA 4-53-1286.SDR QXEA0002167Duct · crackedPDX- AIR CYCLE MACHINE OUTLET HAS POSSIBLE CRACK AT LOWER FORWARD CORNER. REPAIRED IAW FOKKER SRM 51-31-01, SRM 51-10-6 AND HORIZON AIR EA 4-53-1283.SDR QXEA0002157Access Panel · corrodedPDX- RIGHT HAND WING FUEL TANK ACCESS HATCH PANEL 74E HAS LITE FRETTING CORROSION ON PANEL MATTING SURFACE AROUND SCREW HOLES. REPAIRED IAW FOKKER SRM 57-01-01 PAGE 5 AND 51-10-4 PAGE 9.SDR QXEA0002156Access Panel · corrodedPDX- RIGHT HAND WING FUEL TANK ACCESS HATCH PANEL 74D HAS LITE FRETTING CORROSION ON PANEL MATTING SURFACE AROUND SCREW HOLES. REPAIRED IAW FOKKER SRM 57-01-01 PAGE 5 AND 51-10-4 PAGE 9.SDR QXEA0002153Access Panel · corrodedPDX- RIGHT HAND WING FUEL TANK ACCESS HATCH PANEL 74A HAS LITE FRETTING CORROSION ON PANEL MATTING SURFACE AROUND SCREW HOLES. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 8-9 AND 57-01-01 PAGE 5.SDR QXEA0002152Access Panel · corrodedPDX- RIGHT HAND WING FUEL TANK ACCESS HATCH PANEL 72A HAS LITE FRETTING CORROSION ON PANEL MOUNTING SURFACE AROUND SCREW HOLES. REPAIRED IAW FOKKER SRM 57-01-01 PAGE 5.SDR QXEA0002136Seat Track · gougedPDX- 3.5 INCHES AFT OF STATION 9805 TWO LUGS ARE GOUGED ON TOP FLANGE OF LEFT HAND OUTBOARD SEAT TRACK. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002135Seat Track · scratchedPDX- LEFT HAND OUTBOARD SEAT TRACK CHANNEL IS SCRATCHED 6 INCHES AFT OF STATION 9305. REPAIRED IAW FOKKER 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002134Seat Track · gougedPDX- SIX INCHES AFT OF STATION 9305 TOP FLANGE GOUGED ON BOTH SIDES OF TWO CUTOUTS OF LEFT HAND OUTBOARD SEAT TRACK. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.
Back to N484US, cancelled Aug 14, 2002