N151AW
Service difficulty reports not matched to an aircraft · 114
They name N151AW, but no registry record covers the date, the aircraft registered then was built later, or the report describes another aircraft. 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 = 'N151AW' AND registry_match IS NULL 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 = 'N151AW' AND registry_match IS NULL 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 AWXA200200623Skin Panel · buckledMCN - MAJOR REPAIR - DURING C-18 CHECK WRINKLED SKIN WAS FOUND ON THE LOWER KEEL BEAM PANEL FROM BS 663 TO BS 727. MANTENANCE REMOVED LOWER KEEL BEAM PANEL, FABRICATED NEW KEEL BEAM PANEL AND 3 EACH INNER DOUBLERS, AND INSTALLED REPAIR PARTS IAW AWA ER 03-5311SDR AWXA200200625Web · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1" CRACK WAS FOUND ON THE LOWER KEEL BEAM STIFFNER WEB BELOW AUXILLARY HYDRAULIC PUMP BS 710, LBL 6 TO RBL 6. MAINTENANCE REMOVED STIFFNER WEB BS 710, LBL 6 TO RBL 6, FABRICATED A NEW STIFFNER WEB, AND INSTALLED REPAIR SDR AWXA200200624Web · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1/4" CRACK WAS FOUND ON THE STIFFNER WEB BETWEEN THE L/H AND R/H KEEL BEAMS BS 710, LBL 6 TO RBL 6. MAINTENANCE REMOVED STIFFNER WEB BETWEEN THE L/H AND R/H KEEL BEAMS BS 710, FABRICATED A NEW STIFFNER WEB, AND INSTALLESDR AWXA200200612Stringer · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK EXFOLIATION CORROSION WAS FOUND ON THE END OF STRINGER 23 R/H AT BS 357. MAINTENANCE REMOVED DAMAGED SECTION OF STRINGER 23 R/H, AT BS 326 TO BS 357. FABRICATED NEW SECTION OF STRINGER AND INSTALLED REPAIR PARTS IAW B737-SDR AWXA200200611Stringer · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK EXFOLIATION CORROSION WAS FOUND ON THE END OF STRINGER 23 R/H AT BS 363. MAINTENANCE REMOVED DAMAGED SECTION OF STRINGER 23 R/H, AT BS 363 TO BS 390. FABRICATED NEW SECTION OF STRINGER AND INSTALLED REPAIR PARTS IAW B737-SDR AWXA200200654Splice · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 2 3/4 INCH CRACK WAS FOUND ON STRINGER SPLICE AT BS 360, STR 23 RT. MAINTENANCE REMOVED CRACKED STRINGER SPLICE AT BS 360, STR 23 RT, FABRICATED A NEW STRINGER SPLICE, AND INSTALLED REPAIR IAW B737-300 SRM 51-40-02, PG.SDR AWXA200200637Door Frame · crackedDURING C-18 CHECK HFEC INSPECTION IDENTIFIED A 1 1/8 INCH CRACK RUNNING FROM LOWER FASTENER HOLE ON FRAME AT THE PAN COMMON TO THE NR 3 STOP OF THE R2 DOOR BS 956, STR 10 RT. MAINTENANCE TRIMMED OUT CRACK IN FRAME AT BS 956. PERFORMED A HFEC INSPECTION TO VERISDR AWXA200200632Frame · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK HFEC INSPECTION IDENTIFIED A 1 5/8" CRACK RUNNING FROM A FASTENER HOLE ON THE FORWARD FRAME AT THE PAN COMMON TO THE #3 STOP OF THE L2 DOOR, BS 956. MAINTENANCE TRIMMED OUT CRACK IN FRAME AT BS 956. PERFORMED A HFEC INSPESDR AWXA200200602Floorbeam · crackedDURING C-18 CHECK A 3/4 INCH CRACK WAS FOUND ON THE UPPER T-CHORD AT BS 727B, RBL 25. MAINTENANCE TRIMED OUT CRACKED AREA OF UPPER T-CHORD AT BS 727B, RBL 25. PERFORMED A HFEC INSPECTION TO VERIFY NO CRACKS EXIST. FABRICATED 2 EACH STRAPS, A FILLER, AND A SHIMSDR AWXA200200601Stringer Clip · crackedDURING C-18 CHECK A CRACK WAS FOUND ON THE UPPER FORWARD FASTENER HOLE OF STRINGER TIE CLIP AT BS 277, STR 19 RT. MAINTENANCE REMOVED AND REPLACED THE STRINGER TIE CLIP AT BS 277, STR 19 RT IAW B737-300 SRM 51-40-02, PG.10.SDR AWXA200200600Web · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 2" CRACK WAS FOUND ON CABIN FLOOR BEAM VERTICAL WEB BS 706, RBL 25. MAINTENANCE CUTOUT CRACKED AREA OF WEB AT BS 706, RBL 25. PERFORMED HFEC INSPECTION TO VERIFY NO CRACKS EXIST. FABRICATED A REPAIR DOUBLER AND WEB; INSSDR AWXA200200653Seat Track · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 3/4 INCH CRACK WAS FOUND ON MAIN DECK SEAT TRACK FLANGE, FORWARD INBOARD SIDE, BS 727B, RBL 45.5. MAINTENANCE REMOVED AND DISCARDED EXISTING STRAP; TRIMMED OUT CRACKED AREA; PERFORMED HFEC INSPECTION TO VERIFY NO CRACKSSDR AWXA200200599Seat Track · crackedDURING C-18 CHECK A 1 5/8 INCH CRACK WAS FOUND COMING FROM FASTENER HOLE ON MAIN CABIN SEAT TRACK OUTBOARD FLANGE BS 727B, WL 208.1, RBL 46. MAINTENANCE CUTOUT CRACK AT SEAT TRACK BS 727B, RBL 46. PERFORMED HFEC INSPECTION TO VERIFY NO CRACKS EXIST. FABRICATEDSDR AWXA200200634Web · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1 1/2" CRACK WAS FOUND IN STRINGER WEB 18A R/H, BS 725. MAINTENANCE REMOVED ANGLE, AND SLOTTED STRINGER WEB EXTENDING THE CRACK TO SECOND FASTENER HOLE. FABRICATED GUSSET AND RADIUS FILLER, AND INSTALLED REPAIR PARTS & SDR AWXA200200635Web · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1 1/4" CRACK WAS FOUND ON THE AFT END OF STRINGER WEB 18 L/H AT INBOARD FASTENER HOLE BS 725. MAINTENANCE REMOVED ANGLE, AND SLOTTED STRINGER WEB EXTENDING THE CRACK TO SECOND FASTENER HOLE. FABRICATED GUSSET AND RADIUSSDR AWXA200200613Skin · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1/4" CRACK WAS FOUND AT THE R/H WING LEADING EDGE KRUEGER FLAP DEFLECTION DOOR CUTOUT. MAINTENANCE CUTOUT THE DAMAGED AREA OF SKIN AT THE R/H WING LEADING EDGE KRUEGER FLAP DEFLECTION DOOR CUTOUT AND PERFORMED A HFEC INSDR AWXA200200655Skin · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1 3/8" CRACK WAS FOUND ON EXTERNAL SKIN, INTERNAL DOUBLER, AND STRAP AT L2 DOOR FORWARD LOWER CUTOUT BS 950, STR 17 L/H. HFEC & 10X VISUAL CONFIRMED. MAINTENANCE STOP DRILLED CRACK ON SKIN, INTERNAL DOUBLER, AND STRAP ASDR AWXA200200633Skin · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK AFTER REMOVING AN EXISTING REPAIR DOUBLER FOR A DENT IN SKIN, 2 EACH CRACKS WERE FOUND EXTENDING PAST STOP DRILL HOLES AT BS 326, WL 206, AND BS 328, WL 204. MAINTENANCE TRIMMED OUT SKIN, DOUBLER, AND STRAP AT BS 326, WL SDR AWXA200200631Skin · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1/4" CRACK WAS FOUND ON EXTERNAL FUSELAGE SKIN AT THE R1 DOOR CUTOUT FORWARD LOWER CORNER; CRACK RUNS FROM THE EDGE OF A COUNTER SUNK FASTENER TO THE EDGE OF CUTOUT, BS 301. MAINTENANCE TRIMMED OUT DAMAGE ON FUSELAGE SKSDR AWXA200200621Skin · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1 1/8" CRACK WAS FOUND ON FUSELAGE EXTERNAL SKIN AND BONDED DOUBLER AT THE R2 DOOR FUSELAGE LOWER HINGE CUTOUT EXTENDING FORWARD BENEATH THE WINDOW BELT DOUBLER BS 951, RBL 66. CRACK CONFIRMED BY HFEC INSPECTION AND 10XSDR AWXA200200568Skin · crackedDURING C-18 CHECK A 1 1/4 INCH CRACK WAS FOUND ON L2 DOOR EXTERNAL SKIN AT THE UPPER AFT CORNER THROUGH COUNTERSINK FASTENER HOLE, BS 985.75, CONFIRMED BY HFEC INSPECTION AND 10X VISUAL. MAINTENANCE CUTOUT CRACKED AREA OF SKIN, FABRICATED A REPAIR DOUBLER AND SDR AWXA200200245Light · damagedSNA - EEL - C - DURING 4-DAY INSPECTION EMERGENCY ESCAPE PATH SEAT LIGHT ON ROW 8 LT WAS FOUND PULLED FROM WIRING. MAINTENANCE REPLACED DAMAGED EMERGENCY ESCAPE SEAT LIGHT ASSEMBLY ON SEAT ROW 8 LT PER EO 33-50-31, FUNCTIONAL CHECK WAS GOOD.SDR AWXA200200244Light · brokenSNA - EEL - C - DURING 4-DAY INSPECTION EMERGENCY ESCAPE PATH SEAT LIGHT ON ROW 7 LT WAS FOUND BROKEN AND STRIPPED FROM WIRING. MAINTENANCE REPLACED EMERGENCY ESCAPE SEAT LIGHT ASSEMBLY ON SEAT ROW 7 LT PER EO 33-50-31, FUNCTIONAL CHECK WAS GOOD.SDR AWXA0001943Floorbeam · corrodedFLOORBEAM T-CAP HAS CORROSION AT STA 986 I/B OF R-2 DOOR. REMOVED AND REPLACED WITH NEW T-CAP REPAIR STA 986 LBL 28 TO RBL 50 PER EA 03-5310-01179-SS24.SDR AWXA0001942Frame · crackedLT SIDE CHORD CRACKED STA 178 WL 207. REMOVED AND REPLACED SIDE CHORD.SDR AWXA0001941Floorbeam · corrodedFLOORBEAM STA 947 LBL 60 RBL 60 HAS CORROSION ON TOP CAP. REPAIRED TOP CAP LBL 60 TO RBL 60 PER AWA ER 03-5365-01179 DD2.SDR AWXA0001940Bulkhead · corrodedCORROSION AT AFT PRESSURE BULKHEAD B/S 1016 6:00 POSITION. REPAIRED AFT PRESSURE BULKHEAD AT B/S 1016 6:00 POSITION PER ER 03-5383-01141-DD2.SDR AWXA0001939Skin · dentedFUSELAGE SKIN DENT WITH LIGHTNING STRIKE AT BS 500A STR 20R TO 21R. FOUND DENT TO BE OUT OF LIMITS PER SRM 53-00-01 FIG 219, CAL 2370. REPAIRED DENT PER SRM 53-00-01 FIG 205.SDR AWXA0001937Frame · crackedD: STA 847 Frame Cracked Approx 3" at LWR stop fitting W.L170 RBL 40C: Removed & replaced frame per DWG 65C35243SDR AWXA0001936Stiffener · crackedVERTICAL STIFFENER CRACKED BS 178 LBL 5.7 WL 185. REPAIRED PER SRM 53-10-08 FIG 205.SDR AWXA0001935Intercostal · crackedD: Intercostal at WL 207 B.S. 178.0 Shows evidence of crackC: Removed and replaced cracked intercostal WL 207 BS 178 Ref SRM 53-10-08SDR AWXA0001934Crease Beam · crackedD: L/H crease beam cracked / broken at STA 178 W L 207C: Corrective action Fabricated repair clip Per E.R. # 03-5311-01177-DD4 and installed.SDR AWXA0001933Frame · crackedD: Fuselage frame at fuselage station 500 cracked at upper flange and web. Forward of lower antenna. Between Stringer 28L and 28RC: Corrective action removed damaged area Fab'd repair parts, treated top coated and installed per SRM 51-70-11SDR AWXA0001932Bulkhead · crackedSIX CRACKS ON RADOME BULKHEAD CENTER OF WEB BS 178 AT THE FOLLOWING LOCATIONS WL 212 LBL 4,5 WL 200 LBL 5 WL 200 LBL 7.0 WL 198 LBL 7.0 WL 200 RBL 5.0 WL 200 RBL 7.0. REPAIRED CRACKS ON RADOME BULKHEAD CENTER WEB STA 178 PER SRM 53-10-08.SDR AWXA0000800Transmitter · malfunctionedEN ROUTE SAN-PHX. ON APPROACH, FLAPS WOULD NOT GO PAST FLAPS 1 ON GAUGE. SPLIT FLAP NEEDLE INDICATION. EMERGENCY DECLARED. CREW TAPPED ON INDICATOR, WAS ABLE TO LOWER FLAPS. NORMAL APPROACH AND LANDING. MAINTENANCE REPLACED FLAP POSITION INDICATOR, AND FSDR AWXA0000792Light · inoperativeNON ROUTINE LINE, ROW 15 SEAT MOUNTED EMERGENCY LIGHT INOP. REMOVED AND REPLACED EMERGENCY LIGHT FIXTURE ASSY AT SEAT 15 LT, OPS CHECK GOOD.SDR AWXA0000439Skin · dentedAT C-CHECK; AFT CARGO DOOR SKIN DENTED AT SEVERAL LOCATIONS. REMOVED SKIN, FABRICATED REPLACEMENT, AND INSTALLED PARTS IAW 737 SRM 52-30-01, SRM 51-10-2, AND SRM 51-40-02.SDR AWXA0000438Angle · crackedAT C-CHECK; FWD CARGO DOOR LIGHTING HOLE, AFT LWR CORNER, LONGITUDINAL ANGLE, CRACKED BETWEEN AFT THREE RIVITS. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, AND INSTALLED REPAIR IAW 737 SRM 51-70-12 AND SRM 51-40-02.SDR AWXA0000437Frame · corrodedAT C-CHECK; CORROSION ON T-CAP OF STA 294.5 FRAME, LBL 42-54. REMOVED DAMAGE AREA, FABRICATED REPLACEMENT SECTION AND REPAIR ANGLE, AND INSTALLED PARTS IAW 737 SRM 53-10-51 FIG 225 AND SRM 51-40-22.SDR AWXA0000436Stringer Clip · crackedAT C-CHECK; STRINGER CLIP CRACKED AT FS 616 STRINGER 8 RT. REMOVED AND REPLACED STRINGER CLIP IAW 737 SRM 51-10-02.SDR AWXA0000435Stringer Clip · crackedAT C-CHECK; STRINGER CLIP CRACKED AT FS 663 STR 10 LT. REMOVED AND REPLACED STRINGER CLIP IAW 737 SRM 51-10-02.SDR AWXA0000434Stringer Clip · crackedAT C-CHECK; STRINGER CLIP CRACKED AT FS 663 STR 10 RT. REMOVED AND REPLACED STRINGER CLIP IAW 737 SRM 51-10-02.SDR AWXA0000433Seat Track · corrodedAT C-CHECK; SEAT TRACK FLANGE CORRODED AT FS 727B, LBL 44. REMOVED DAMAGE IAW 737 SRM 53-00-51 FIG 203, REPAIRED SEAT TRACK IAW 737 SRM 51-70-12, TREATED PARTS IAW 737 SRM 51-20-01, INSTALLED PART IAW 737 SRM 51-20-12.SDR AWXA9900433Indicator · failedON DEPARTURE, HIGH SPEED CLACKER SOUNDED AT APPROXIMATELY 95 KTS. T/O ABORTED. REPLACED F/O'S AIRSPEED INDICATOR TT 0043116, OPS CK GOOD. CURRENT HISTORY: THIS IS THIRD OCCURANCE OF PROBLEM SINCE 25 NOV, REF LP'S 7569746 AND 7569735. RECOMMENDATION: REMASDR AWXA9900387Light · inoperativeEMERGENCY LIGHT ASSY AT 13C INOP. REPLACED EMERGENCY LT ASSY AT 13C, OPS CHECK NORMAL.SDR AWXA9900023Switch · malfunctionedJUST AFTER TAKEOFF, ALL FUEL LOW PRESSURE LIGHTS ILLUMINATED WITH MASTER CAUTION LIGHT. EXECUTED AIR TURNBACK. RAN ENGINES TO TAKEOFF POWER, BITE TEST, AND DRIP STICK PER MM 28-22-00 OK FOR FLIGHT AS PRECAUTION IN PHX. REMOVED AND REPLACED FWD AND AFT LOW PSDR AWXA9700680Light · brokenDURING ROUTINE MAINTENANCE CHECK, FOUND SEAT EMERGENCY EXIT LIGHT BROKEN AT ROW 15L. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSEMBLY, OPS CHECK GOOD.SDR AWXA9700478Light · brokenDURING ROUTINE MAINTENANCE CHECK, FOUND BROKEN EMERGENCY LIGHT. REPAIRED EMERGENCY LIGHT. STC - SA3432NM.SDR AWXA9700382Wire Harness · disconnectedDURING ROUTINE MAINTENANCE CHECK, FOUND ROW 19 EMERGENCY LIGHT INOP. RECONNECTED WIRE HARNESS, OPS CHECK GOOD STC - SA 3432NM.SDR AWXA9700052Wire · brokenDURING ROUTINE MAINTENANCE CHECK, FOUND EMERGENCY LIGHT ROW 18 INOPERATIVE. REPAIRED WIRE AT ROW 18. SYSTEM OPS CHECK GOOD.
Back to N151AW