N860NW
Service difficulty reports · 269
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 = 'N860NW' 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 = 'N860NW' 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 DALA1220883360Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR40-FR40.3 Y-1959. REPLACED SEAT TRACK AS PER SRM 51-42-11.SDR DALA1220873360Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR48-50 Y-450. REPLACED SEAT TRACK AS PER SRM 51-42-11.SDR DALA1220863360Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR40.2-46 Y-1959. REPLACED SEAT TRACK AS PER SRM 51-42-11.SDR DALA1220853360Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR49- Y-53 2462. REPLACED SEAT TRACK AS PER SRM 51-42-11.SDR DALA1220843360Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR48-52 Y-1959. REPLACED SEAT TRACK AS PER SRM 51-42-11.SDR DALA1220833360Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR43-46 Y-450. REPLACED SEAT TRACK AS PER SRM 51-42-11.SDR DALA1221263360Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-00-15 FIG 102, FR31-32 Y-450. REPLACED SEAT TRACK AS PER ERA 501989.SDR DALA1222793360Seat Track · damagedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-00-15 FIG 102, FR37.25-37.5 Y-450. REPAIRED SEAT TRACK AS PER SRM 53-00-15 FIG 204.SDR DALA1148023360Skin · damaged(LP8235460) A/C SKIN DAMAGE LT SIDE FROM STATIC PORT THRU WING TO BODY FAIRING. REPAIRED PER ERA 494982-14 REV ORIG. REF N/R CARDS 1-58.SDR DALA1148013360Skin Panel · damagedSKIN PANEL F5327350221000 NEED TO HAVE HOLE LOCATED FR37.1/STR 42. FILLED WITH A BUSHING PER A330 SRM 51-73-12 REF AIRBUS TA SERS1-2011-652854-1 IAW PRI 494982-14 REV 3. INSTALLED FREEZE PLUG IAW AIRBUS TA SERS 1-2011-652854-1 REF A330 SRM 51-73-12 REF PRI 4SDR DALA1147493360Shear Tie · crackedDURING INSTALLATION OF NEW SKIN FOUND SHEAR TIE CLIP AT FR 36 BETWEEN STRINGER P32-P33 CRACKED. INSTALLED SHEAR TIE CLIP IAW A330 51-72-11.SDR DALA1147023360Shear Tie · damagedSHEAR TIE AT FR 34 BETWEEN STR 41L AND STR 42L DAMAGED. REPLACED SHEAR TIE IAW A330 SRM 51-72-11 PG 1.SDR DALA1147013360Shear Tie · damagedSHEAR TIE AT FR 37 BETWEEN STR 42L AND 43L DAMAGED. REPLACED SHEAR TIE AT FR37 BETWEEN STR 42L AND 43L IAW A330 SRM 51-72-11 PG 1.SDR DALA1147003360Shear Tie · damagedSHEAR TIE AT FRAME 35 BETWEEN STR 41L AND 42 L DAMAGED. REPLACED SHEAR TIE IAW A330 SRM 51-72-11 PG 1.SDR DALA1146993360Shear Tie · damagedSHEAR TIE AT FRAME 43 BETWEEN STR 41L AND 42L DAMAGED. REPLACED SHEAR TIE IAW A330 SRM 51-72-11 PG 1.SDR DALA1146983360Stringer · damagedSTR 42L DAMAGED FROM FR 33 TO FACTORY SPLICE BETWEEN FR 35 AND 36. REPLACED STRINGER IAW A330 SRM 51-72-11 PG 1.SDR DALA1146973360Shear Tie · damagedSHEAR TIE AT FRAME 36 BETWEEN 42L AND 43L DAMAGED. REPLACED SHEAR TIE IAW A330 SRM 51-72-11 PG 1.SDR DALA1225053360Door · dentedPERFORMED FINAL REPAIR DOOR 4LEFT LOWER EDGE DENTED. ORIGINAL LOG WRITTEN JULY 6 2011. REPAIRED PER ER/A 501988-14.SDR NWAA085763360Filter Element · dirtySMOKE IN THE CABIN AFTER TAKE OFF, MOST CONCENTRATED IN AREA OF ROW 5, FOLLOWED COM AND ISOLATED THE SOURCE TO BE PACK 2 AIR SUPPLY. DECLARED AN EMERGENCY AND RETURNED TO PEK AND LANDING WAS UNEVENTFUL. INSPECTED CABIN OVERHEAD CEILING AREA, LIGHTING BALLAST
Back to N860NW