N373NW
Service difficulty reports · 167
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 = 'N373NW' 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 = 'N373NW' 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 DALA13009463273Floor Support · corrodedDURING INSPECTION, FOUND AFT UTILITY AREA FLOOR SUPPORT RT SIDE BETWEEN FR 66-68, Y-1292 UPPER SURFACE FLANGE HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00. AREA MEASURES L:2" W:1" D:.080" FOUND TO BE OUT OF LIMITS IAW SRM 53-00-14, FIG 102. REPLACED FSDR DALA13009453273Floor Support · corrodedDURING INSPECTION, FOUND AFT UTILITY AREA FLOOR SUPPORT BETWEEN FR 64 TO FR 66 Y-1292 HARD POINT HOLES HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00. AREA MEASURES L:1" W:1" D:.075" ORIG MAT. .100". FOUND OUT OF LIMITS IAW SRM 53-00-14, FIG 102. R & R SDR DALA13009433273Floor Support · corrodedDURING INSPECTION, FOUND AFT UTILITY AREA FLOOR SUPPORT BETWEEN FR 68-69 Y-1292 UPPER SURFACE FLANGE HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00. AREA MEASURES L:4" W:3" D:.108" ORIG MAT. .155". FOUND OUT OF LIMITS IAW SRM 53-00-14, FIG 102. REPLACSDR DALA13008943273Floorbeam · corrodedDURING INSPECTION, FOUND FORWARD CABIN FLOORBEAM BETWEEN FR16 TO FR23 Y254 UPPER SURFACE FLANGE HAS CORROSION. REPLACED FLOORBEAM Y254V FROM FR14-FR24 IAW SRM 51-42-11. REMOVED CORROSION IAW SRM 51-74-00. CHECKED LIMITS L=2.0" W=1.0" D=0.079". FOUND TO BE SDR DALA13008933273Floor Support · corrodedDURING INSPECTION, FOUND AFT UTILITY AREA FLOORBEAM BETWEEN FR64 TO FR66, Y765 UPPER SURFACE FLANGE & HARD PT. HOLES HAS CORROSION. REPLACED FLOORBEAM Y765 IAW SRM 51-42-11. BEAM WAS FOUND TO BE CORRODED OUT OF LIMITS IAW TRM 53-41-15. L=1.5" W=.5" D=.050".SDR DALA13008923273Floor Panel · damagedDURING INSPECTION, FOUND FWD CABIN FLOOR PANEL 231 QF DAMAGED 3.0"X 4.0". FABRICATED FLOOR PANEL IAW SRM 53-02-00, FIG 209.SDR DALA13008913273Floor Support · corrodedDURING INSPECTION, FOUND AFT UTILITY AREA FLOORBEAM BETWEEN FR 65 TO FR 66 Y-465 UPPER FLANGE AND HARD PT HOLES HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00, CHECKED LIMITS, L=2"W=1"D=.035", FOUND TO BE OUT OF LIMITS IAW SRM 53-00-14, FIG 102. REPLACED SDR DALA13008883273Floorbeam · corrodedDURING INSPECTION, FOUND AFT UTILITY AREA FLOORBEAM AT FR 68 Y765 UPPER FLANGE HAS CORRODED. BLENDED CORROSION IAW SRM 51-74-00; FOUND TO BE OUT OF LIMITS IAW TRM 53-41-15, L 2.0" W= 2.2 "D= 0.065"; REPLACED FLOORBEAM IAW SRM 51-42-11 & TRM 53-21-01.SDR DALA13008903273Support · corrodedDURING INSPECTION, AFT CABIN RT SIDE BETWEEN FR 69 TO 70 FRAME SUPPORT OF SHEAR PLATE CORRODED ON UPPER & LOWER SURFACE. REMOVED CORROSION IAW SRM 51-74-00; CHECKED LIMITS DIMENSIONS L=1.0"W=0.900"D=0.017" FOUND TO BE OUT OF LIMITS IAW SRM 53-41-17; REPLACED SDR DALA13008893273Floorbeam · corrodedDURING INSPECTION, FOUND FORWARD CABIN FLOORBEAM BETWEEN FR 20-21 Y-189 UPPER SURFACE FLANGE HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00, FOUND TO BE OUT OF LIMITS IAW 53-11-14, FIG 105. REPLACED FLOORBEAM Y-189 IAW SRM 51-42-11.L=1.244"X W=1. 050"X D=SDR DALA13008863273Floor Support · corrodedDURING INSPECTION, FOUND FORWARD CABIN UTILITY AREA FLOORBEAM BETWEEN FR 12-16 Y503.2 UPPER SURFACE FLANGE HAS CORROSION. FLOORBEAM Y503.2 FOUND TO BE OUT OF LIMITS IAW SRM 53-11-14. REMOVED FLOORBEAM IAW SRM 51-42-11. LOCATED AND DRILLED NEW BEAM IAW SRM 5SDR DALA13008843273Floorbeam · corrodedDURING INSPECTION, FOUND AFT UTILITY AREA FLOORBEAM LT SIDE AT FR68, Y465 UPPER FLANGE CORRODED. REMOVED CORROSION IAW SRM 51-74-00. CHECKED LIMITS L=1.6" W=W=1.0" D=.055" FOUND TO BE OUT OF LIMITS IAW SRM 53-00-14, FIG 102. R & R FLOORBEAM IAW SRM 51-42-11SDR DALA13008833273Floor Support · corrodedDURING INSPECTION, FOUND AFT UTILITY AREA FLOOR SUPPORT BETWEEN FR 66 TO FR69 Y-765 UPPER FLANGE CORRODED. REMOVED CORROSION IAW SRM 51-74-00. BLENDED AREA MEASURES L=4.0" W=1.0" D=.025" FOUND TO BE OUT OF LIMITS IAW TRM 53-41-15, ORIG MAT .157". R & R FLOSDR DALA13008823273Floor Support · corrodedDURING INSPECTION, FOUND AFT UTILITY AREA FLOOR SUPPORT BETWEEN FR67 TO FR68 Y-254 UPPER FLANGE HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00. CHECKED LIMITS L=1.0" W=1.5" D=0.050" FOUND TO BE OUT OF LIMITS IAW SRM 53-00-14, FIG 102. REPLACED FLOOR SUPPSDR DALA13008783273Floor Panel · corrodedDURING INSPECTION, FOUND AFT UTILITY FLOOR PANEL 262FF IS CORRODED ON UNDERSIDE. REMOVED CORROSION IAW SRM 51-74-00. CHECKED DIMENSIONS, NO ALLOWABLE DAMAGE IN SRM. REPLACED FLOOR PANEL.SDR DALA1143723273Wire Harness · defectiveDURING NON ROUTINE CHECK, FOUND THE EMERGENCY ESCAPE PATH LIGHT AT SEAT ROW 5 ABC INOPERATIVE. MAINTENANCE REPLACED SEAT HARNESS AND FUNCTIONAL TEST WAS NORMAL. AIRCRAFT RETURNED TO SERVICE.SDR DALA1122873273Connector · looseDURING EMERGENCY LIGHT TEST FOUND SEAT ROW 5/6 INOP. SECURED CONNECTOR IN SIDE WALL AND TESTS OK.
Back to N373NW