N927AN
Service difficulty reports · 180
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 = 'N927AN' 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 = 'N927AN' 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 AALA20170628007Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON FORWARD CARGO FLOOR RIGHT TRANSITION PANEL AT FUSELAGE STATION 426, RBL24. REMOVED AND REPLACED TRANSITION PANEL IAW SRM 51-40-02 AND DRAWING 143A8126.SDR AALA20170627008Splice · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON R1 DOOR CREASE BEAM SPLICE VERTICAL SURFACE BETWEEN FUSELAGE STATIONS 296 AND 302, RBL55. REMOVED AND REPLACED SPLICE IAW AARD 51-00-05-1 AND DRAWING 141A8310.SDR AALA20170627007Strap · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON CABIN FLOOR WEB STRAP AT FUSELAGE STATION 1022, RBL4. REMOVED AND REPLACED STRAP IAW AARD 51-00-05-1 AND DRAWING 147A5714.SDR AALA20170627006Web · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON AFT GALLEY FLOOR WEB AT FUSELAGE STATION 1024, BETWEEN RBL24 AND RBL37, BELOW THE BARRIER SEAL. REMOVED AND REPLACED WEB IAW SRM 51-40-02, AARD 51-00-05-1 AND DRAWING 147A5712.SDR AALA20170702007Floor Support · crackedA CRACK WAS FOUND ON THE CABIN LATERAL FLOOR SUPPORT CHANNEL AT BS 540, RBL 2. REMOVED AND REPLACED THE FLOOR SUPPORT IAW MANUFACTURER DOCUMENT 143A5240 AND DWG 51-00-05-1.SDR AALA20170702006Floor Support · crackedCRACK ON CABIN LATERAL FLOOR SUPPORT CHANNEL AT BS 540, LBL 2. REMOVED AND REPLACED SUPPORT CHANNEL IAW MANUFACTURE DOCUMENT 143A5240 AND DWG 51-00-05-1.SDR AALA20170223014Slide · dislodgedAIRCRAFT WAS NOT GROUNDED. R1 DOOR EMERGENCY EVACUATION SLIDE FOUND DISLODGED BY CATERING. REMOVED AND REPLACED SLIDE IAW SIC 25-94-11. OPERATIONAL CHECK GOOD.SDR AALA20170130009Latch · brokenAIRCRAFT WAS GROUNDED. R1 DOOR EMERGENCY EVACUATION SLIDE GIRT RELEASE LATCH IS BROKEN. REMOVED AND REPLACED LATCH IAW MCM CARD 25-94-11. OPERATIONAL CHECK GOOD.SDR AALA20161129024Slide · out of positionAIRCRAFT NOT GROUNDED. FLIGHT ATTENDANT REPORTED L1 DOOR EVACUATION SLIDE PACK PARTIALLY PROTRUDING FROM COVER AT ONE CORNER DUE TO GIRT BAR APRON FLIPPED. RESTOWED GIRT BAR APRON IAW AMM 25-66-01. OPERATIONAL CHECK GOOD.SDR AALA20160713023Sensor · faultyDURING TAKE OFF ROLL THE LEADING EDGE IN TRANSIT LIGHT ILLUMINATED. TAKE OFF WAS ABORTED AT LESS THAN 10 KNOTS. AIRCRAFT GROUNDED. FSEU BIT CHECK RETURNED FAULT MESSAGE F1 PROXIMITY RETRACT AND MAINTENANCE MESSAGE 27-81216. IAW FIM 27-88-00-810-805, REMOVED ASDR AALA20160210009Bulkhead · crackedLEFT MLG WW FWD BULKHEAD, CRACKED 5 INCHES BELOW UPPER PRESS DECT AT LBL 41. REPAIR ACCOMPLISHED IAW EA 257680 DATED 2 5 2016. ACFT IN BASE MX.SDR AALA20160208006Bulkhead · crackedRIGHT MLG WW FWD BULKHEAD CRACKED 4 INCHES BELOW PRESS DECK AT RBL 37. REPAIR ACCOMPLISHED IAW EA 257680 DATED 2 5 2016. ACFT IN BASE MX.SDR AALA20160208003Skin · corrodedCORROSION AT STATION 540, STRINGER 22R. REPAIR ACCOMPLISHED IAW EA257822 DATED 05 FEB 2016. ACFT IN BASE MX.SDR AALA20160205007Bulkhead · crackedHFEC INSPECTION INDICATES CRACK RT MLG WW FWD BULKHEAD, 5" BELOW PRESS DECK AT RBL 30". INSTALLED REPAIR WEB DOUBLER IAW EA 257680, DRAFT NR 5. ACFT IN BASE MX.SDR AALA20160124004Intercostal · crackedAIRCRAFT WAS IN BASE MX. INTERCOSTAL AT LBL 45, BETWEEN FS 328 & 344 IS CRACKED. R & R INTERCOSTAL IAW AARD 51-00-05 R1 & DWG 141A5400 & AARD 51-00-05-R1.SDR AALA20160124003Intercostal · crackedAIRCRAFT WAS IN BASE MX. INTERCOSTAL AT LBL 11, BETWEEN FS 344 & 360 IS CRACKED. R & R INTERCOSTAL IAW AARD 51-00-05 R1 & DWG 141A5400.SDR AALA20151231005Switch · out of adjustALL THREE LG DID NOT RETRACT AFTER TAKEOFF. RESETTING THE MANUAL GEAR EXTENSION DOOR, IAW QRH, ALLOWED THE GEAR TO BE RAISED NORMALLY. THE FLIGHT CONTINUED & LANDED WITHOUT FURTHER INCIDENT. FOUND MANUAL EXTENSION SYS ACCESS DOOR SWITCH OUT OF ADJUSTMENT. SDR AALA20150920011Sign · brokenAFT GALLEY EMER EXIT SIGN BROKEN. R & R AFT GALLEY EMER EXIT SIGN IAW MM 33-51-01. OPERATIONALLY CHECKED NORMAL.SDR AALA20140905003Wire Harness · defectiveSEAT 19DEF EMER LIGHT INOPERATIVE. REPLACED SEAT TO WALL HARNESS. OPERATIONS CHECKED NORMAL.SDR AALA20140110013Intercostal · crackedINTERCOSTAL CRACKED AT CABIN FLOORBOARD ATTACH HOLE BETWEEN STATIONS 328 & 344 AT LBL 45. INSTALLED NEW INTERCOSTAL AT CABIN FLOORBOARD BETWEEN STATIONS 328 & 344 IAW SRM 53-10-51-01-2.SDR AALA20140110012Intercostal · crackedINTERCOSTAL CRACKED AT CABIN FLOORBOARD ATTACH HOLE BETWEEN STATIONS 312 & 328 AT LBL 45. INSTALLED NEW INTERCOSTAL AT CABIN FLOORBOARD BETWEEN STATIONS 312 & 328 IAW SRM 53-10-51-0I-2.SDR AALA20130709006Seat Track · crackedFOUR CRACKS INDICATED IN FORWARD SEAT TRACK AT STATION 727B & LBL 45.50. ACCOMPLISHED REPAIR IAW EA B737-53-030580.SDR AALA20130518001Transmitter · failedCREW REPORTED FLAPS WOULD NOT EXTEND AND HAD TO EXTEND ELECTRICALLY. FLIGHT LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED RT FLAP POSITION TRANSMITTER T428. SYS GROUND CHECK NORMAL OPERATION.SDR AALA20130512005Fseu · inoperativeSEA - CREW REPORTED UNABLE TO FULLY DEPLOY FLAPS DURING LANDING. EMERGENCY DECLARED FLIGHT LANDED SEA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED FLAP/SLAT ELECTRONICS UNIT. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20130509013Lens · missingSEAT 14DEF EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR SEAT 14DEF EMERGENCY LIGHT.SDR AALA20130509008Light · missingSEAT 14DEF EMERGENCY LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 14DEF EMERGENCY LIGHT.SDR AALA20130120003Flap · puncturedLEFT INBOARD TRAILING EDGE FLAP HAS PUNCTURE MEASURING 1/4 INCH. ACCOMPLISHED HOT BOND REPAIR PER SRM 57-53-01-2R-4 AND 51-70-10.SDR AALA20111203TUL02Vapor Barrier · crackedLEFT VAPOR BARRIER CRACKED 16.5 INCHES, LEFT WING REAR SPAR AREA. INSTALLED REPAIR STRAPS AND ANGLES AT BAYS 5L, 7L, AND 8L, PER SRM 57-10-10-2R 2, AND EA B737-57-0174466 DATED 6/13/2011.SDR AALA20111203TUL01Vapor Barrier · crackedTHREE INCH CRACK IN LEFT VAPOR BARRIER BETWEEN BAYS L2 & L4, LEFT WING REAR SPAR. INSTALLED REPAIR STRAPS AND ANGLES PER SRM 57-10-10-2R 2.SDR AALA20111129TUL09Trans Panel · corrodedTHE RIGHT TRANSITION PANEL AFT OF CARGO DOOR OPENING HAS CORROSION IN THE FORWARD CARGO. REMOVED AND REPLACED THE TRANSITION PANEL.SDR AALA20111129TUL05Fitting · crackedTHE RIGHT BAFFLE CLIP AFT OF 500H AND STRINGER 26 RIGHT IS CRACKED. REMOVED AND REPLACED THE BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA20111129TUL02Fitting · crackedTHE RIGHT HAND BAFFLE CLIP FORWARD OF 500H AND STRINGER 26 RIGHT IS CRACKED. REMOVED AND REPLACED THE BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA20111128TUL02Door Frame · gougedEMERGENCY EQUIPMENT DOOR JAMB, LEFT WEB GOUGED. REPLACED DAMAGED WEB PER AARD 51-00-05-1.SDR AALA20111126TUL02Intercostal · damagedCABIN FLOOR INTERCOSTAL STATION 328 TO 344 DAMAGED. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-10-02-OG.SDR AALA20111126TUL01Intercostal · crackedCABIN FLOOR INTERCOSTAL STATION 312 TO 328 CRACKED. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-10-02-0G.SDR AALA20111123TUL12Angle · corrodedANGLE ON TOP OF THE FLOOR WEB, AFT OF THE RIGHT FORWARD GALLEY ANCHOR BLOCK AT STATION 993 AND RIGHT BUTTLINE 32 CORRODED. REMOVED AND REPLACED THE ANGLE PER AARD 51-00-05-1.SDR AALA20111123TUL10Floor Support · corrodedFLOORBOARD SUPPORT FLANGE AFT OF THE RIGHT NUMBER 2 DOOR AT STATION 993 AND RIGHT BUTTLINE 45 CORRODED. REMOVED AND REPLACED THE SUPPORT FLANGE PER AARD 51-00-05-1.SDR AALA20111123TUL09Strap · corrodedTHE CENTER FLOOR WEB STRAP FORWARD OF AFT BULKHEAD AT STATION 1006 HAS CORROSION. REMOVED AND REPLACED THE STRAP PER SRM 51-10-2.SDR AALA20111122TUL06Shear Tie · crackedSHEAR TIE IS CRACKED AT STATION 500I. REMOVED AND REPLACED THE SHEAR TIE PER AARD 51-00-05-1.SDR AALA20111122TUL04Floorbeam · corrodedCORROSION ON FRAME STATION 328 AT RIGHT BUTTLINE 48. REPAIRED THE T CHORD PER SRM 53-10-51-2R.SDR AALA20111121TUL10Angle · corrodedCORROSION TOP SIDE OF CREASE ANGLE VERTICAL SECTION STATIONS 980 TO 993 RIGHT BUTTLINE 46. REMOVED AND REPLACED RIGHT AFT CREASE ANGLE PER SRM 51-10-2.SDR AALA20111121TUL06Angle · corrodedCORROSION ON TOP SIDE OF CREASE ANGLE VERTICAL SECTION STATION 980 TO 993 AND RIGHT BUTTLINE 46. REMOVED AND REPLACED THE CREASE ANGLE PER SRM 51-10-02.SDR AALA20111121TUL05Floorbeam · corrodedCORROSION AT RIGHT BUTTLINE 43 ON THE BODY STATION 986 FLOORBEAM. REPAIRED THE FLOORBEAM PER SRM 53-70-51-2R.SDR AALA20111121TUL02Panel · corrodedTHE LEFT TRANSITION PANEL IN FORWARD CARGO IS CORRODED AT STATIONS 500 TO 475. REPAIRED PANEL PER SRM 53-00-53.SDR AALA20111117TUL13Rail · crackedSTATION 400 RIGHT AIR CONDITIONING ATTACH RAILS CRACKED. REPLACED NESTED ANGLE PER ECO J1159AD.SDR AALA20111117TUL12Rail · crackedSTATION 727D RIGHT AIR CONDITIONING ATTACH RAILS CRACKED. REPLACED NESTED ANGLE PER ECO J1159AD.SDR AALA20111117TUL10Rail · crackedSTATION 867 RIGHT AIR CONDITIONING ATTACH RAILS CRACKED. REPLACED NESTED ANGLE PER ECO J1159AD.SDR AALA20111117TUL11Frame · crackedCRACK INDICATED IN FRAME AT AC RAIL ATTACH BRACKET AT STATION 500A. FRAME REPAIRED PER ECO J1159AD.SDR AALA20111117TUL09Frame · crackedCRACK INDICATED AT FRAME AT AC RAIL ATTACH BRACKET AT STATION 480L. FRAME REPAIRED PER ECO J1159AD.SDR AALA20111117TUL08Frame · crackedCRACK INDICATED IN FRAME AT AC RAIL ATTACH BRACKET AT STATION 440L. FRAME REPAIR COMPLETED PER ECO J1159AD.
Back to N927AN