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 DALA13012743273Bracket · looseDURING INSPECTION, FOUND FWD CARGO BULKHEAD PANEL 131DW HAS FOUR BRACKETS LOOSE. REPAIRED FWD CARGO BULKHEAD PANEL IAW ER/A 512310-14 REV 'O' FINAL STEPS 1 THRU 6.SDR DALA13011533273Floor Panel · puncturedDURING INSPECTION, FOUND FWD CARGO FLOOR PANEL 132GF PUNCTURED, GOUGED AND DELAMINATED. FLOOR PANEL FABRICATED IAW SRM 53-02-00, FIG 209.SDR DALA13011523273Floor Panel · gougedDURING INSPECTION, FOUND FWD CARGO FLOOR PANEL 131FF GOUGED AND CRACKED. FLOOR PANEL FABRICATED IAW SRM 53-02-00 FIG. 209.SDR DALA13011513273Floor Panel · puncturedDURING INSPECTION, FOUND FWD CARGO FLOOR PANEL 131BF PUNCTURED, GOUGED AND DELAMINATED. FLOOR PANEL FABRICATED IAW SRM 53-02-00, FIG 209.SDR DALA13011503273Floor Panel · damagedDURING INSPECTION, FOUND FWD CARGO FLOOR PANEL 131CF PUNCTURED, GOUGED AND CRACKED. FLOOR PANEL FABRICATED IAW SRM 53-02-00, FIG 209.SDR DALA13011493273Floor Panel · dentedDURING INSPECTION, FOUND FWD CABIN FLOOR PANEL 132KF CREASED & GOUGED IN SEVERAL AREAS. FLOOR PANEL FABRICATED IAW SRM 53-02-00, FIG 209.SDR DALA13011483273Floor Panel · damagedDURING INSPECTION, FOUND FWD CARGO FLOOR PANEL 131GF PUNCTURED AND DELAMINATED. FLOOR PANEL FABRICATED IAW SRM 53-02-00, FIG 209.SDR DALA13011443273Floor Panel · damagedDURING INSPECTION, FOUND FWD CARGO FLOOR PANEL 132JF PUNCTURED, GOUGED AND DELAMINATED. FLOOR PANEL FABRICATED IAW SRM 53-02-00, FIG 209.SDR DALA13011433273Floor Panel · gougedDURING INSPECTION, FOUND FWD CARGO FLOOR PANEL 131KF GOUGED & PUNCTURED IN SEVERAL LOCATIONS. FLOOR PANEL FABRICATED IAW SRM 53-02-00, FIG 209.SDR DALA13011423273Floor Panel · delaminatedDURING INSPECTION, FOUND FWD CARGO FLOOR PANEL 131AF DELAMINATED. FLOOR PANEL FABRICATED IAW SRM 53-02-00, FIG 209.SDR DALA13011543273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO SLOPE PANEL 151EF DAMAGED. NEW SLOPE PANEL FABRICATED IAW DWG 3D25-37705 & SRM 53-02-00, FIG 209.SDR DALA13011413273Floor Panel · delaminatedDURING INSPECTION, FOUND AFT CARGO SLOPE PANEL 151CF DAMAGED 5" X 5" N/R 150/45. NEW SLOPE PANEL FABRICATED IAW DWG 3D25-37705 SRM 53-02-00, FIG 209.SDR DALA13011403273Beam · corrodedDURING INSPECTION, FOUND RT AFT PASSENGER & CREW DOOR SILL BEAM INBD FR68 UPPER SURFACE FLANGE HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00. CHECKED THE DEEPEST DAMAGE LIMITS L=0.60" W=0.50" D=0.035 FOUND TO BE OUT OF LIMITS IAW SRM 53-41-14, FIG 101. SDR DALA13011393273Skin · dentedDURING INSPECTION, FOUND TAILCONE EXTERNAL SKIN DENTED AT FR80 RT SIDE APPROX 8" FROM TOP CENTER LINE. FOUND TO BE OUT OF LIMITS IAW SRM 53-51-11, FIG 108, DIA 104. L=.850 W=.850 IAW SRM 53-51-11, FIG 203. FABRICATED REPAIR DOUBLER IAW SRM 53-51-11, FIG 203SDR DALA13010773273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO FLOOR PANEL 151GF DAMAGED. NEW FLOOR PANEL FABRICATED IAW DWG 3D 25-37705, SRM 53-02-00, FIG 209.SDR DALA13010763273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO FLOOR PANEL 151LF DAMAGED. NEW FLOOR PANEL FABRICATED IAW DWG NR 3D25-37705, SRM 53-02-00, FIG 209.SDR DALA13010753273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO FLOOR PANEL 151DF DAMAGED. NEW FLOOR PANEL FABRICATED IAW DWG 3D25-37705, SRM 53-02-00, FIG 209.SDR DALA13010743273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO FLOOR PANEL 161BF DAMAGED. NEW FLOOR PANEL FABRICATED IAW DWG NR 3D25-37705, SRM 53-02-00, FIG 209.SDR DALA13010733273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO FLOOR PANEL 151TF DAMAGED. NEW FLOOR PANEL FABRICATED IAW DWG NR 3D 25-37705, SRM 53-02-00, FIG 209.SDR DALA13010723273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO FLOOR PANEL 151BF DAMAGED. NEW FLOOR PANEL FABRICATED IAW DWG 3D25-37705, SRM 53-02-00, FIG 209.SDR DALA13010713273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO FLOOR PANEL 151RF DAMAGED. NEW FLOOR PANEL FABRICATED IAW DWG 3D25-37705, SRM 53-02-00, FIG 209.SDR DALA13010703273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO FLOOR PANEL 151RF DAMAGED. NEW FLOOR PANEL FABRICATED IAW DWG 3D 25-37705, SRM 53-02-00, FIG 209.SDR DALA13010693273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO FLOOR PANEL 152NF DAMAGED. NEW FLOOR PANEL FABRICATED IAW DWG 3D25-37705, SRM 53-02-00, FIG 209.SDR DALA13010683273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO FLOOR PANEL 152QF DAMAGED. NEW FLOOR PANEL FABRICATED IAW DWG 3D25-37705, SRM 53-02-00, FIG 209.SDR DALA13010673273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO SLOPE PANEL 152QF DAMAGED. NEW FLOOR PANEL FABRICATED IAW DWG NR 3D 25-37705, SRM 53-02-00, FIG 209.SDR DALA13010663273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO FLOOR PANEL 152QF DAMAGED. NEW FLOOR PANEL FABRICATED IAW DWG NR 3D25-37705, SRM 53-02-00, FIG 209.SDR DALA13010653273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO FLOOR PANEL 152EF DAMAGED. NEW FLOOR PANEL FABRICATED IAW DWG 3D25-37705, SRM 53-02-00, FIG 209.SDR DALA13010643273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO FLOOR PANEL 151HF DAMAGED 7" X 5". NEW FLOOR PANEL FABRICATED IAW DWG 3D25-37705, SRM 53-02-00, FIG 209.SDR DALA13010633273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO FLOOR PANEL 151NF DAMAGED 5" X 5". NEW FLOOR PANEL FABRICATED IAW DWG 3D25-37705, SRM 53-02-00, FIG 209.SDR DALA13010623273Floor Panel · damagedDURING INSPECTION, FOUND FWD CARGO FLOOR PANEL 131EF MISSING INSERT. NEW FLOOR PANEL FABRICATED IAW DWG 3D25-37705, SRM 53-02-00, FIG 209.SDR DALA13010613273Floor Panel · damagedDURING INSPECTION, FOUND AFT CARGO FLOOR PANEL 162BF DAMAGED 5" X 5". NEW FLOOR PANEL IAW DWG 3D25-37705, SRM 53-02-00, FIG 209.SDR DALA13010063273Web · corrodedDURING INSPECTION, FOUND FORWARD CABIN UTILITY AREA FLOOR SUPPORT UPPER SURFACE WEB HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00. NO ALLOWABLE DAMAGE LIMITS IN SRM. R & R FLOOR SUPPORT WEB IAW SRM 51-42-11 & DWG D531143 32.SDR DALA13010053273Web · corrodedDURING INSPECTION, FOUND FORWARD CABIN UTILITY AREA FLOOR SUPPORT UPPER SURFACE WEB HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00. NO ALLOWABLE DAMAGE LIMITS IN SRM. R & R FLOOR SUPPORT WEB IAW SRM 51-42-11 & DWG D531143.SDR DALA13010043273Floor Panel · delaminatedDURING INSPECTION, FOUND AFT UTILITY FLOOR PANEL 261BG DELAMINATED. FABRICATED FLOOR PANEL IAW DWG 3D25-37498 AND SRM 53-02-00, FIG 209. AND INSTALLED.SDR DALA13010033273Floor Panel · damagedDURING INSPECTION, FOUND AFT UTILITY FLOOR PANEL 261PF INSERTS RUSTY AND BOTTOM LT AFT CORNER DAMAGED. FABRICATED FLOOR PANEL IAW DWG 3D25-37498, & SRM 53-02-00, FIG 209, INSTALLED FLOOR PANEL.SDR DALA13010023273Floor Support · corrodedDURING INSPECTION, FOUND FORWARD CABIN FLOOR SUPPORT BETWEEN FR12 TO FR20, Y1292 UPPER SURFACE FLANGE HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00, FOUND OUT OF LIMITS IAW SRM 53-11-14, FIG 101. REPLACED FLOOR SUPPORT IAW 51-42-11, AIPC 53-11-01, FIG SDR DALA13010013273Fitting · corrodedDURING INSPECTION, FOUND FORWARD LT PASSENGER DOOR LWR ENTRANCE MID FWD UPPER SURFACE FITTING AROUND NUTPLATES HOLES HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00, NO ESTABLISHED LIMITS ON SRM 53-11-14. REPLACED FITTING IAW SRM 51-42-11 & DWG D53112109.SDR DALA13009683273Web · corrodedDURING INSPECTION, FOUND FORWARD CABIN UTILITY AREA LT SIDE INDB FR16 UPPER SURFACE WEB HAS CORROSION. BLENDED AREA IAW SRM 51-74-00 L=1.5" W=1.0" D-.006" NO ALLOWABLE LIMITS ESTABLISHED IN SRM. REPLACED FORWARD UTILITY AREA LT SIDE WEB BETWEEN FR12 TO FR1SDR DALA13010003273Floor Support · corrodedDURING INSPECTION, FOUND AFT UTILITY AREA FLOOR SUPPORT BETWEEN FR 68 TO FR 69,Y1292 UPPER SURFACE FLANGES HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00. FOUND TO BE OUT LIMITS IAW TRM 53-41-15. REPLACED FLOOR SUPPORT IAW SRM 51-42-11 & DWG D53472000.SDR DALA13009673273Floor Support · corrodedDURING INSPECTION, FOUND AFT UTILITY AREA FLOOR SUPPORT BTW FR 66 TO FR 68 Y1292 UPPER SURFACE FLANGES HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00. CHECKED LIMITS L=1.0 W= 1.00"D=0.055" FOUND TO BE OUT LIMITS IAW TRM 53-41-15. REPLACED FLOOR SUPPORT ISDR DALA13009663273Floor Support · corrodedDURING INSPECTION, FOUND AFT UTILITY AREA FLOOR SUPPORT BETWEEN FR 64 TO FR 66,Y1292 HARD POINT SURFACE HOLES HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00. CHECKED LIMITS L=1.50"W=1.50"D=0.060" FOUND TO BE OUT LIMITS IAW TRM 53-41-15. REPLACED FLOOR SUPSDR DALA13009653273Floor Panel · delaminatedDURING INSPECTION, FOUND FWD UTILITY AREA FLOOR PANEL 222FF LOWER SURFACE DELAMINATED AND CORRODED. REPLACED FLOOR PANEL IAW SRM 51-72-00.SDR DALA13009643273Floor Panel · delaminatedDURING INSPECTION, FOUND FWD UTILITY AREA FLOOR PANEL 221FF LOWER SURFACE DELAMINATED AND CORRODED. REPLACED FLOOR PANEL IAW SRM 51-72-00.SDR DALA13009633273Sill · corrodedDURING INSPECTION, FOUND LT AFT PASSENGER/CREW DOOR SILL AT AFT FR66 AROUND ANCHOR NUT HOLES HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00 L=1.0 W=.500 D=.053 OUT OF LIMITS IAW SRM 53-41-14 FIG 101. REPLACED DOOR SILL IAW DWG 53480020.SDR DALA13009623273Floor Support · corrodedDURING INSPECTION, FOUND FORWARD CABIN UTILITY AREA FLOOR SUPPORT RT SIDE STRG 23R FR20 UPPER SURFACE WEB HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00. L=1.5 W=.200 D=.005 NO ESTABLISHED LIMITS IN SRM. REPLACED -Y1792 WEB FR16-FR20 IAW SRM 51-42-11 & DWSDR DALA13009523273Blanking Plate · corrodedDURING INSPECTION, FOUND L-1 DOOR FWD & AFT PLANKING PLATES HAVE CORROSION. REMOVED CORROSION IAW SRM 51-74-00, CHECKED DIMENSIONS AS FOLLOWS: AFT L=1.0", W=0.80", D=0.005"; FWD L=1.20", W=1.0", D=0.004", NO ALLOWABLE DAMAGE LIMITS IN SRM. REPLACED FWD & AFSDR DALA13009543273Floorbeam · corrodedDURING INSPECTION, FOUND AFT CABIN FLOOR SUPPORT RT SIDE BTW FR 65-66, Y-1732 UPPER SURFACE FLANGES & AROUND HOLES HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00 L=1.0" W=1.0" D=.050" NO LIMITS IAW SRM 53-41-14, FIG 101. REPLACED FLOOR SUPPORT IAW SRM 51-SDR DALA13009533273Floor Support · corrodedDURING INSPECTION, FOUND AFT CABIN FLOOR SUPPORT LT SIDE BTW FR 65 TO FR 66, Y1732 UPPER SURFACE FLANGES & AROUND HOLES HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00 L=1.73" W=1.20" D=.043NO ALLOWABLE LIMITS FOR THIS AREA. REPLACED FLOOR SUPPORT IAW SRMSDR DALA13009513273Floor Support · corrodedDURING INSPECTION, FOUND FORWARD CABIN FLOOR SUPPORT BETWEEN FR18-20 Y-254, UPPER SURFACE FLANGE HAS CORROSION. REMOVED CORROSION IAW SRM 51-74-00. CHECKED LIMITS L=3.40" W=0.03" D=0.057 FOUND TO BE OUT OF LIMITS IAW SRM 53-11-14 FIG 105. REPLACED FLOOR SUPPSDR DALA13009393273Blanking Plate · corrodedDURING INSPECTION, FOUND R1 DOOR FWD AND AFT BLANKING PLATES CORRODED. REMOVED CORROSION IAW SRM 51-74-00, DIMENSIONS AS FOLLOWS: FWD L=1.5" W=1.0"D=.006", AFT L=1.0" W=1.0" D=.005" NO ALLOWABLE DANAGE LIMITATION IN SRM, REPLACED FWD & AFT BLANKING PLATE
Back to N373NW