N851NW
Service difficulty reports · 250
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 = 'N851NW' 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 = 'N851NW' 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 DALA13019603351Seat Track · corrodedSEAT TRACK IN ZONE 250 AT -Y450 FR40 AND FR46 FOUND CORRODED. REPLACED SEAT TRACK.SDR DALA13019593351Seat Track · corrodedSEAT TRACK IN ZONE 260 AT Y2462 FR59 TO FR61 FOUND CORRODED. REPLACED SEAT TRACK.SDR DALA13019583351Seat Track · corrodedSEAT TRACK IN ZONE 260 AT Y450 FR 55 AND FR 58 FOUND CORRODED. REPLACED SEAT TRACK.SDR DALA13019573351Seat Track · corrodedZONE 260 SEAT TRACK AT -Y450 FR55 AND FR58 FOUND CORRODED. REPLACED SEAT TRACK.SDR DALA13019563351Seat Track · corrodedZONE 250 SEAT TRACK AT Y-450 FR 53.8 FOUND CORRODED. REPLACED SEAT TRACK.SDR DALA13019043351Seat Track · corrodedSEAT TRACK AT Y1959, FOUND CORRODED AT FR 48 AND FR 53.1. CORROSION REMOVED IAW SRM 51-74-00, FOUND EXCEED LIMITS IAW SRM 5 3-31-15, FIG 101. DAMAGED SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13017553351Seat Track · corrodedSEAT TRACK AT Y1959 FOUND CORRODED AT FR47 & FR53. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND OUT OF LIMIT IAW SRM 53-31-15, FIG 101. DAMAGED SEAT TRACK, R & R IAW SRM 51-42-11.SDR DALA13016483351Seat Track · damagedSEAT TRACK AT -Y450 FOUND CORRODED AT FR48 & FR53. CORROSION REMOVED IAW SRM 51-74-00. FOUND OUT OF LIMIT SRM 53-31-15, FIG 101. DAMAGED SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13016473351Seat Track · damagedSEAT TRACK AT Y450 FOUND CORRODED AT FR48 & FR53. CORROSION REMOVED IAW SRM 51-74-00. FOUND OUT OF LIMIT IAW SRM 53-31-15, FIG 101. DAMAGED SEAT TRACK R & R IAW-SRM 51-42-11.SDR DALA13004103351Skin · damagedFOUND DAMAGE TO L4 DOOR LOWER AFT CORNER 1" TEAR IN SKIN AND DENTED THRU 6" RADIUS WITH SEAL RETAINER DEFORMED. REMOVED DAMAGE AND FABRICATED REPAIR PARTS IAW SRM 52-13-00. DRILLED NEW AFT CORNER SEAL RETAINER FITTING OK TO INSTALL REPAIR IAW SRM. INSTALLED SDR DALA12002263351Skin · damagedSKIN DAMAGED AT FR 0- FR 1 AND APPROXIMATELY 33 INCHES UP/DOWN AND 10 INCHES FWD/AFT. REPAIRED AS PER ERA 504502-14REV.0.SDR DALA12001453351Skin · misrepairedDURING K CHECK, FOUND A DOUBLE DRILLED FASTENER AT A EXISTING TEMPORARY LIGHTING STRIKE REPAIR, FR-57, STR-46R. REPAIR WAS ACCOMPLISHED PER SEC 1 OF ERA50264-14.SDR DALA1158133351Battery · dischargedAIRCRAFT 3351. DURING EMERGENCY LIGHT TEST, MAINTENANCE FOUND BATTERY 11WL AND 17WL FAULTED. MAINTENANCE REPLACED BOTH BATTERIES (11WL, 17WL) PER AMM. ALL TEST PER AMM GOOD.SDR DALA1113793351Brake Sys · warning lightIMMEDIATELY AFTER INITIATING TAKEOFF POWER AND ROLL (RUNWAY 24), AMS TOWER DIRECTED US TO ABORT TAKEOFF DUE TO AN UNEXPECTED GO-AROUND ON RUNWAY 18C. RECEIVED CAUTION FOR "BRAKE NR 5 RELEASED"; EXITED RUNWAY AND THEN RECEIVED ANOTHER CAUTION "GREEN HYDRAULIC SDR DALA109153351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y1552.5, FR32-FR37. REPAIRED IAW ERA 481432-14.SDR DALA109143351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR40-FR47. REPAIRED IAW ERA 481432-14.SDR DALA109133351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR54-FR58. REPAIRED IAW ERA 481432-14, REV 0.SDR DALA109123351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR55-FR58. REPAIRED IAW ERA 481432-14.SDR DALA109113351Floor Support · corrodedDURING H-CHECK FOUND CORROSION ON FLOOR STRUCTURE AT Y1456 FR17. REPAIRED IAW ERA 481359-14, REV O.SDR DALA109103351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y2462 FR54-FR58. REPAIRED IAW ERA 481432-14 AND ASSOCIATED ERA 13-481432.SDR DALA109313351Seat Track · corrodedR & R SEAT TRACK AT Y953 FROM FR18 TO FR24, PER SRM 53-00-15, FIG 204 DUE TO CORROSION BEYOND LIMITS AS SPECIFIED IN SRM 53-00-15, FIG 102.SDR DALA109303351Seat Track · corrodedR & R SEAT TRACK AT Y1959 FROM FR62 TO FR72, IAW SRM 51-42-11 DUE TO CORROSION BEYOND LIMITS AS SPECIFIED IN SRM 53-00-15, FIG 102.SDR DALA109293351Seat Track · corrodedR & R SEAT TRACK AT Y1959 FROM FR26 TO FR38, IAW SRM 53-00-15, FIG 204 DUE TO CORROSION BEYOND LIMITS AS SPECIFIED IN SRM 53-00-15, FIG 102.SDR DALA109283351Seat Track · corrodedR & R SEAT TRACK AT Y450 FROM FR40 TO FR47, IAW ER/A 4814 & ER/A 13-481432 DUE TO CORROSION BEYOND LIMITS AS SPECIFIED IN SRM 53-31-15, FIG 101.SDR DALA109273351Seat Track · corrodedR & R SEAT TRACK IAW ER/A 481435-14, REV O, AT Y953, FROM FR11-FR18 DUE TO CORROSION REMOVED EXCEEDED ALLOWABLE LIMITS IAW SRM 53-00-15, FIG 102.SDR DALA109263351Seat Track · corrodedR & R SEAT TRACK IAW ER/A 481432-14, AT Y1959, FROM FR58-FR62 DUE TO CORROSION REMOVED EXCEEDED ALLOWABLE LIMITS IAW SRM 53-00-15, FIG 102.SDR DALA109253351Seat Track · corrodedR & R SEAT TRACK IAW ER/A 481432-14, REV O, AT Y450, FROM FR53-FR55 DUE TO CORROSION REMOVED EXCEEDED ALLOWABLE LIMITS IAW SRM 53-31-15, FIG 101.SDR DALA109243351Seat Track · corrodedR & R SEAT TRACK IAW SRM 51-42-11, AT Y450, FROM FR55-FR58 DUE TO CORROSION REMOVED EXCEEDED ALLOWABLE LIMITS IAW SRM 53-00-15, FIG 102.SDR DALA109233351Seat Track · corrodedR & R SEAT TRACK IAW SRM 51-42-11, AT Y450, FROM FR58-FR67 DUE TO CORROSION REMOVED EXCEEDED ALLOWABLE LIMITS IAW SRM 53-00-15, FIG 102.SDR DALA109223351Seat Track · corrodedR & R SEAT TRACK IAW SRM 51-42-11, AT -Y1959, FROM FR58-FR62 DUE TO CORROSION REMOVED EXCEEDED ALLOWABLE LIMITS IAW SRM 53-00-15, FIG 102.SDR DALA109093351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR68-FR72. REPAIRED IAW SRM 51-42-11.SDR DALA109083351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR47-FR53. REPAIRED IAW SRM 51-42-11.SDR DALA109073351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR47-FR53. REPAIRED IAW SRM 51-42-11.SDR DALA109063351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR47-FR53. REPAIRED IAW SRM 51-42-11.SDR DALA109053351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT -Y450 FR68-FR72. REPAIRED IAW SRM 51-42-11.SDR DALA109043351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR72-FR73. REPAIRED IAW SRM 51-42-11.SDR DALA109033351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR39.2-FR40. REPAIRED IAW SRM 51-42-11.SDR DALA109023351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR40-FR47. REPAIRED IAW SRM 51-42-11.SDR DALA109013351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR62-FR72. REPAIRED IAW SRM 51-42-11.SDR DALA109003351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y2462 FR58-FR62. REPAIRED IAW SRM 51-42-11.SDR DALA108993351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR58-FR67. REPAIRED IAW SRM 51-42-11.SDR DALA108983351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR53.2-FR54. REPAIRED IAW SRM 51-42-11.SDR DALA108973351Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT Y2462 FR62-FR72. REPAIRED IAW SRM 53-00-15 FIGURE 102, 51-42-11.SDR DALA109423351Profile · crackedR & R THE LT Z-PROFILE AT FR80 FROM Y1137.1 TO Y1447.8 IAW SRM 51-42-11, DUE TO IT BEING CRACKED.SDR DALA109413351Profile · crackedR & R THE RT Z-PROFILE AT FR80 FROM Y1137.1 TO Y1447.8 IAW SRM 51-42-11, DUE TO IT BEING CRACKED.SDR DALA109403351Floor Support · corrodedR & R FLOOR SUPPORT NR 271MF AT Y450 BETWEEN FR75 AND FR78 IAW SRM 51-42-11, DUE TO IT BEING CORRODED BEYOND LIMIT.SDR DALA109453351Floor Support · corrodedR & R FLOOR SUPPORT AT -Y1447 AFT OF FR75 IAW SRM 51-42-11, DUE TO IT BEING CORRODED BEYOND LIMITS SPECIFIED IN SRM 53-41-14, FIG 103.SDR DALA103643351Skin · damagedDURING LINE CHECK FOUND FUSELAGE SKIN DAMAGE FORWARD OF BULK CARGO COMPARTMENT DOOR AT FR80-FR82 S34R. REPAIRED IAW ERA 479795-14 & SRM 53-00-11.SDR NWAA083653351Battery Pack · dischargedDURING 1/2 A-CHECK, FOUND EPSU BATTERY FOR LOWER DECK CREW REST BAD. REPLACED BATTERY PACK IN EPSU 19WL, CHECKS GOOD. (S)SDR NWAA081383351Fan · odorJUST PRIOR TO LEVEL OFF AFTER TAKE OFF THE FLIGHT ATTENDANT AT DOOR 4R CALLED TO REPORT SHE SMELLED ELECTRICAL SMOKE AND IT WAS HAZY. RECEIVED "COND R CAB VENT FAULT" FOLLOWED COM AND SHUT OFF CABIN FANS AND THE SMELL AND HAZE DISSIPATED AND LANDING WAS UNEVE
Back to N851NW