N844AS, cancelled Jul 30, 2018
Service difficulty reports · 283
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 = 'N844AS' AND deregistration_id = 'N844AS-2018-07-30' 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 = 'N844AS' AND deregistration_id = 'N844AS-2018-07-30' 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 ASOA2014020509897Cargo Track · corrodedCARGO BAY HAS FOUR CARGO TRACKS AND ONE TIE DOWN CORRODED RBL 9.0. REMOVED AND REPLACED CARGO TRACKS IAW REO 601R-53-00-485. REMOVED AND REPLACED CARGO NET CLEAT IAW SRM 51-41-02-00.SDR ASOA2014020509896Floor Support · corrodedRT SIDE FLOOR SUPPORT CORRODED ON TOP AND BOTTOM AT NUTPLATE HOLES BETWEEN BS 589-605. REPAIRED IAW REO 601R-53-61-5153, REV. MAJOR REPAIR.SDR ASOA2014020509895Hinge · gougedASD HINGE GOUGED ON AFT AND ON AIRFRAME SIDE. COMPLIED WITH REO 601R-53-21-814. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702.SDR ASOA2014020509894Shroud · gougedRIGHT AILERON OTBD L/E HAS A GOUGE. R & R RT AILERON L/E SHROUD IAW SRM 51-42-06 AND DWG 601R13031-166. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702.SDR ASOA2014020509893Angle · crackedASD AFT ANGLE CRACKED. COMPLIED WITH REF 601R-52-11-513. COMPLIED WITH EC/TC REO 601R-52-11-513.SDR ASOA2014020509892Support Bracket · crackedTWO SUPPORT BRACKETS CRACKED ON EMERGERCY EXIT FWD RT INTERNAL STRUCTURE. REMOVED SUPPORT BRACKET ON CREW ESCAPE HATCH IAW SRM 51-42-06 AND 57-42-13. INSTALLED NEW SERVICEABLE STOP SUPPORT FITTING ON CREW ESCAPE HATCH IAW SRM 51-42-06 AND 51-42-13 AND DWG 60SDR ASOA2014020509891Rib · crackedLEFT MLG WHEEL WELL BATTERY RIB CRACKED. COMPLIED WITH REO 601R-57-51-046. COMPLIED WITH REO 601R-57-51-016. RECEIVED AND COMPLIED WITH EC/TC REO 601R-57-51-046 AS WRITTEN.SDR ASOA2014011709771Attach Fitting · gougedFOUR GOUGED LUGS IN PAX DOOR HINGE. COMPLIED WITH REO 601R-52-11-1347 AND ECTC REO 601R-52-11-1347. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW IAW SOP 5702.SDR ASOA2014020509890Bracket · crackedBRACKET AT FAIRING 161EL IS CRACKED. R & R BRACKET IAW SRM 51-42-06-00 AND SRM 51-42-15-00 IAW DWG 601R31037.SDR ASOA2014020509889Bracket · crackedBRACKET FOR FAIRING 162DL IS CRACKED. REMOVED CRACKED BRACKET IAW SRM 51-42-06, PG 11. INSTALLED BRACKET IAW SRM 51-42-06 AND 51-42-10 AND DWG 601R31037-48.SDR ASOA2014020509888Light · inoperativeDOOR EXIT SIGN BETA LIGHTS FAILED FUNCTIONAL TEST ON PAX DOOR, SERVICE DOOR, LT OVERWING EMERGENCY EXIT DOOR AND RT OVERWING EXIT DOOR. INSTALLED PAX DOOR AND SERVICE DOOR BETA LIGHTS IAW AMM 33-51-09, TASK 33-51-09-400-801. R & R BETA LIGHTS ON LT AND RT OVSDR ASOA2013123109729Warning Message · illuminatedCARGO BOTTLE LOW CAUTION MESSAGE IN FLIGHT. ACFT DIVERTED.SDR ASOA2013122009669Lamp · burned outAFT LEFT EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP AND OPS CHECKED GOOD IAW AMM 33-51-00.SDR ASOA2013072408758Cover · looseCOVER ON EMERGENCY EXIT LIGHT AT MAIN CABIN DOOR FALLING OFF. REPLACED EMERGENCY EXIT LIGHT ASSY IAW AMM 33-51-19, OPS CHECKS OK.SDR ASOA2012101002338Lanyard · out of positionPAX DOOR WOULD NOT OPEN FROM OUTSIDE. CLEARED DOOR RAIL LANYARD FROM RAILING. PERFORMED OPS CHECK OF PAX DOOR IAW AMM 52-11-00. OPS CHECK OK AT THIS TIME. SDR CLOSED.SDR ASOA201200508Placard · peelingEMERGENCY EXIT ARROW PLACARD, PASSENGER DOOR, PEALING OFF. R & R PLACARD IAW AMM 11-30-00.SDR ASOA201200087Sign · inoperativeEMERGENCY EXIT LIGHTED PLACARD FORWARD OF SERVICE DOOR INOPERATIVE. R & R PLACARD WITH SERVICEABLE UNIT IAW AMM 33-51-00-710-804 & 25-31-01-400-802. OPS CHECKED GOOD.SDR ASOA201200076Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE. R & R NR 4 EMERGENCY LIGHTS BATTERY PACK REF AMM 33-51-04-400-801. OPS CHECKED GOOD IAW AMM 33-51-04-710-801.SDR ASOA201200075Battery Pack · inoperativeEMERGENCY LIGHTS ARE INOPERATIVE AT EMERGENCY EXIT DOORS. R & R NR 4 EMERGENCY LIGHTS BATTERY PACK REF AMM 33-51-04-400-801. OPS CHECKED GOOD IAW AMM 33-51-04-710-801.SDR ASOA201200064Frame · corrodedGROUND WIRE STUD AT FS 333, STGR 26R HAS CORROSION. INSTALLED FRAME SEGMENT IAW SRM 51-42-06 AND 51-42-21.SDR ASOA201200063Threshold · corrodedSERVICE DOOR SILL IS CORRODED FROM FS 319.70 -349.00. REPAIRED IAW AMM 51-23-00 AND SRM 51-25-06.SDR ASOA201200061Angle · corrodedSERVICE DOOR THRESHOLD LOWER ANGLE FWD AND AFT ATTACH ANGLE CORRODED. BLENDED AFT ANGLE AND FOUND OUT OF LIMITS IAW SRM 51-21-06 AND SRM 53-00-00. REPLACED FWD ANGLE IAW SRM 51-42-06.SDR ASOA201200017Sill · corrodedRIGHT FLOOR SILL CORRODED FROM FS 349.00 - 369.00. REMOVED AND INSTALLED SILL IAW SRM 51-42-06 AND 51-42-21 AND EC/TC, REO 601R-53-21-326.SDR ASOA201200059Skin · dentedDENT FOUND ON RT WING AT WS 252.8 L/E 4.3750" X 1.5"W .040 DEEP FOUND ON WALK AROUND . REPAIRED IAW REO 601R-57-41-797.SDR ASOA201102450Frame · corrodedFRAME FS 349 CORRODED BETWEEN S24L TO 24R. REMOVED CORROSION.SDR ASOA201102449Intercostal · corrodedINTERCOSTAL FS 349.00 CORRODED. REMOVED LIGHT SURFACE CORROSION FROM INTERCOSTAL IAW SRM 51-21-06. REPAIR IS CLASSIFIED AS MINOR.SDR ASOA201102448Frame · corrodedFRAME FS 364.00, CORRODED FWD SIDE BEWTEEN ST 26L AND 26R. REMOVED CORROSION FROM FRAME IAW SRM 51-21-06. FOUND TO BE WITHIN LIMITS IAW SRM 51-21-06. APPLIED ALODINE, PRIMER & TOP COAT IAW SRM 51-21-11.SDR ASOA201102447Rib · crackedRIB CRACKED BESIDE NUTPLATE FOR LT PYLON ACCESS PANEL 412AB. REPAIRED IAW REO 601R-54-61-073.SDR ASOA201102438Floorbeam · crackedANGLE CRACKED, FS 280, LBL 9 INBD SIDE OF FLOORBEAM. REMOVED CRACKED ANGLE IAW SEM 51-42-20. FABRICATED NEW ANGLE IAW REO 601R-53-11-171, ITEM 8. NDT TO ENSURE CLIP CRACK FREE. COMPLIED WITH STEP 8B OF EC/TC REO 601R-53-11-171 IAW NDTM PART 1, 51-20-08. NSDR ASOA201200005Rib · crackedLEFT OTBD FLAP INBD CLOSING RIB HAS A CRACK NEAR T/E. REMOVED AND REPLACED FLAP IAW AMM 27-54-05-400-801.SDR ASOA201102428Attach Fitting · crackedATTACH FITTING ON RT SIDE OF AFT REAR PRESSURE BULKHEAD AT APPROX 3 O'CLOCK POSITION IS CRACKED. DRILLED NEW ATTACH FITTING IAW SRM 51-40-11. INSTALLED ATTACH FITTING IAW SRM 51-42-21. REPAIR IS CLASSIFIED AS MAJOR.SDR ASOA201102405Support · corrodedSERVICE DOOR THRESHOLD, CENTER SUPPORT CORRODED. CORROSION IS BEYOND 10 PERCENT THICKNESS. REPLACED SUPPORT IAW SRM 51-42-21. REPAIR IS CLASSIFIED AS MINOR.SDR ASOA201102404Support · corrodedRT WINDSCREEN SUPPORT CORRODED. FOUND OUT OF LIMITS & BEYOND 30 PERCENT OF SUFACE. DRILLED NEW WINDSCREEN SUPPORT TO FIT SURROUNDING STRUCTURE IAW SRM 51-40-11. INSTALLED WINDSCREEN SUPPORT BRACKET IAW SRM 51-42-06, 51-42-21 AND 51-42-13. REPAIR IS CLASSDR ASOA201200016Sill · corrodedPAX CABIN LEFT SILL HAS MINOR CORROSION ON NUTPLATE AT FS 559.0. REMOVED NUTPLATE IAW SRM 51-42-02. REMOVED CORROSION IAW SRM 51-21-06. PERFORMED UT THICKNESS INSPECTION OF BLEND AREA IAW MAC NDT PROCEDURE UT-3. MIN MATERIAL REMAINING IS .039" ORIGINAL .0SDR ASOA201200004Sill · corrodedRIGHT FLOOR SILL FS 310-319 CORRODED RBL45. REMOVED SECTION OF RT FLOOR SILL FROM FS 310 -319 BLENDED DAMAGE ORIGINAL MATERIAL .063 REMAINING MATERIAL .041 REF SRM 51-21-06. DAMAGE FOUND OUT OF LIMITS REF SRM 53-00-00. INSTALLED NEW SILL SECTION & NEW SILSDR ASOA201200003Seat Track · wornCOPILOTS LEFT SEAT TRACK IS WORN. CHECK LIMITS IAW SRM 53-11-49. FOUND TO BE OUT OF LIMITS MORE THAN 10 PERCENT MATERIAL LOSS, IAW SRM 53-11-49, FIG 101, SHT 2. REMOVED CO-PILOTS INBD SEAT TRACK ALL WORK DONE IAW AMM 53-01-01-000-801. LOCATED HOLES IN NEW SESDR ASOA201200002Seat Track · wornCAPTAIN'S LEFT SEAT TRACK IS WORN. CHECK LIMITS IAW SRM 53-11-49, FIG 101, SHT 2. FOUND TO BE OUT OF LIMITS MORE THAN 10 PERCENT MATERIAL LOSS, IAW SRM 53-11-49, FIG 101, SHT 2. REMOVED PILOTS OTBD SEAT TRACK ALL WORK DONE IAW AMM 53-01-01-000-801. LOCATED HSDR ASOA201102394Beam · corrodedTRANSVERSE BEAM FS 349 AND RBL 45 CORRODED ON TOP LEG OF BEAM. REMOVED AND REPLACED IAW SRM 51-42-06 AND SRM 51-42-21.SDR ASOA201102393Doubler · corrodedDOUBLER ON INBD SIDE OF SERVICE DOOR THRESHOLD HAS CORROSION AT FWD & AFT CORNERS OF DOOR SURROUND AT FS 320 & 348. REMOVED AND INSTALLED DOUBLER IAW SRM 51-42-06. REQUIRES SDR.SDR ASOA201102392Fitting · corrodedFITTING CORRODED AT FS 349 ON UPPER FRAME LEG AT FLOOR LEVEL. REMOVED AND INSTALLED FITTING IAW SRM 51-42-21. REPAIR IS CLASSIFIED AS MAJOR.SDR ASOA201102391Fitting · corrodedFITTING CORRODED AT FS 319.70 ON UPPER FRAME LEG AT FLOOR LEVEL. REMOVED AND REPLACED FITTING IAW SRM 51-42-21.SDR ASOA201102390Floor Support · corrodedFLOOR SUPPORT AT FS 319.70, RBL 45 LOWER FWD CORNER OF SERVICE DOOR SURROUND CORRODED. REMOVED AND INSTALLED REF SRM 51-40-11 AND SRM 51-42-21. REPAIR IS CLASSIFIED AS MAJOR.SDR ASOA201102389Floor Support · corrodedFLOOR SUPPORT ANGLE AT THE SERVICE DOOR IS CORRODED ON THE UNDERSIDE AT FS 319.70. SUPPORT ANGLE WAS R & R.SDR ASOA201102388Floor Support · corrodedCABIN FLOOR SUPPORT HAS CORROSION AT FLOOR PANEL. REMOVED FLOOR SUPPORT IAW SRM 51-42-06, CORROSION EXCEEDS ALLOWABLE DAMAGE IAW SRM 53-00-00. INSTALLED NEW FLOOR SUPPORT IAW SRM 51-20-11 & 51-42-06. REPAIR IS CLASSIFIED AS A MAJOR REPAIR.SDR ASOA201102387Seat Track · corrodedSEAT TRACK CORRODED BETWEEN FLOOR PANELS 281DLF AND 281JLF. CLEANED CORROSION FROM SEAT TRACK, MAX MATERIAL LOSS AT 0.0215, MAX ALLOWABLE IS 0.020. FOUND OUT OF LIMITS IAW SRM 53-21-49. R & R SEAT TRACK IAW AMM 53-01-11-04. REPAIR IS CLASSIFIED AS MAJOR.SDR ASOA201102386Seat Track · corrodedSEAT TRACK CORRODED BETWEEN FLOOR PANELS 281KLF & 281ELF. CLEANED CORROSION FROM SEAT TRACK MAX MATERIAL LOSS AT 0.0215 MAX ALLOWABLE IS 0.020. OUT OF LIMITS IAW SRM 53-21-49. R & R SEAT TRACK IAW AMM 53-01-11-04. REPAIR IS CLASSIFIED AS MAJOR.SDR ASOA201200058Bulkhead · gougedAFT PRESSURE BULKHEAD AT FS621.00 HAS A GAUGE ON A BRACKET ADJACENT TO CARGO DOOR TRACK. BLENDED DAMAGED BRACKET IAW SRM 51-12-00. PERFORMED NDT INSPECTION IAW REO 601R-53-61-4350 IAW NDTM PART 1, 51-20-06. NO INDICATIONS NOTED. REPAIRED IAW REO 601R-53-61SDR ASOA201102383Isolator · brokenAFT PRESSURE BULKHEAD FS 621.00 HAS THREE BROKEN ISOLATORS. R & R ISOLATORS IAW SRM 51-42-13.SDR ASOA201102373Floorbeam · corrodedCARGO FLOORBEAM AT FS 621.00 AND BETWEEN RBL 27-45 CORRODED. BLENDED CORROSSION IAW SRM 51-21-06. ORIGINAL MATERIAL .093 MINIMUM REMAINING MATERIAL IS .089 FOUND TO BE IN LIMITS REF SRM 53-00-00. RESTORED FINISH TO AREA REF SRM 51-21-16.SDR ASOA201200057Angle · corrodedSERVICE DOOR SILL IS CORRODED FROM FS 319.7 - 349. BLENDED CORROSION IAW SRM 51-21-06. REMOVED IAW SRM 53-00-00. INSTALLED THRESHOLD LOWER ANGLE IAW SRM 51-40-11 & 51-42-06.
Back to N844AS, cancelled Jul 30, 2018