N327US, cancelled May 9, 2023
Service difficulty reports · 35
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 = 'N327US' AND deregistration_id = 'N327US-2023-05-09' 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 = 'N327US' AND deregistration_id = 'N327US-2023-05-09' 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 Y2PA2020090220020Former · crackedDISCREPANCY: DURING C-CHECK AT KDHN FOUND FORWARD SIDE OF FRAME FORMER CRACKED AT FUSELAGE STATION FS 1086 AT LONGERON 28R. CORRECTIVE ACTION: COMMERCIAL JET STOP DRILLED CRACK AND VERIFIED CRACK CONTAINMENT VIA NDT. FABRICATED, DRILLED, DEBURRED, TREATED, PSDR Y2PA2020090220019Skin · crackedDISCREPANCY: DURING C-CHECK AT KDHN, FOUND ON THE UPPER MAIN CARGO DOOR FS313L TO 332L ABOVE WINDOW FRAME, SKIN IS CRACKED ALONG RIVET ROW. CORRECTIVE ACTION: COMMERCIAL JET STOP DRILLED CRACK AND VERIFIED CRACK CONTAINMENT VIA NDT. FABRICATED, DRILLED, DEBURSDR Y2PA2020090220018Beam · crackedDISCREPANCY: DURING C-CHECK AT KDHN A 0.625 INCH CRACK WAS FOUND ON THE FORWARD ENTRY DOOR #7 BEAM, AFT END OB SIDE. CORRECTIVE ACTION: COMMERCIAL JET STOP DRILLED CRACK AND VERIFIED CRACK CONTAINMENT VIA NDT. FABRICATED, DRILLED, DEBURRED, TREATED, PRIMED ANSDR Y2PA2020090220017Seat Track · corrodedDISCREPANCY: DURING C-CHECK AT KDHN CORROSION FOUND AT STATION 639R-658R RBL 0 SEAT TRACK AROUND FASTENERS. CORRECTIVE ACTION: COMMERCIAL JET REMOVED CORRODED SEAT TRACK SECTION AND SPLICED IN SEAT TRACK BETWEEN 588R AND 43.5R RBL 0 IAW DC9 SRM 51-30-1.SDR Y2PA2020090220016Spar Cap · corrodedDURING C-CHECK AT KDHN 3 NDT CONFIRMED CRACKS FOUND ON L/H WING XRS 267 UPPER SPAR CAP DURING ACCOMPLISHMENT OF AD05-07-03, S/B 57-179. REMOVED AND REPLACED DISCREPANT AREA OF THE LT WING UPPER REAR SPAR CAP FROM XRS 167.15 TO XRS 319.5 IAW DC9 S/B 57-179 ANDSDR Y2PA2020090220015Beam · corrodedDISCREPANCY: DURING C-CHECK AT KDHN, CORROSION WAS FOUND ON THE FORWARD CARGO LOWER FUSELAGE BEAM AT STATION 579R – 579L ON THE FORWARD AND AFT ENDS. CORRECTIVE ACTION: COMMERCIAL JET CUT OUT THE DAMAGED SECTION OF THE FLOOR BEAM AT STATION 579 RBL 38.0 TO SDR 7AHR2015020482319Seat Track · corrodedMAIN DECK SEAT TRACK HYAS EXFOLIATION AND LUGS WORM AT BS 515.00, RBL 1.00. REMOVED CORROSION, REMOVED DAMAGED AREA OF SEAT TRACK AND INSTALLED REPAIR IAW FLIGHT VEHICLE CONSULTING DWG 53-15015-1 WITH FORM 8110-3 APPROVAL.SDR 7AHR2015020482282Seat Track · corrodedMAIN DECK SEAT TRACK CORRODED AT BS 186.00, LBL 1.00. REMOVED DAMAGED AREA AND INSTALLED A REPAIR IAW FLIGHT VEHICLE CONSULTING DWG 53-15015-2 WITH FAA FORM 8110-3 APPROVAL.SDR 7AHR2015020482245Seat Track · corrodedMAIN DECK SEAT TRACK HAS CORROSION & LUGS HAVE EXCESSIVE WEAR AT BS 998.00-1005.00 AT RBL 24.00. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS AND INSTALLED IAW FLIGHT VEHICLE CONSULTING DWG 53-15009-3 WITH FAA FORM 8110-3 APPROVAL.SDR 7AHR2015020482349Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER CHORD & REPAIR ANGLE HAS DOUBLE DRILLED HOLE COMMON TO SEAT TRACK FWD OTBD FLANGE AT BS 699, LBL 45.00. CUT OUT DAMAGED AREA, FABRICATED REPAIR PARTS AND INSTALLED IAW FLIGHT VEHICLE DWG 53-15009-1 AND 53-15009-2 WITH FAA FORM 8110-3SDR 7AHR2015020482447Floor Support · corrodedMAIN DECK FLOOR SUPPORT CORRODED AT STA 160 BL 0. REMOVED DAMAGED FLOOR SUPPORT, FABRICATED AND INSTALLED REPLACEMENT FLOOR SUPPORT IAW SRM 51-01, 51-10-4, 51-10-3 & 51-30-2, FIG 1.SDR 7AHR201502042285Seat Track · crackedMAIN DECK SEAT TRACK CORRODED AND CRACKED AT BS 323, LBL 44. REMOVED CORROSION, CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED REPAIR IAW SRM 53-05, PAR 4, FIG 4F.SDR 7AHR201502042220Seat Track · corrodedMAIN DECK SEAT TRACK HAS CORROSION ON LUGS FROM BS 933 - 948, RBL 55. REMOVED DAMAGED SECTION OF SEAT TRACK AND REPLACED IAW SRM 53-05, FIG 4F, 51-30-2 & 51-30-1.SDR 7AHR201502032378Door Frame · corrodedFWD CARGO DOOR CUT OUT LOWER DOOR FRAME HAS CORROSION IN SEVERAL AREAS. REMOVED DAMAGED AREA OF DOOR FRAME IAW SRM 51-70-5. DOOR FRAME REPAIRED BETWEEN STA 370-427 IAW SRM 53-05, FIG 44.SDR 7AHR2015020382350Floorbeam · damagedMAIN DECK FLOORBEAM FWD CHANNEL HAS DOUBLE DRILLED HOLE COMMON TO SEAT TRACK OTBD FWD HOLE WITH DAMAGE TO SEAT TRACK AT BS 680.00, LBL 43.00-45.00. UPON REMOVAL OF SEAT TRACK FITTING ON AFT SIDE AT STA 680 ALSO HAS DOUBLE DRILLED HOLE. R & R FITTING, PN 3922SDR 7AHR548B7582361Cusp Web · corrodedCUSP WEB HAS CORROSION ON BOTTOM SIDE RBL 45.00 BETWEEN BS 691.00-695.00. CUSP WEB REPAIR WAS ACCOMPLISHED IAW SRM 53-05 REPAIR CONFIGURATION.SDR 7AHR548B7582357Cusp Web · puncturedCUSP WEB AT BS 775 HAS CORROSION ON BOTTOM & TOP FROM RBL 50-57 JUST AFT OF FLOORBEAM. TRIMMED OUT DAMAGED AREA OF CUSP WEB IAW SRM 53-05, FIG 131A-18 AND INSTALLED REPAIR IAW SRM 51-30-2, FIG 20 & 51-30-1.SDR 7AHR201502032356Cusp Web · puncturedCUSP WEB PUNCTURED AT BS 797, RBL 47.5. REMOVED DAMAGED AREA, LOCATED AND DRILLED DOUBLER AND INSTALLED REPAIR IAW SRM 53-05, FIG 131A-19,53-05.SDR 7AHR201502032348Cusp Web · crackedCUSP WEB HAS PREVIOUSLY STOP DRILLED CRACKS THAT HAVE EXTENDED PAST THE STOP DRILLED AREAS AT BS 756 - 775, LBL 45. REPAIRED THE CUSP WEB IAW SRM 53-11-3, FIG 11B, 51-30-2, 51-30-01 & 51-30-3.SDR 7AHR548B7582228Cusp Web · crackedCUSP WEB IS CRACKED IN MULTIPLE AREAS AND MISSING FASTENERS FROM BS 756 - 775 BL 60. R & R CUSP MEMBRANE IAW SRM 53-11-3, FIG 11B, 51-30-2 & 51-30-1.SDR Y2PA20130405016Skin · cracked.7500 INCH CRACK DISCOVERED ON THE WINDOW BELT DOUBLER AT STATION 238 BETWEEN LONGERONS 11L AND 12L. INSTALLED PERMANENT REPAIR IAW SERVICE REWORK DWG J060109 AND EA 96-51-02 R1.SDR Y2PA20121114055Bushing · missingCREW REPORTED NLG UNSAFE LIGHT REMAINED ILLUMINATED UPON GEAR RETRACTION. DECLARED AN EMERGENCY. PERFORMED GEAR UNSAFE INDICATION CHECKLIST. ON APPROACH PERFORMED A NORMAL GEAR EXTENSION. GEAR EXTENDED NORMALLY AND EXTINGUISHED NLG UNSAFE LIGHT. LANDED WISDR Y2PA20120920043Unknown · unknownIN-FLIGHT, ALL ELECTRIC TRIM FOR STABILIZER INOPERATIVE. PILOT & CO-PILOT YOKE TRIM, PRIMARY TRIM AND ALTERNATE TRIM. CREW REPORTED IN-FLIGHT ALL ELECTRIC TRIM FOR HORIZONTAL STAB INOPERATIVE. ON CLIMB CAPTAIN'S ELECTRIC YOKE TRIM SWITCH DID NOT WORK FOR STASDR ABXR200912180053Bulkhead · corrodedDURING A ROUTINE HEAVY MX INSP EVENT AFT PRESSURE BULKHEAD WEB CORRODED AT THE 6:00 POSITION. FABRICATED AND REASSEMBLED FALSE BULKHEAD WEB IAW SRM 53-11-3. ITEM WAS RETURNED TO SERVICE.SDR ABXR200912180052Panel · corrodedDURING A ROUTINE HEAVY MX INSP EVENT RT WING T/E PANEL HAS 3 AREAS OF CORROSION/DELAMINATION ALONG THE T/E OF THE PANEL. REMOVED UPPER SKIN AND HONEY COMB CORE, CLEANED CORROSION AND SKIN IAW SRM 51-70-2. ITEM WAS RETURNED TO SERVICE.SDR ABXR200912180051Fitting · corrodedDURING A ROUTINE HEAVY MX INSP EVENT RT FLAP INBD HINGE, FWD HINGE HALF HAS RUST BLEED FROM UPPER 2 SPAR ATTACH BOLTS. RT FWD INBD FLAP HINGE FITTING WAS REPLACED IAW AMM 57-40-1. ITEM WAS RETURNED TO SERVICE.SDR ABXR200912180050Bulkhead · corrodedDURING A HEAVY ROUTINE MX INSP THE AFT PRESSURE BULKHEAD HAD CORROSION BETWEEN LONGERONS 25R TO 29R. REPAIRED AFT PRESSURE BULKHEAD IAW SRM 53-05, PARAGRAPH 116. ITEM WAS RETURNED TO SERVICE.SDR ABXR200912180049Structure · crackedDURING A HEAVY MX VISIT CRACK INDICATION WITH EDDY CURRENT VERT STAB L/E UPPER SECTION. STOP DRILLED CRACK IAW SRM 55-02 FIG 27. FABRICATED REPAIR PARTS OUT OF 2024-T3 .050 AND .040. ITEM RETURNED TO SERVICE.SDR ABXR200912180048Rib · crackedDURING A ROUTINE HEAVY MX VISIT HAD CRACK INDICATION AT A FASTENER FOR 2 EACH RIBS ON THE RT SIDE OF THE LWR SECTION OF THE VERTICLE STAB. STOP DRILLED CRACK IAW SRM 55-02, FIG 27, FABRICATED REPAIR DOUBLERS USING .0407075-T6 IAW SRM 55-31-00. ITEM WAS RETURSDR ABXR200912170047Beam · crackedDURING A ROUTINE HEAVY MX VISIT THE AFT LWR CARGO DOOR BEAM END FITTING, 2ND BEAM FROM FWD END IS CRACKED. REMOVED AND REPLACED FITTING IAW SRM 51-30-05. ITEM RETURNED TO SERVICE.SDR ABXR200912170046Beam · crackedDURING A HEAVY MX THE AFTR LWR CARGO DOOR HAS CRACKED BEAM END FITTING. INSTALLED NEW FITTING IAW SRM 51-30-05. ITEM WAS RETURNED TO SERVICE.SDR ABXR200912170045Skin · chafedDURING A ROUTINE HEAVY MX VISIT FOUND 2 (EA) CHAFE MARKS IN VERTICLE STAB RT SIDE. (TOP/FWD) REMOVED AND REPLACED SKIN WITH RIVITS IAW SRM 51-30-2 AND HILOCKS IAW SRM 51-30-5. ITEM RETURNED TO SERVICE.SDR ABXR200912170044Stud · corrodedDURING A ROUTINE HEAVY MX VISIT LT FLAP INBD HINGE UPPER OTBD BLEEDING RUST. INBD STUDS REPLACED IAW AMM 57-40-1 AND REPAIRED HINGE IAW OVERHAUL MM 27-50-5. ITEM RETURNED TO SERVICE.SDR ABXR200912170043Tab · corrodedDURING A ROUTINE MX VISIT, LT ELEVATOR CONTROL TAB WAS FOUND TO HAVE SURFACE CORROSION ON THE LWR SIDE. INSTALLED NEW ELEVATOR CONTROL TAB IAW AMM 27-30-3. ITEM WAS RETURNED TO SERVICE.SDR ABXR200912170042Rib · corrodedDURING A ROUTINE HEAVY MX INSP EVENT THE LT WING T/E RIB AT STA XRS 133 WAS FOUND EXFOLIATED. REPAIRED RIB BY SPLICING IN NEW SECTION AND INSTALLING DOUBLER IAW SRM 57-3, SHT 2. INSTALLED FASTENERS IAW SRM 51-30-2 AND 51-30-5.
Back to N327US, cancelled May 9, 2023