N557NW
Service difficulty reports · 170
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 = 'N557NW' 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 = 'N557NW' 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 DALA13069905657Frame · dentedAFT CARGO RT SIDEWALL FRAME AT BS 1520 BETWEEN STRINGERS 25 & 26R DENTED. REMOVED DAMAGE ON FRAME & INSTALLED PERMANENT CAT"B" REPAIR IAW SRM 53-00-07, FIG 201, REPAIR 5.SDR DALA13070285657Angle · corrodedMAIN CABIN INNER ANGLE HAS CORROSION AT BS 758, RBL 65. REMOVED CORROSION IAW SRM 53-30-13, ALLOWABLE DAMAGE 1 PG 105, DETAIL VIII. R & R INNER ANGLE FROM BS 740 TO 900 IAW SRM 51-40-02, PAGE 7. CSDR DALA13068645657Floor Support · corrodedMAIN CABIN FLOOR SUPPORT HAS CORROSION BS 712-727. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS, REMOVED AND INSTALLED FLOOR SUPPORT IAW SRM 51-40-02.SDR DALA13068605657Floorbeam · corrodedCORROSION ON MAIN CABIN FLOORBEAM UPPER TEE BS 1661, RBL 20. ACCOMPLISHED ER/A 481634-14MA REPAIR ON FLOORBEAM.SDR DALA13066215657Frame · dentedDENT ON UPPER FLANGE OF FRAME AT BS 600 BETWEEN S22-23L. TRIMMED DENT & REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 5.SDR DALA13066505657Crease Beam · corrodedCORROSION ON LT CREASEBEAM INNER ANGLE FROM BS 430-439. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW SRM 53-30-13. R & R WITH NEW MAIN CABIN LT CREASEBEAM INNER ANGLE IAW SRM 51-40-02.SDR DALA13019915657Door Frame · damagedRAMP FOUND DAMAGE TO C-2 CARGO DOOR FRAME FWD EDGE. REMOVED DAMAGE AND INSPECTED. REPAIRED DAMAGED AREA REFER TO ERA 514326-14, REV ORIG.SDR DALA13008575657Bulb · inoperativeBULBS INOPERATIVE ON SEAT MOUNTED EMERGENCY LIGHT ASSY. REPLACED BULB, CHECKED GOOD.SDR DALA13006445657Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK INOPERATIVE. R & R BATTERY PACK IAW AMM 33-51-07-902-001. OPS CHECKED GOOD.SDR DALA1146235657Light · inoperativeDURING A CHECK, MAINTENANCE FOUND THE EMERGENCY PATH LIGHTING AT ROW 3 INOPERATIVE. MAINTENANCE REPLACED THE LIGHT ASSEMBLY. OPERATIONAL CHECK WAS GOOD.SDR DALA1103745657Battery Pack · inoperativeDURING A LINE CHECK, MX FOUND THE DOOR 1R EMERGENCY SLIDE LIGHT INOPERATIVE. MX REPLACED THE BATTERY PACK AND POWER SUPPLY. OPS CHECK WAS GOOD.SDR DALA13070035657Skin · damagedFUSELAGE EXTERIOR EXPIERENCED A LIGHTNING STRIKE, DAMAGE IS OUT OF LIMITS, CONTAINED DAMAGE, PERFORMED HFEC OPEN HOLE AND SURFACE SCAN NO CRACKS INDICATED. ALODINED AND PRIMED AREA. SHOT BLIND RIVET AND RESTORED TOP COAT PAINT IAW SRM 53-00-01, PG 201, FIG SDR DALA103675657Skin · dentedDURING "L" CHECK FOUND DENT IN FUSELAGE SKIN AT BS 620 BETWEEN S15L-S16L. REPAIRED IAW ERA 479765-14.SDR DALA103665657Stringer · damagedDURING "L" CHECK FOUND EXISTING DRILL STARTS IN STRINGER 15L BS 600. REPAIRED IAW SRM 53-00-03 & ERA 479773-14.SDR DALA103655657Skin · dentedDURING "L" CHECK FOUND DENT IN FUSELAGE SKIN AT BS 580 S15-16L. REPAIRED IAW ERA 479765-14.SDR DALA101815657Filter · dirtyBURNING OIL ODOR THROUGHOUT FLIGHT AFTER APPLICATION OF TAKEOFF POWER. REPLACED LT RECIRCULATION FAN FILTER. REPLACED NR 1 ENGINE. PERFORMED PACK BURNOUT.SDR DALA100975657A/C Pack · contaminatedBURNING OIL/WET SOCK ODOR, STRONG AT LOW ALTITUDES, DURING CLIMB AND DESCENT. FLIGHT LANDED UNEVENTFULLY. PERFORMED REMOVAL OF OIL CONTAMINATION FROM AIR CONDITIONING AND PNEUMATIC SYS, NO ODORS NOTED, OK FOR SERVICE. MAINT NOTED DE-ICE FLUID COLLECTED IN ASDR NWAA074045657Sign · inoperativeDURING OVERNIGHT CHECK, FOUND MID GALLEY LOWER EMERGENCY SIGN INOP. MAINTENANCE REMOVED AND REPLACED POWER SUPPLY. OPERATIONAL CHECKED GOOD AND AIRCRAFT WAS RETURNED TO SERVICE.SDR 0500595657Warning Light · illuminatedON TAKE OFF ROLL "R AFT ENTRY DOOR" ECAS ILLUMINATED AROUND 110 KNOTS. PILOT ABORTED TAKEOFF AT APPROXIMATELY 120 KNOTS. RETURNED AIRCRAFT TO GATE AND GROUND MAINTENANCE PERFORMED VISUAL AND OPERATIONAL CHECK OF THE RIGHT DOOR WARNING SYSTEM. OPS CHECKED NOSDR 0401605657Fuel Line · chafedTHE FUEL SUPPLY TUBE IN THE RIGHT PYLON WAS FOUND TO BE CHAFING AGAINST THE PYLON SUPPORT STRUCTURE (P/N 112N4115-6). THE DAMAGE TO THE FUEL TUBE EXCEEDED THE ALLOWABLE 0.004 INCH OF DAMAGE. REPLACED THE FUEL LINE. REPAIRED PER EA 56-199804. OPERATIONAL CH
Back to N557NW