N857NW
Service difficulty reports · 226
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 = 'N857NW' AND registry_match = 'registration' 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 = 'N857NW' AND registry_match = 'registration' 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 DALA1031163357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y1552 FR 33. REPAIRED PER SRM 53-00-15 FIGURE 102, ERA 486597-14 REV 0.SDR DALA1031153357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y1552 FR 33. REPAIRED PER SRM 53-00-15 FIGURE 102, ERA 486597-14 REV 0.SDR DALA1031143357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR 56, FR 57 & FR 58. REPAIRED PER SRM 53-00-15 FIGURE 102, ERA 486597-14 REV 0.SDR DALA1031133357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y2462 FR 33. REPAIRED PER SRM 53-00-15 FIGURE 102, SRM 53-00-015 FIGURE 204 & ERA 486604-14 REV 0.SDR DALA1031123357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR 36. REPAIRED PER SRM 53-00-15 FIGURE 102, SRM 53-00-15 FIGURE 204 & ERA 486606-14 REV 0.SDR DALA1031113357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y 1959 FR 33. REPAIRED PER SRM 53-00-15 FIGURE 102, ERA 486993-14 REV 0.SDR DALA1031103357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR 55- FR 56, FR 57- FR 58. REPAIRED PER SRM 53-00-15, ERA 486597-14 REV 0.SDR DALA1031093357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR 48- FR 49, FR 50- FR 51. REPAIRED PER ERA 486597-14 REV 0.SDR DALA1031083357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR 58- FR 59, FR 59- FR 60 & FR 62. REPAIRED PER SRM 53-00-15 FIGURE 102, SRM 51-42-11.SDR DALA1031073357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR 53.3, FR 53.4, FR 53-5. REPAIRED PER SRM 51-74-00, SRM 53-31-15 FIGURE 101, SRM 51-42-11.SDR DALA1031063357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y953 FR 51 TO FR 53.1. REPAIRED PER SRM 51-74-00, SRM 53-31-15 FIGURE 1 & SRM 51-42-11.SDR DALA1031053357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR 48, FR 50 & SR 53.1. REPAIRED PER SRM 53-31-15 FIGURE 101 & SRM 51-42-11.SDR DALA1030943357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR 68 FR 71. REPAIRED PER SRM 51-74-00, SRM 53-00-15 FIGURE 204 & SRM 51-42-11.SDR DALA1030933357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR 54- FR 55. REPAIRED PER SRM 53-00-15 FIGURE 204 & SRM 51-42-11.SDR DALA1030923357Profile · crackedDURING H-CHECK FOUND CRACK IN LEFT Z PROFILE IN ZONE 270. REPAIRED PER SRM 51-42-11 AND AA 5322-01022.SDR DALA1029043357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR 72-FR 73. REPAIRED PER SRM 51-74-00, SRM 53-00-15 FIGURE 102 & SRM 51-42-11.SDR DALA1029033357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y2462 FR 60-FR 62. REPAIRED PER SRM 51-74-00, SRM 53-00-15 FIGURE 102 & SRM 51-42-11.SDR DALA1029023357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR 72- FR 73. REPAIRED PER SRM 51-74-00, SRM 53-00-15 FIGURE 102 & SRM 51-42-11.SDR DALA1029013357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y1456 FR 19. REPAIRED PER SRM 51-74-00, SRM 53-00-15 FIGURE 102 & SRM 51-42-11. REPLACEMENT FOR SDR DALA1033572901.SDR DALA1033572901Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y1456 FR 19. REPAIRED PER SRM 51-74-00, SRM 53-00-15 FIGURE 102 & SRM 51-42-11.SDR DALA1030743357Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y2462 FR63- FR 68. REPAIRED PER SRM 51-42-11.SDR DALA1032883357Skin · dentedDURING H-CHECK, FOUND BULK CARGO DOOR EXTERIOR SKIN LWR AREA, FOUND DENT AS MARKED. BULK CARGO DOOR EXTERIOR SKIN LWR AREA , DENT MEASURED 1.5"LONG, 0.700" WIDE, DEPTH:0.050".REPAIR CARRIED OUT PER ERA 487004-14 REV 0 DATED 11 NOV 2010, 10:42HRS, AND IDENTIFISDR DALA106263357Power Supply · no testDURING TEST OF EPSU (16WL) AT DOOR 3 FAILED CAPACITY CHECK. MX REPLACED POWER SUPPLY UNIT AND BATTERY. OPS CHECK WAS NORMAL. ACFT RETURNED TO SERVICE.SDR DALA106253357Power Supply · inoperativeDURING TEST OF EPSU (18WL) AT DOOR 4 FAILED CAPACITY CHECK. MX REPLACED POWER SUPPLY UNIT AND BATTERY. OPS CHECK WAS NORMAL. ACFT RETURNED TO SERVICE.SDR DALA106273357Power Supply · no testDURING TEST OF EPSU (15WL) AT DOOR 3 FAILED CAPACITY CHECK. MX REPLACED POWER SUPPLY UNIT AND BATTERY. OPS CHECK WAS NORMAL. ACFT RETURNED TO SERVICE.SDR DALA102723357Control Panel · smokeBURNING RUBBER ODOR IN CABIN, DEACTIVATED VIDEO CONTROL CTR IAW QRH SMOKE CABIN VIDEO SMOKE PROCEDURE, ODOR DISSIPATED AND LANDING WAS UNEVENTFUL. INSPECTED AND TESTED IFE AND NO BURNING ODOR DETECTED, ACFT CHECKS OK.
Back to N857NW